invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerSubscriptionSalesByCustomerId: Tixly Customer Subscription Sales by Customer ID

read only REST

  • Catalog: Tixly
  • Schema: Customer
  • Label: Customer Subscription Sales by Customer ID

Fetches the subscriptions from a specific customer.

⚠️ Deprecated Notice
This endpoint is scheduled for removal on 1st of March 2026. Please migrate to the /customers/{id}/subscriptioninstances endpoint instead.

Can only retrieve data.

Summary

Fetches the subscriptions from a specific customer.

⚠️ Deprecated Notice
This endpoint is scheduled for removal on 1st of March 2026. Please migrate to the /customers/{id}/subscriptioninstances endpoint instead.

API Source

  • Endpoint: /customers/{id}/subscriptions
  • Operation: get /customers/{id}/subscriptions

Parameters

Name Data Type Required Default Documentation
id `` Id of the customer

Table Columns

The columns of the table CustomerSubscriptionSalesByCustomerId 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
CreatedUTCUnix int64 itgen_tixly_createdutcunix filters on the platform, writable, CreatedUTCUnix The date and time in Unix time (also known as POSIX time or Epoch time) when the subscription was sold
CustomerId int32 Customer ID filters on the platform, writable, CustomerId The id of the customer
CustomerName varchar2 Customer Name filters on the platform, writable, CustomerName The name of the customer
Id int32 ID filters on the platform, writable, Id A unique id for the specific subscription
Name varchar2 Name filters on the platform, writable, Name The name of the subscription
OrderId int32 Order ID filters on the platform, writable, OrderId The id of the Order
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, OrderUrl The encrypted order id to be used in url's to create a purchase link for reservations or a receipt link for sales
OrganisationID int32 Organisation ID filters on the platform, writable, OrganisationID Will be removed from future releases, Id should not both be upper case kept it for backward compatibility and use OrganisationId instead
OrganisationId_2 int32 itgen_tixly_organisationid_2 filters on the platform, writable, OrganisationId The id of the organisation that owns the subscription
Price double Price filters on the platform, writable, Price The price of the subscription for the selected seat
RowName varchar2 itgen_tixly_rowname filters on the platform, writable, RowName The name of the row of the primary hall in the subscription
SeatName varchar2 itgen_tixly_seatname filters on the platform, writable, SeatName The name of the seat of the primary hall in the subscription
SectionName varchar2 itgen_tixly_sectionname filters on the platform, writable, SectionName The name of the section of the primary hall in the subscription
SubscriptionTypeId int32 Subscription Type ID filters on the platform, writable, SubscriptionTypeId The id of the subscription
TicketCount int32 Ticket Count filters on the platform, writable, TicketCount Total number of tickets in the subscription
TicketIds varchar2 itgen_tixly_ticketids filters on the platform, writable, TicketIds The ticket ids of the tickets that are in the subscription

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: