EventTickets: Tixly Event Tickets
read only REST
- Catalog:
Tixly - Schema:
Event - Label: Event Tickets
Fetches all sold tickets to events that you have access to, pass in the SoldFrom and SoldTo to get tickets sold within a specific date range
Can only retrieve data.
Summary
Fetches all sold tickets to events that you have access to, pass in the SoldFrom and SoldTo to get tickets sold within a specific date range
API Source
- Endpoint:
/events/sales - Operation:
get /events/sales
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
include |
`` | |||
Sold |
`` | If this is set, then only get sales after this date | ||
SoldTo |
`` | If this is set, then only get sales before this date |
Table Columns
The columns of the table EventTickets 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 |
|---|---|---|---|---|---|
Barcode |
varchar2 |
itgen_tixly_barcode | filters on the platform, writable, Barcode |
||
Created |
datetime |
Created | filters on the platform, writable, Created |
||
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, Created |
||
Customer |
int32 |
Customer ID | filters on the platform, writable, Customer |
||
Entrance |
varchar2 |
Entrance | filters on the platform, writable, Entrance |
||
Event |
int32 |
Event Group ID | filters on the platform, writable, Event |
||
Event |
int32 |
Event ID | filters on the platform, writable, Event |
||
Event |
int32 |
itgen_tixly_eventorganisationid | filters on the platform, writable, Event |
||
Fee |
double |
Fee | filters on the platform, writable, Fee |
||
Inside |
double |
itgen_tixly_insidefee | filters on the platform, writable, Inside |
||
Is |
char |
Is Anonymous Sale | filters on the platform, writable, Is |
||
Is |
char |
itgen_tixly_isprivateproperty | filters on the platform, writable, Is |
||
Online |
char |
Online | filters on the platform, writable, Online |
||
Order |
int32 |
Order ID | filters on the platform, writable, Order |
||
Order |
varchar2 |
itgen_tixly_orderurl | filters on the platform, writable, Order |
||
Organisation |
int32 |
Organisation ID | filters on the platform, writable, Organisation |
||
Price |
double |
Price | filters on the platform, writable, Price |
||
Price |
varchar2 |
Price Zone | filters on the platform, writable, Price |
||
Price |
int32 |
Price Zone ID | filters on the platform, writable, Price |
||
Row |
varchar2 |
Row | filters on the platform, writable, Row |
||
Sale |
int32 |
itgen_tixly_saleticketid | filters on the platform, writable, Sale |
||
Sale |
int32 |
itgen_tixly_saleuserid | filters on the platform, writable, Sale |
||
Sale |
varchar2 |
itgen_tixly_saleusername | filters on the platform, writable, Sale |
||
Scanned |
char |
Scanned | filters on the platform, writable, Scanned |
||
Scanned |
datetime |
itgen_tixly_scanneddate | filters on the platform, writable, Scanned |
||
Scanned |
int64 |
itgen_tixly_scanneddateutcunix | filters on the platform, writable, Scanned |
||
Scanned |
int32 |
itgen_tixly_scanneduserid | filters on the platform, writable, Scanned |
||
Scanned |
varchar2 |
itgen_tixly_scannedusername | filters on the platform, writable, Scanned |
||
Seat |
varchar2 |
Seat | filters on the platform, writable, Seat |
||
Section |
varchar2 |
Section | filters on the platform, writable, Section |
||
SkinID |
int32 |
Skin ID | filters on the platform, writable, SkinID |
||
Subscription |
int32 |
itgen_tixly_subscriptionid | filters on the platform, writable, Subscription |
Deprecated: Use SubscriptionInstanceId instead. This property will be removed in a future version. | |
Subscription |
int32 |
itgen_tixly_subscriptioninstanceid | filters on the platform, writable, Subscription |
||
Subscription |
int32 |
Subscription Type ID | filters on the platform, writable, Subscription |
||
Ticket |
int32 |
Ticket Count | filters on the platform, writable, Ticket |
||
Ticket |
int32 |
Ticket ID | filters on the platform, writable, Ticket |
||
Ticket |
varchar2 |
Ticket Type | filters on the platform, writable, Ticket |
||
Ticket |
int32 |
Ticket Type ID | filters on the platform, writable, Ticket |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: