Typeform

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.


Prerequisites

  • An active Typeform account.

Configuring Typeform as a Source

Perform the following steps to configure Typeform as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Typeform.

  4. In the Configure your Typeform account page, click + ADD TYPEFORM ACCOUNT.

    Add Typeform account

  5. Sign in using your Typeform credentials.

    Sign in to your Typeform accoutn

  6. Click Accept to authorize Hevo to access your Typeform account.

    Authorize Hevo

  7. In the Configure your Typeform Source page, specify the following:

    Configure your Typeform Source

    • 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.

  8. Click TEST & CONTINUE.

  9. Proceed to configuring the data ingestion and setting up the Destination.


Data Replication

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.


Source Considerations

  • 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:


Data Model

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.

Object Description
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.

Note: The Full Load objects may lead to higher Events quota consumption.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
May-24-2022 1.89 New document.
Last updated on 21 Jun 2022