Seat Geek Export

This document outlines the structure, delivery, and format of the Seat Geek data export.

Requesting Access

To request access to Seat Geek exports for your integration, please contact customer support with the following information:

  • Client ID
  • Desired destination (S3 bucket details)
  • Desired export frequency

Export Destinations

 Amazon S3

Exports are delivered directly to your Amazon S3 bucket as CSV files.

 Export Types

Full Exports: each export contains the complete dataset of all relevant Seat Geek data.

 Data Formats

Exports are available in CSV format. The export is delivered as a ZIP file containing the data file.

Export Data

Three entities can be exported from the Seat Geek database and they can be set up independently:

  • The customer entity
  • The sales_item entity
  • The access_control_barcode_usage_data entity

Customer data entity

Field NameField Type
first_namestring
last_namestring
middle_namestring
emailstring
source_system_user_idstring
source_system_guidstring
source_system_idstring
last_updateddate
birthdaydate
genderstring
address_line_1string
address_line_2string
address_line_3string
city_namestring
country_namestring
state_namestring
zip_codestring
mobile_numberstring
is_activeboolean
is_deceasedboolean
created_atdate
updated_atdate

Sales Item Entity

Field NameField Type
idstring
source_system_idstring
source_system_sales_idstring
client_codestring
client_guidstring
confirmation_datedate
application_channelstring
associated_client_idstring
associated_with_benefitboolean
holder_tenant_idstring
user_first_namestring
user_middle_namestring
user_last_namestring
user_emailstring
user_guidstring
user_idstring
event_guidstring
event_categorystring
event_datedate
event_namestring
external_idstring
product_instance_idstring
price_type_namestring
price_type_idstring
price_level_idstring
item_pricenumber
listing_pricenumber
item_type_descriptionstring
item_type_numbernumber
linking_product_guidstring
transaction_guidstring
transaction_numbernumber
transaction_issuer_company_idstring
transaction_notestring
transaction_local_idstring
payment_method_namestring
group_order_guidstring
group_order_idstring
id_in_transactionstring
accountstring
complimentarystring
extra_productstring
modified_reservationstring
reservedboolean
validboolean
reservation_expiry_datedate
area_guidstring
area_namestring
blockstring
stand_namestring
seat_namestring
row_namestring
original_service_specific_idstring
row_versionnumber
transaction_datedate
membership_start_datedate
membership_end_datedate
entity_guidstring
created_atdate
updated_atdate

Access Control Barcode Usage Data Entity

Field NameField Type
idstring
source_system_idstring
actionstring
barcodestring
client_idstring
event_idstring
is_first_scanboolean
reference_entity_idstring
reference_entity_namestring
scan_datedate
scan_succeededboolean
ticket_idstring
local_idstring
created_atdate
updated_atdate