Subscription_Instances_DataSeats: Tixly itgen_tixly_subscription_instances_dataseats_plural
read only REST
- Catalog:
Tixly - Schema:
Subscription - Label: itgen_tixly_subscription_instances_dataseats_plural
Gets all subscription instanct sales that you have access to. Pass in the DateFrom and DateTo parameters to get sales within a specific date range Please read the model description as one property will be removed on the 1st of September 2025
Can only retrieve data.
Summary
Gets all subscription instanct sales that you have access to. Pass in the DateFrom and DateTo parameters to get sales within a specific date range Please read the model description as one property will be removed on the 1st of September 2025
API Source
- Endpoint:
/subscriptions/instances - Operation:
get /subscriptions/instances
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Date |
`` | If this is set, then only get sales after this date | ||
DateTo |
`` | If this is set, then only get sales before this date |
Table Columns
The columns of the table Subscription_Instances_DataSeats are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
The date and time when the subscription was sold | |
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, ::ancestor. |
The date and time in Unix time (also known as POSIX time or Epoch time) when the subscription was sold | |
Customer |
varchar2 |
itgen_tixly_customer | filters on the platform, writable, ::ancestor. |
The name of the customer | |
Customer |
int32 |
Customer ID | filters on the platform, writable, ::ancestor. |
The id of the customer | |
Events |
int32 |
itgen_tixly_events | filters on the platform, writable, ::ancestor. |
Total number of events in the subscription | |
Hall |
varchar2 |
Hall | writable, Hall |
The name of the hall in the subscription | |
Name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
The name of the subscription type | |
Order |
int32 |
Order ID | filters on the platform, writable, ::ancestor. |
The id of the Order | |
Order |
varchar2 |
itgen_tixly_orderurl | filters on the platform, writable, ::ancestor. |
The encrypted order id to be used in url's to create a purchase link for reservations or a receipt link for sales | |
Organisation |
int32 |
Organisation ID | filters on the platform, writable, ::ancestor. |
The id of the organisation that owns the subscription | |
Row |
varchar2 |
Row | writable, Row |
The name of the row of the hall in the subscription | |
Seat |
varchar2 |
Seat | writable, Seat |
The name of the seat of the hall in the subscription | |
Section |
varchar2 |
Section | writable, Section |
The name of the section of the hall in the subscription | |
Subscription |
int32 |
itgen_tixly_subscriptioninstanceid | filters on the platform, writable, ::ancestor. |
A unique id for the specific subscription instance | |
Subscription |
int32 |
Subscription Type ID | filters on the platform, writable, ::ancestor. |
The id of the subscription type | |
Ticket |
int32 |
Ticket Count | filters on the platform, writable, ::ancestor. |
Total number of tickets in the subscription | |
Ticket |
varchar2 |
itgen_tixly_ticketids | filters on the platform, writable, ::ancestor. |
The ticket ids of the tickets that are in the subscription | |
Ticket |
varchar2 |
Ticket Type | filters on the platform, writable, ::ancestor. |
Name of the ticket type that is used in the subscription | |
Ticket |
int32 |
Ticket Type ID | filters on the platform, writable, ::ancestor. |
The id of the ticket type that is used in the subscription |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: