Typeform
Recurly 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.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Typeform will retrieve data only for the forms you specify in the Forms field. To retrieve the Typeform form IDs:
- In your Typeform account, navigate back to your workspaces.
- On the workspace page, click a form you want to include. This should open the form’s edit page.
- Look at the URL of the page in your browser. It should be similar to
https://admin.typeform.com/form/FrZ6iD/create. The string betweenform/and/createis the form’s ID. In this example, the ID isFrZ6iD. - Copy the form ID somewhere handy.
- Repeat steps 2-4 for every form you want to include.
Authorizing Qlik
- When prompted to log into your Typeform account and approve access to your data, click Authorize.
We will only ever read your data.
- Sign in with your Typeform account.
- Click Accept.
Setting objects to replicate
The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Typeform integrations, you can select:
Individual tables and columns
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
- Click the Finalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up Typeform, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Creating the connection
For more information, see Connecting to SaaS applications.
- Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.
| 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 |
| API Token | API token. |
| 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. |
| Refresh Token | Refresh token. |
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 |
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 |
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 |
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 |
unsubmitted_landings
The unsubmitted_landings table contains info about unsubmitted 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 | landed_at |
| Useful links |