CustomerSubscriptionInstancesSales: Tixly itgen_tixly_customersubscriptioninstancessales_plural
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: itgen_tixly_customersubscriptioninstancessales_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 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, Created |
The date and time when the subscription was sold | |
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, Created |
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, Customer |
The name of the customer | |
Customer |
int32 |
Customer ID | filters on the platform, writable, Customer |
The id of the customer | |
Events |
int32 |
itgen_tixly_events | filters on the platform, writable, Events |
Total number of events in the subscription | |
Name |
varchar2 |
Name | filters on the platform, writable, Name |
The name of the subscription type | |
Order |
int32 |
Order ID | filters on the platform, writable, Order |
The id of the Order | |
Order |
varchar2 |
itgen_tixly_orderurl | filters on the platform, writable, Order |
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, Organisation |
The id of the organisation that owns the subscription | |
Subscription |
int32 |
itgen_tixly_subscriptioninstanceid | filters on the platform, writable, Subscription |
A unique id for the specific subscription instance | |
Subscription |
int32 |
Subscription Type ID | filters on the platform, writable, Subscription |
The id of the subscription type | |
Ticket |
int32 |
Ticket Count | filters on the platform, writable, Ticket |
Total number of tickets in the subscription | |
Ticket |
varchar2 |
itgen_tixly_ticketids | filters on the platform, writable, Ticket |
The ticket ids of the tickets that are in the subscription | |
Ticket |
varchar2 |
Ticket Type | filters on the platform, writable, Ticket |
Name of the ticket type that is used in the subscription | |
Ticket |
int32 |
Ticket Type ID | filters on the platform, writable, Ticket |
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: