invantive documentation
Invantive Support ForumsLog In / Sign Up

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
includeCoupons ``
SoldFrom `` 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
CreatedUTCUnix int64 itgen_tixly_createdutcunix filters on the platform, writable, CreatedUTCUnix
CustomerId int32 Customer ID filters on the platform, writable, CustomerId
Entrance varchar2 Entrance filters on the platform, writable, Entrance
EventGroupId int32 Event Group ID filters on the platform, writable, EventGroupId
EventId int32 Event ID filters on the platform, writable, EventId
EventOrganisationId int32 itgen_tixly_eventorganisationid filters on the platform, writable, EventOrganisationId
Fee double Fee filters on the platform, writable, Fee
InsideFee double itgen_tixly_insidefee filters on the platform, writable, InsideFee
IsAnonymousSale char Is Anonymous Sale filters on the platform, writable, IsAnonymousSale
IsPrivateProperty char itgen_tixly_isprivateproperty filters on the platform, writable, IsPrivateProperty
Online char Online filters on the platform, writable, Online
OrderId int32 Order ID filters on the platform, writable, OrderId
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, OrderUrl
OrganisationID int32 Organisation ID filters on the platform, writable, OrganisationID
Price double Price filters on the platform, writable, Price
PriceZone varchar2 Price Zone filters on the platform, writable, PriceZone
PriceZoneId int32 Price Zone ID filters on the platform, writable, PriceZoneId
Row varchar2 Row filters on the platform, writable, Row
SaleTicketId int32 itgen_tixly_saleticketid filters on the platform, writable, SaleTicketId
SaleUserId int32 itgen_tixly_saleuserid filters on the platform, writable, SaleUserId
SaleUserName varchar2 itgen_tixly_saleusername filters on the platform, writable, SaleUserName
Scanned char Scanned filters on the platform, writable, Scanned
ScannedDate datetime itgen_tixly_scanneddate filters on the platform, writable, ScannedDate
ScannedDateUTCUnix int64 itgen_tixly_scanneddateutcunix filters on the platform, writable, ScannedDateUTCUnix
ScannedUserId int32 itgen_tixly_scanneduserid filters on the platform, writable, ScannedUserId
ScannedUserName varchar2 itgen_tixly_scannedusername filters on the platform, writable, ScannedUserName
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
SubscriptionId int32 itgen_tixly_subscriptionid filters on the platform, writable, SubscriptionId Deprecated: Use SubscriptionInstanceId instead. This property will be removed in a future version.
SubscriptionInstanceId int32 itgen_tixly_subscriptioninstanceid filters on the platform, writable, SubscriptionInstanceId
SubscriptionTypeId int32 Subscription Type ID filters on the platform, writable, SubscriptionTypeId
TicketCount int32 Ticket Count filters on the platform, writable, TicketCount
TicketId int32 Ticket ID filters on the platform, writable, TicketId
TicketType varchar2 Ticket Type filters on the platform, writable, TicketType
TicketTypeId int32 Ticket Type ID filters on the platform, writable, TicketTypeId

Release Notes

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