CustomerEventSalesAllocationsByCustomerId: Tixly Customer Event Sales Allocations by Customer ID
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: Customer Event Sales Allocations by Customer ID
Fetches the events that a specific customer has one or more tickets to. Does not include events where he has reserved tickets to or returned all tickets from.
Can only retrieve data.
Summary
Fetches the events that a specific customer has one or more tickets to. Does not include events where he has reserved tickets to or returned all tickets from.
API Source
- Endpoint:
/customers/{id}/events - Operation:
get /customers/{id}/events
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Id of the customer |
Table Columns
The columns of the table CustomerEventSalesAllocationsByCustomerId 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 |
|---|---|---|---|---|---|
Abbreviation |
varchar2 |
Abbreviation | writable, Abbreviation |
The abbreviation of the allocation type on the event | |
Account |
varchar2 |
itgen_tixly_accountnumber | filters on the platform, writable, ::ancestor. |
||
Admin |
varchar2 |
itgen_tixly_adminname | filters on the platform, writable, ::ancestor. |
||
Allocated |
int32 |
Allocated | filters on the platform, writable, ::ancestor. |
||
Allocation |
int32 |
itgen_tixly_allocationtypeid | writable, Allocation |
The unique id of the allocation type | |
Available |
char |
Available Online | filters on the platform, writable, ::ancestor. |
||
Block |
char |
Block | writable, Block |
Is the allocation type blocked, meaning that they are excluded from the capacity of the event | |
Blocked |
int32 |
Blocked Allocated | filters on the platform, writable, ::ancestor. |
||
Capacity |
int32 |
Capacity | filters on the platform, writable, ::ancestor. |
||
Created |
datetime |
Created | writable, Created |
||
Created |
int64 |
itgen_tixly_createdutcunix | writable, Created |
||
Created |
int64 |
itgen_tixly_createdutcunix_2 | filters on the platform, writable, ::ancestor. |
||
Created_ |
datetime |
itgen_tixly_created_2 | filters on the platform, writable, ::ancestor. |
||
Date |
char |
Date Confirmed | filters on the platform, writable, ::ancestor. |
||
Department |
varchar2 |
itgen_tixly_departmentnumber | filters on the platform, writable, ::ancestor. |
||
Dimension1 |
varchar2 |
itgen_tixly_dimension1 | filters on the platform, writable, ::ancestor. |
||
Dimension2 |
varchar2 |
itgen_tixly_dimension2 | filters on the platform, writable, ::ancestor. |
||
Dimension3 |
varchar2 |
itgen_tixly_dimension3 | filters on the platform, writable, ::ancestor. |
||
Dimension4 |
varchar2 |
itgen_tixly_dimension4 | filters on the platform, writable, ::ancestor. |
||
Dimension5 |
varchar2 |
itgen_tixly_dimension5 | filters on the platform, writable, ::ancestor. |
||
Dimension6 |
varchar2 |
itgen_tixly_dimension6 | filters on the platform, writable, ::ancestor. |
||
Dimension7 |
varchar2 |
itgen_tixly_dimension7 | filters on the platform, writable, ::ancestor. |
||
Dimension8 |
varchar2 |
itgen_tixly_dimension8 | filters on the platform, writable, ::ancestor. |
||
Edited |
datetime |
Edited | filters on the platform, writable, ::ancestor. |
||
Edited |
int64 |
itgen_tixly_editedutcunix | filters on the platform, writable, ::ancestor. |
||
End |
datetime |
End Date | filters on the platform, writable, ::ancestor. |
||
End |
int64 |
itgen_tixly_enddateutcunix | filters on the platform, writable, ::ancestor. |
||
Event |
int32 |
itgen_tixly_eventallocationid | writable, Event |
The unique id of the allocation type on the specific event | |
Event |
varchar2 |
Event Group | filters on the platform, writable, ::ancestor. |
||
Event |
int32 |
Event Group ID | filters on the platform, writable, ::ancestor. |
||
Expires |
int32 |
Expires Hours Before | writable, Expires |
How many hours before the event does the allocation type expire | |
External |
varchar2 |
itgen_tixly_externalreferencenumber | filters on the platform, writable, ::ancestor. |
||
Hall |
varchar2 |
Hall | filters on the platform, writable, ::ancestor. |
||
Hall |
int32 |
itgen_tixly_hallconfigurationid | filters on the platform, writable, ::ancestor. |
||
HallId |
int32 |
Hall ID | filters on the platform, writable, ::ancestor. |
||
Id |
int32 |
ID | writable, Id |
The Id is the same as AllocationTypeId and is the unique id of the allocation type that was used, the name and expirations can be changed per event and therefore to be able to map the specific allocations to seats then use the EventAllocationId as that's unique per allocation and the event where it's used. | |
Id_2 |
int32 |
itgen_tixly_id_2 | filters on the platform, writable, ::ancestor. |
||
Is |
char |
Is Free Event | filters on the platform, writable, ::ancestor. |
||
Is |
char |
Is Numbered | filters on the platform, writable, ::ancestor. |
||
Name |
varchar2 |
Name | writable, Name |
The name of the allocation type on the event | |
Name_2 |
varchar2 |
itgen_tixly_name_2 | filters on the platform, writable, ::ancestor. |
||
Online |
char |
Online Reservation Allowed | filters on the platform, writable, ::ancestor. |
||
Organisation |
int32 |
Organisation ID | filters on the platform, writable, ::ancestor. |
||
Promoter |
varchar2 |
Promoter | filters on the platform, writable, ::ancestor. |
||
Promoter |
int32 |
Promoter ID | filters on the platform, writable, ::ancestor. |
||
Reserved |
int32 |
Reserved | filters on the platform, writable, ::ancestor. |
||
Reserved |
int32 |
Reserved Tickets | writable, Reserved |
Total number of seats reserved in the allocation | |
Sale |
int32 |
Sale Status ID | filters on the platform, writable, ::ancestor. |
||
Season |
varchar2 |
Season | filters on the platform, writable, ::ancestor. |
||
Season |
int32 |
Season ID | filters on the platform, writable, ::ancestor. |
||
Seats |
int32 |
Seats | writable, Seats |
Total number of seats that have the allocation | |
Sold |
int32 |
Sold | filters on the platform, writable, ::ancestor. |
||
Sold |
int32 |
Sold Tickets | writable, Sold |
Total number of seats sold in the allocation | |
Start |
datetime |
Start Date | filters on the platform, writable, ::ancestor. |
||
Start |
int64 |
itgen_tixly_startdateutcunix | filters on the platform, writable, ::ancestor. |
||
Sub |
varchar2 |
Subtitle | filters on the platform, writable, ::ancestor. |
||
Vat |
double |
VAT | filters on the platform, writable, ::ancestor. |
||
Venue |
varchar2 |
Venue | filters on the platform, writable, ::ancestor. |
||
Venue |
int32 |
Venue ID | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: