Typeform

Typeform is a tool for collecting and organizing information. It is a web-based platform that you can use to create anything from surveys to apps.

For more information about the API, see the Typeform Create and Responses APIs.

See the Schema section for a list of objects available for replication.

A high-level look at this connector, including useful links, and supported features.

Feature/Capability	Support details
Supported Qlik Talend Data Integration projects	Replication projects only. Data pipeline projects are not supported.
Target update methods	Replication tasks: Apply changes Store changes Landing data in a data lake tasks: Change data capture (CDC)
Managing metadata	Manual metadata generation is not required.
Schema evolution	Only the Change column data type operation is supported.
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Not supported.
Scheduled CDC	Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling tasks For lake landing tasks, see Scheduling CDC for lake landing tasks
Notifications	Partially supported Setting notifications for changes in operation
Monitoring	CDC-only, as full load is not relevant for this connector. Monitoring an individual data task
Automatic denesting of JSON column payloads	Not supported. JSON column payloads in source datasets are not denested automatically on the target.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Make sure that the account you use has read access to the tables you want to fetch.

To generate your client ID and secret:

Log into your Typeform account.
Click your user avatar at the top right of the page and select Account/Your Settings.
Click the See admin settings link at the bottom left of the page.
In the Admin Settings page, click Developer Apps on the left navigation bar.
Click Edit App for the selected application. Your client ID is displayed.

Creating the connection

For more information, see Connecting to SaaS applications.

Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
Tip noteYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement.
Start Date	Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target.
Forms	Enter the names separated by a comma. Example: FrZi6D,f8nzFm. To sync all the forms, leave the field empty.
Incremental Range	Select the range from the drop-down list.
Client ID	Client ID.
Client Secret	Client secret.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 2.

Depending on your destination, table and column names may not appear as they are outlined below.

answers

The answers table contains info about the answers submitted for the forms specified in the Integration Settings page. Note: There is no replication key for this table, it uses the replication key submitted_at from its parent stream submitted_landings.

Replication Method

CDC

Primary Keys

landing_id

question_id

Useful links

Typeform documentation

Typeform API method

Join answers with	on
submitted_landings	answers.landing_id = submitted_landings.landing_id
unsubmitted_landings	answers.landing_id = unsubmitted_landings.landing_id
questions	answers.question_id = questions.question_id

_sdc_form_id

STRING

answer

STRING

data_type

STRING

landing_id

STRING

question_id

STRING

ref

STRING

submitted_at

DATE-TIME

type

STRING

forms

The forms table contains info about the forms (public and private) that are accesible by the user who authorized the integration in Stitch.

Replication Method	CDC
Primary Key	id
Replication Key	last_updated_at
Useful links	Typeform documentation Typeform API method

Join forms with	on
questions	forms.id = questions.form_id

_links

OBJECT

This is a nested data structure:

display: STRING

created_at

DATE-TIME

STRING

last_updated_at

STRING

self

OBJECT

This is a nested data structure:

href: STRING

settings

OBJECT

This is a nested data structure:

is_public: BOOLEAN
is_trial: BOOLEAN

theme

OBJECT

This is a nested data structure:

href: STRING

title

STRING

type

STRING

questions

The questions table contains a list of question titles and IDs that can be used to link to answers.

Replication Method

Full Table

Primary Keys

form_id

question_id

Useful links

Typeform API method

Join questions with	on
forms	questions.form_id = forms.id
answers	questions.question_id = answers.question_id

attachment

OBJECT

This is a nested data structure:

href: STRING
properties: OBJECT, which is also a nested data structure.
- description: STRING
scale: NUMBER
type: STRING

field_type

STRING

form_id

STRING

layout

OBJECT

This is a nested data structure:

attachment: OBJECT, which is also a nested data structure.
- href: STRING
- properties: OBJECT, which is also a nested data structure.
  - description: STRING
- scale: NUMBER
- type: STRING
placement: STRING
type: STRING

name

STRING

options

ARRAY

This is a nested data structure:

label: STRING

properties

OBJECT

This is a nested data structure:

allow_multiple_selection: BOOLEAN
allow_other_choice: BOOLEAN
alphabetical_order: BOOLEAN
button_text: STRING
choices: ARRAY, which is also a nested data structure.
- attachment: OBJECT, which is also a nested data structure.
  - href: STRING
  - type: STRING
- label: STRING
- ref: STRING
currency: STRING
default_country_code: STRING
description: STRING
fields: ARRAY
hide_marks: BOOLEAN
labels: OBJECT, which is also a nested data structure.
- center: STRING
- left: STRING
- right: STRING
price: OBJECT, which is also a nested data structure.
- type: STRING
- value: STRING
randomize: BOOLEAN
separator: STRING
shape: STRING

question_id

STRING

ref

STRING

required

STRING

sub_questions

ARRAY

This is a nested data structure:

question_id: STRING
ref: STRING
title: STRING

title

STRING

type

STRING

validations

OBJECT

This is a nested data structure:

max_length: INTEGER
max_selection: INTEGER
max_value: INTEGER
min_selection: INTEGER
min_value: INTEGER
required: BOOLEAN

submitted_landings

The submitted_landings table contains info about submitted form landings.

Note: Data related to a form landing can be retrieved twice, once in unsubmitted_landings when it is unsubmitted and once in submitted_landings when it is submitted. In this case, they will have different bookmarks.

Replication Method	CDC
Primary Key	landing_id
Replication Key	submitted_at
Useful links	Typeform API method

Join submitted_landings with	on
answers	submitted_landings.landing_id = answers.landing_id
unsubmitted_landings	submitted_landings.landing_id = unsubmitted_landings.landing_id

_sdc_form_id

STRING

browser

STRING

hidden

STRING

landed_at

DATE-TIME

landing_id

STRING

network_id

STRING

platform

STRING

referer

STRING

submitted_at

DATE-TIME

tags

ARRAY

token

STRING

user_agent

STRING

unsubmitted_landings

The unsubmitted_landings table contains info about unsubmitted form landings.

Replication Method	CDC
Primary Key	landing_id
Replication Key	landed_at
Useful links	Typeform API method

Join unsubmitted_landings with	on
answers	unsubmitted_landings.landing_id = answers.landing_id
submitted_landings	unsubmitted_landings.landing_id = submitted_landings.landing_id

_sdc_form_id

STRING

browser

STRING

landed_at

DATE-TIME

landing_id

STRING

network_id

STRING

platform

STRING

referer

STRING

response_id

STRING

token

STRING

user_agent

STRING

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here