On This Page
Typeform is an online survey management solution. You can use Typeform for free, or use one of the paid plans which offer more features. It provides a web-based platform that allows you to easily create surveys, forms, apps, and quizzes. The typeforms you create are stored and organized in workspaces. You can add multiple workspaces in your account, and categorize your typeforms accordingly.
Hevo uses the Typeform’s APIs to ingest data from your account and load it into the desired Destination database or data warehouse. For this, you must authorize Hevo with your Typeform credentials.
- An active Typeform account.
Configuring Typeform as a Source
Perform the following steps to configure Typeform as the Source in your Pipeline:
Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Typeform.
In the Configure your Typeform account page, click + ADD TYPEFORM ACCOUNT.
Sign in using your Typeform credentials.
Click Accept to authorize Hevo to access your Typeform account.
In the Configure your Typeform Source page, specify the following:
Pipeline Name: A unique name for your Pipeline, not exceeding 255 characters.
Historical Sync Duration: The duration for which the existing data in the Source must be ingested.
Select Workspaces: The workspaces in your Typeform account, from which you want to ingest the data.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.
|Default Pipeline Frequency||Minimum Pipeline Frequency||Maximum Pipeline Frequency||Custom Frequency Range (Hrs)|
|1 Hr||1 Hr||48 Hrs||1-48|
Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.
Historical Data: In the first run of the Pipeline, Hevo ingests historical data for the Responses object only, on the basis of the historical sync duration selected at the time of creating the Pipeline and loads it to the Destination. Default duration: 6 Months
Incremental Data: Once the historical load is complete, every subsequent run of the Pipeline fetches any new and updated records in the Source data and loads it to the Destination. Incremental load is available for the Responses object only. Refer to the Data Model section below.
- Form insights is a special object that is fetched only for Typeform users with a paid plan, therefore, this table shows up in the Destination only for users who have a paid Typeform account.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination database:
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
Note: Hevo performs a Full Load of the Forms, Themes, and Workspaces objects, and their respective child objects.
|Workspaces||Contains the list of all workspace IDs you have access to.|
|Workspace||Contains the details of a single workspace.|
|Forms||Contains a list of the JSON descriptions for all the forms in your Typeform account.|
|Form||Contains the details of a single form.|
|Form Insights||Contains the form level and individual question level insights of a form.
Note: This object is fetched only for premium Typeform users.
|Responses||Contains the form responses, and the date and time of the form landing and submission.|
|Themes||Contains a list of all the themes in your Typeform account.|
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|