Typeform is an online survey management solution.
|Data blocking||check||Column level|
|Fivetran data models|
Follow our step-by-step Typeform setup guide to connect Typeform with your destination using Fivetran connectors.
This schema applies to all Typeform connectors.To zoom, open the ERD in a new window.
Fivetran uses Typeform REST APIs to sync your data.
We re-import the
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
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
FORM_*_HISTORY tables, we use the
lastUpdatedAt value in the
FORM table’s response as the
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