EventGroupEventAllocationsByEventGroupId: Tixly Event Group Allocations by Event Group ID
read only REST
- Catalog:
Tixly - Schema:
EventGroup - Label: Event Group Allocations by Event Group ID
Gets all the events within a specific event group
Can only retrieve data.
Summary
Gets all the events within a specific event group
API Source
- Endpoint:
/eventgroups/{id}/events - Operation:
get /eventgroups/{id}/events
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | ID of the specific event group |
Table Columns
The columns of the table EventGroupEventAllocationsByEventGroupId 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: