Typeform link
Updated August 16, 2023
Typeform is an online survey management solution.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| Custom data | check | EVENT and RECIPIENT tables |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | check | FORM_HISTORY, FORM_FIELD_HISTORY, FORM_FIELD_CHOICE_HISTORY, FORM_HIDDEN_FIELD_HISTORY, FORM_LOGIC_HISTORY, LOGIC_ACTION_HISTORY, and LOGIC_ACTION_CONDITION_HISTORY tables |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Typeform setup guide to connect Typeform with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Typeform connectors.
To zoom, open the ERD in a new window.Sync overviewlink
Fivetran uses Typeform REST APIs to sync your data.
We re-import the THEME, WORKSPACE, and FORM_*_HISTORY tables and their related entities in full to retrieve all data.
The Typeform API doesn't provide information about deleted records of the THEME and WORKSPACE tables and the related entities. However, as we re-import the complete tables, we can capture the deleted records. We add a _fivetran_deleted column in the destination tables to mark the records that were deleted in your source.
We perform incremental syncs to retrieve only the new responses from the RESPONSE table and related entities.
NOTE: We cannot capture deleted responses because the Typeform API doesn’t provide any information about deleted records of the
RESPONSEtable.
Sync notelink
For the FORM_*_HISTORY tables, we use the lastUpdatedAt value in the FORM table's response as the _fivetran_start value.
For example, if you update a form's logic at 2021-07-27T08:51:00.000Z and then update the form's field at 2021-07-27T08:52:00.000Z, then during the sync, we consider 2021-07-27T08:52:00.000Z as the _fivetran_start value for the records of the FORM_FIELD_HISTORY and FORM_LOGIC_HISTORY tables.