CustomerSubscriptionInstancesSales_DataSeats: Tixly itgen_tixly_customersubscriptioninstancessales_dataseats_plural
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: itgen_tixly_customersubscriptioninstancessales_dataseats_plural
Fetches the subscription instances for a specific customer.
Can only retrieve data.
Summary
Fetches the subscription instances for a specific customer.
API Source
- Endpoint:
/customers/{id}/subscriptioninstances - Operation:
get /customers/{id}/subscriptioninstances
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Id of the customer |
Table Columns
The columns of the table CustomerSubscriptionInstancesSales_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: