Typeform
Typeform is a cloud-based solution for online form building and online surveys. The solution is designed for companies of all sizes. Typeform features survey design, where users can design customized surveys simply via the drag-and-drop interface.
Data integration: Skyvia supports importing data to and from Typeform, exporting Typeform data to CSV files, replicating Typeform data to relational databases, and synchronizing Typeform data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Typeform.
Query: Skyvia Query supports Typeform.
Typeform-Specific Features and Limitations
Skyvia has the following limitations for Typeform:
-
In the Data Integration product, Typeform connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Typeform in your package.
- Skyvia supports DML operations for such Typeform objects:
- INSERT, UPDATE, DELETE: Forms, Themes.
- INSERT, DELETE: Images, Webhooks, Workspaces.
- Skyvia supports Replication with Incremental Updates for the Forms and Webhooks objects only.
- Skyvia supports Synchronization for the Forms object only.
-
When loading data to Images object, you can either specify image URL in the Url field or specify its content in the base64 encoding in the Image field. Note that the base64-encoded value must not contain descriptors, such as
data:image/png;base64
. Include only the base64 code, for example:iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAIAAAAC64paAAAAG0lEQVR42mOccuMbA7mAcVTzqOZRzaOaB1YzABKjL70rq/b4AAAAAElFTkSuQmCC
- When inserting data to the Webhooks object, if there already is a record with the specified value in the Tag field, then that record will be updated. If there is no record with the value in the Tag field yet, such a record will be inserted.
- When performing an update operation for the Forms object, all the writable fields are updated. If no value is specified, an empty value is assigned for the field. That’s why all the fields that should not be empty are marked as Required for the Update operation.
-
When performing the insert operation to the Forms object, you need to specify the value for the Fields field as a JSON array. For example:
[{"title":"SampleTitle","ref":"01FWEFASVQD8C8WMZGYZN7FRD8","properties":{"randomize":false,"allow_multiple_selection":false,"allow_other_choice":false,"vertical_alignment":true,"choices":[{"ref":"01FWEFASVQY5BY4V0FSFKWMA4T","label":"Choice A"},{"ref":"01FWEFASVQDQDHKWQ9614GKSWM","label":"Choice B"},{"ref":"46b5f210-c95b-440a-aef1-13f155c2efa4","label":"Choice CC"}]},"validations":{"required":false},"type":"multiple_choice","layout":{"type":"split","attachment":{"type":"image","href":"https://images.typeform.com/images/WMALzu59xbXQ"}}}]
Typeform Connections
To create a connection to Typeform, you simply need to sign in to Typeform via OAuth 2.0. The OAuth authentication token is stored on the Skyvia server. Your Typeform account login and password are not stored on the Skyvia server.
- Click +NEW in the top menu.
- Click Connection in the menu on the left to open the Select Connector page.
- In the opened pane, click Typeform.
- In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
- Click Sign In with Typeform.
-
In the opened window, enter the email and password used when signing up to Typeform.
- Click Accept to continue.
-
The authentication token is generated. Use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Suppressing Extended Requests
For some objects, Typeform API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.
To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Typeform because Typeform API does not return them without extended requests.
Supported Actions and Actions Specifics
Typeform connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
-
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.