The Sympla connector lets you extract data from Sympla into Dataddo and sync it to any dashboard, database, or data warehouse. It covers your events, the orders placed for them, and the individual participants.
Refer to our website for the list of available metrics and attributes you can extract from Sympla.
If you have multiple Sympla accounts and would like to extract the same data from all of them, it's possible through multi-account extraction. Contact our Solutions team to enable this feature.
Authorize Connection to Sympla
Before you can create a data source, connect Dataddo to your Sympla account. You need your Sympla API token. To find it, log in to your Sympla account and go to Account > Settings.
- In Dataddo, go to Authorizers and click Authorize New Service.
- Select Sympla.
- Fill in the connection details:
| Field | Details |
|---|---|
| Label | A name for this authorizer in Dataddo. |
| Token | Your Sympla API token. |
- Click Save.
Data Coverage
The connector offers the datasets below. The example fields are a representative sample. Each dataset has more fields, and you choose which ones to extract when you create the source.
| Dataset | Description | Example fields | Date range |
|---|---|---|---|
| Events | Events created by the organiser on the Sympla platform, including venue, host, and category details. | ID, Address, Address Complement, City, Country, Latitude (+20 more) | No |
| Orders | Orders (purchases or registrations) placed by buyers across all events on the Sympla platform. | ID, Approved Date, Buyer Email, Buyer First Name, Buyer Last Name, Discount Code (+25 more) | Yes |
| Participants | Individual ticket holders across all events, including check-in status and ticket details. | ID, Access Information, Checked In, Check-in Date, Email, Event ID (+17 more) | Yes |
You do not need to pick an event. For Orders and Participants, Dataddo automatically goes through all events in your account and pulls the records for each one.
How Data Extraction Works
The Events dataset has no date range. Every run pulls all events that are currently available in your account.
Orders and Participants use a relative date range, for example "last 7 days". The range is passed to Sympla as the report's from and to dates. Every run re-reads that window against the current date, so the window slides forward over time. Each run replaces the window's data, it does not accumulate older history. To load data from before the window, run a full data re-sync with a wider range. See Data Backfilling.
To build a complete order or participant history in your destination, schedule the source and use the append or upsert write mode with the dataddo_hash column.
Metadata Columns
You can add two optional Dataddo metadata columns to any Sympla dataset:
dataddo_hashis a fingerprint of each record's key fields. It works as a natural key and is ideal for upserts.dataddo_extraction_timestampis the time the record was extracted. Use it to track slowly changing dimensions.
How to Create a Sympla Data Source
- In Dataddo, go to Sources and click Create Source.
- Search for Sympla and select it.
- Pick the dataset you want to extract.
- Choose your Sympla authorizer.
- Name the data source and select the fields to extract.
- Set the date range for Orders or Participants.
- Click Test Data to preview the data.
- Click Save.
Troubleshooting
No Data Preview
If Test Data shows no preview:
- Try a smaller or different date range. The selected period may have no orders or participants.
- Check that your Sympla API token is still valid.
Note that the preview reads only a small sample of your events. The full extraction after saving covers all of them.
Related Articles
Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.
Sending Data to Dashboarding Apps
Sending Data to Data Storages
Other Resources