Formstack is a workplace productivity platform providing no-coding online forms, documents, and signatures. This connector works with the Forms features of Formstack. Use the Formstack Documents connector for working with the Forms feature.
Data integration: Skyvia supports importing data to and from Formstack, exporting Formstack data to CSV files, replicating Formstack data to relational databases, and synchronizing Formstack data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Formstack.
Query: Skyvia Query supports Formstack.
To connect to Formstack, perform the following steps:
In the connection editor, click Sign In with Formstack.
Enter your Formstack credentials.
Click Authorise to approve access request.
Additional Connection Parameters
Suppress Extended Requests
For the Forms and PartialSubmissions objects Formstack API returns only a 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.
The list of additional fields is the following:
To reduce the number of API calls, you can select the Suppress Extended Requests checkbox.
To successfully import data to the Fields object, you must map the required FormId and Type fields and additional fields. Additional fields needed for mapping are determined by the Type value. You can refer to Formstack documentation to find out the list of fields needed for mapping for each field type.
Skyvia does not support Formstack SCIM API objects.
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for the following objects: Forms, Portals, Smartlists, and SmartlistOptions.
Skyvia supports Synchronization for Forms, Smartlists, and SmartlistOptions objects.
DML Operations Support
|INSERT, UPDATE, DELETE||ConfirmationEmails, Fields, Folders, Forms, NotificationEmails, SmartlistOptions, Smartlists, Subfolders, Submissions, Webhooks|
Part of the Formstack functionality is implemented in Skyvia as stored procedures:
call CopyPortal(:portal_id)— copies the existing form portal.
call InviteUserForPortal(:portal_id, :emails)— invites users to a form portal.
call ModifyPortalParticipantName(:portal_id, :name)— modifies name of the portal participant.
call AddFormToSpecifiedPortal(:portal_id, :name, :formId, :deadline, :description, :notifyUsers)— adds the existing form to a portal.
Required parameters are :portal_id, :name, :formId.
call ModifySpecifiedPortalForm(:portal_id, :portalFormId, :name, :formId, :deadline, :description, :notifyUsers)— modifies the form in the portal. Required parameters are :portal_id, :portalFormId, :name, :formId.
call DeletePortalFromForm(:portal_id, :portalFormId)— removes form from a portal.
Skyvia supports all the common actions for Formstack.