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
RESPONSE
table.
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.