Subscription_DeletedInstances_DataSeats: Tixly itgen_tixly_subscription_deletedinstances_dataseats_plural
read only REST
- Catalog:
Tixly - Schema:
Subscription - Label: itgen_tixly_subscription_deletedinstances_dataseats_plural
Gets all deleted subscription instances that you have access to. Pass in the DateFrom and DateTo parameters to filter by deletion date.
Can only retrieve data.
Summary
Gets all deleted subscription instances that you have access to. Pass in the DateFrom and DateTo parameters to filter by deletion date.
API Source
- Endpoint:
/subscriptions/instances/deleted - Operation:
get /subscriptions/instances/deleted
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Date |
`` | If set, only instances deleted after this date will be returned | ||
DateTo |
`` | If set, only instances deleted before this date will be returned |
Table Columns
The columns of the table Subscription_DeletedInstances_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 originally sold | |
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, ::ancestor. |
The date and time in Unix time when the subscription was originally 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 | |
Deleted |
datetime |
itgen_tixly_deletedat | filters on the platform, writable, ::ancestor. |
The date and time when the subscription instance was deleted | |
Deleted |
int64 |
itgen_tixly_deletedatutcunix | filters on the platform, writable, ::ancestor. |
The date and time in Unix time when the subscription instance was deleted | |
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 that was deleted | |
Order |
varchar2 |
itgen_tixly_orderurl | filters on the platform, writable, ::ancestor. |
The encrypted order id to be used in url's to create a receipt link | |
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 |
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: