Event_AllReservedTickets: Tixly itgen_tixly_event_allreservedtickets_plural
read only REST
- Catalog:
Tixly - Schema:
Event - Label: itgen_tixly_event_allreservedtickets_plural
Fetches all the reserved 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 the reserved 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/reservations - Operation:
get /events/reservations
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Date |
`` | If this is set, then only get sales after this date | ||
DateTo |
`` | If this is set, then only get sales before this date | ||
include |
`` |
Table Columns
The columns of the table Event_AllReservedTickets 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 |
||
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, Created |
||
Created |
int32 |
itgen_tixly_createduserid | filters on the platform, writable, Created |
||
Created |
varchar2 |
itgen_tixly_createdusername | filters on the platform, writable, Created |
||
Customer |
int32 |
Customer ID | filters on the platform, writable, Customer |
||
Deleted |
datetime |
Deleted | filters on the platform, writable, Deleted |
||
Deleted |
int64 |
itgen_tixly_deletedutcunix | filters on the platform, writable, Deleted |
||
Deleted |
int32 |
itgen_tixly_deleteduserid | filters on the platform, writable, Deleted |
||
Deleted |
varchar2 |
itgen_tixly_deletedusername | filters on the platform, writable, Deleted |
||
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 |
||
Is |
char |
itgen_tixly_isanonymousreservation | 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 |
||
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 |
||
Seat |
varchar2 |
Seat | filters on the platform, writable, Seat |
||
Section |
varchar2 |
Section | filters on the platform, writable, Section |
||
Subscription |
int32 |
Subscription Type ID | filters on the platform, writable, Subscription |
||
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: