invantive documentation
Invantive Support ForumsLog In / Sign Up

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
DateFrom `` 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.Created The date and time when the subscription was originally sold
CreatedUTCUnix int64 itgen_tixly_createdutcunix filters on the platform, writable, ::ancestor.CreatedUTCUnix The date and time in Unix time when the subscription was originally sold
Customer varchar2 itgen_tixly_customer filters on the platform, writable, ::ancestor.Customer The name of the customer
CustomerId int32 Customer ID filters on the platform, writable, ::ancestor.CustomerId The id of the customer
DeletedAt datetime itgen_tixly_deletedat filters on the platform, writable, ::ancestor.DeletedAt The date and time when the subscription instance was deleted
DeletedAtUTCUnix int64 itgen_tixly_deletedatutcunix filters on the platform, writable, ::ancestor.DeletedAtUTCUnix The date and time in Unix time when the subscription instance was deleted
Events int32 itgen_tixly_events filters on the platform, writable, ::ancestor.Events 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.Name The name of the subscription type
OrderId int32 Order ID filters on the platform, writable, ::ancestor.OrderId The id of the order that was deleted
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, ::ancestor.OrderUrl The encrypted order id to be used in url's to create a receipt link
OrganisationId int32 Organisation ID filters on the platform, writable, ::ancestor.OrganisationId 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
SubscriptionInstanceId int32 itgen_tixly_subscriptioninstanceid filters on the platform, writable, ::ancestor.SubscriptionInstanceId A unique id for the specific subscription instance
SubscriptionTypeId int32 Subscription Type ID filters on the platform, writable, ::ancestor.SubscriptionTypeId The id of the subscription type
TicketType varchar2 Ticket Type filters on the platform, writable, ::ancestor.TicketType Name of the ticket type that is used in the subscription
TicketTypeId int32 Ticket Type ID filters on the platform, writable, ::ancestor.TicketTypeId 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: