Jotform

Jotform is a powerful, user-friendly tool for managing online forms.

Data integration: Skyvia supports importing data to and from Jotform, exporting Jotform data to CSV files, and replicating Jotform data to relational databases.

Backup: Skyvia Backup does not support Jotform backup.

Query: Skyvia Query supports Jotform.

Establishing Connection

To establish a connection to Jotform in Skyvia, you have to specify the API key, data center location and compliance with HIPAA.

Getting Credentials

To obtain the API Key, you have to log in to Jotform and perform the following actions:

  1. Click on your account avatar in the top right corner of the page.
  2. Click Settings and select API.
  3. Click Create New Key and copy the generated API Key.

api

Creating Connection

connect to jotform

  1. Paste the obtained key into the API Key box in Skyvia.
  2. Select the data center. The US value is selected by default. You can switch it to Europe.
  3. Specify if your account is HIPAA compliant.

Connector Specifics

Object Peculiarities

FormSubmissionAnswers and UserSubmissionAnswers

These tables contain the submitted answers to the forms. When selecting from them, the submitted answers may return in different result columns depending on the question type. The majority of the submitted answers return in the Answers column.

Folders and Subfolders

The root folder properties are stored returned in the RootFolder table. This table is read-only.

The Folders table contains the folder. The subfolders list is stored in the Subfolders field as an array. For user convenience, the array values of the Subfolders field are represented as a separate Subfolders table. This table stores the subfolders of the first nesting level. The folders of further nesting levels are stored in the Subfolders field of the Subfolders table.

You can move the forms from one folder to another when performing the UPDATE operation against the Folders and Subfolders tables. To do this, you have to map the Forms field, providing the Id’s of the forms to be moved in the following format: ["223172341365349", "223172341365350"].

Forms

The records are not actually deleted when performing the DELETE operation against the Forms table. Their status changes to Deleted in this case.

FormSubmissions

When importing data to the FormSubmissions table, you must map the Answers field and provide its values in JSON object format as pairs “question number”: “answer”, for example: {"1": "answer to question 1", "2": "Samantha James", "3": "42"}.

Incremental Replication and Synchronization support

Replication with Incremental Updates is supported for the following objects: FormReports, Forms, FormSubmissions, User, UserReports, UserSettings, UserSubmissions.

Synchronization is not supported for Jotform.

DML Operations Supports

Operation Object
INSERT, UPDATE, DELETE Folders, FormQuestions, Subfolders
INSERT, DELETE FormReports, Forms, FormSubmissions

Stored procedures

Use call CloneForm(:formId) to clone the existing form. You can use a call to the stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow.

Supported Actions

Skyvia supports all the common actions for Jotform.

On This Page