Jotform + Webhooks by Zapier + SQL Server Integrations

How to connect Jotform + Webhooks by Zapier + SQL Server

Zapier lets you send info between Jotform and Webhooks by Zapier and SQL Server automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

Free forever for core features
14 day trial for premium features & apps

Do even more with Jotform + Webhooks by Zapier + SQL Server

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Jotform, Webhooks by Zapier, and SQL Server. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- FormRequired
Trigger
Instant
Try It
- Select a formRequired
  Select a form to assign
- Asignee emailRequired
  Enter your assignee’s email address
- Invitation Message
  Include an invitation message
- Assignee Permission
  Let assignees submit only, submit and view submissions later, or submit and edit submissions later
Action
Write
- Select a formRequired
  Select a form to create submissions for
Action
Write
- Api Docs Info
  API docs for Jotform are located here http://api.jotform.com/docs/
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
Catch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Trigger
Instant
Try It

- MethodRequired
  The HTTP method we'll use to perform the request.
- URLRequired
  Any URL with a querystring will be re-encoded properly.
- Data Pass-Through?
  If yes, request data below will be overridden with the raw data from the previous step (you are still responsible for headers though, like Content-Type). Defaults to no.
- Data
  Place raw data for the request here. Could be JSON, XML, etc. Nothing is parsed for you here (including extra line breaks or spaces -- everything is sent verbatim). You probably need to define a header below corresponding to your data Content-Type. Reminder: data provided in this field is completely ignored if you chose "yes" to pass-through.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write
- URLRequired
  Any URL with a querystring will be re-encoded properly.
- Payload Type
  Pay special attention to the proper mapping of the data below.
- Data
  These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
- Wrap Request In Array
  Wraps the request in an array if that is something the service requires.
- File
  A file object to be attached to the request. The request will automatically be converted to multipart/form-data, with the above payload type defining the sub content-type for the data being passed.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
  Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
  Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
- Trigger Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search

- DocumentRequired
Trigger
Scheduled
Try It
- Select a formRequired
  Select a form to assign
- Assignee emailRequired
  Enter your assignee’s email address
- Invitation Message
  Include an invitation message
- Prefilled Field Permissions
  Make pre-populated fields read only or editable
Action
Write
- Owner
  Determines which App Extensions will appear in the dropdown below.
- App ExtensionRequired
Action
Write
- URLRequired
  This should return a list of dictionaries of content type JSON in reverse chronological order. For example: [{"id":1234},{"id":1235}]
- Key
  If the returned JSON is not a list and is instead an object (maybe paginated), enter the key that contains the results. Example: "results", "items", "objects", etc... (children via dot syntax supported)
- Deduplication Key
  Zapier deduplicates the array we see each poll against the id key. If the id key does not exist, you should specify an alternative unique key to deduplicate off of. If neither are supplied, we fallback to looking for the shortest key with id in it otherwise we will raise an error.
- Xpath
  If the content fetched is XML or HTML, optionally define an xpath to extract data from the content. Will trigger whenever the content at the xpath changes!
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Trigger
Scheduled
Try It
- Pick off a Child Key
  By default, Zapier gives you the entire payload of the webhook. If this is specified, Zapier will only grab the child key from the object(s) sent to Zapier. For example, given {"contact": {"name": "Mike"}}, add "contact" here to only return {"name": "Mike"}. Traverse more deeply nested children by using dot-separated syntax. Line item payloads will run your Zap for each instance of the child key.
Trigger
Instant
Try It
- URLRequired
  We recommend not putting any query string arguments in the URL (use "Query String Params" below).
- Query String Params
  These params will be URL-encoded and appended to the URL when making the request. Note: If you specify nothing for this field, we will automatically encode and include every field from the previous step in the query string. If you don't want this, use the "Custom Request" action.
- Send As JSON
  If "yes", this dumps the results directly to a key (set below) as JSON. If "no", we simulate a form.
- JSON key
  Only used if As JSON.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write
- URLRequired
  Any URL with a querystring will be re-encoded properly.
- Payload Type
  Pay special attention to the proper mapping of the data below.
- Data
  These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
- Wrap Request In Array
  Wraps the request in an array if that is something the service requires.
- File
  A file object to be attached to the request. The request will automatically be converted to multipart/form-data, with the above payload type defining the sub content-type for the data being passed.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write
- Table/ViewRequired
  We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
- Order By
  Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].
- Dedupe Key
  We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How Jotform + Webhooks by Zapier + SQL Server Integrations Work

Step 1: Authenticate Jotform, Webhooks by Zapier, and SQL Server.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Jotform + Webhooks by Zapier + SQL Server

About Jotform

The newly redesigned Jotform lets you build forms faster than ever, with powerful widgets and a responsive editor that works offline—without even needing to sign up for an account.

Related categories

Forms & Surveys

Similar apps

Wufoo

Forms & Surveys

Formstack

Forms & Surveys

Typeform

Forms & Surveys

About Webhooks by Zapier

Webhooks simply POST data (or JSON) to a specific URL every time we see something new. Webhooks can also accept data (or JSON) to kick off a workflow in Zapier.

Related categories

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Jotform + Webhooks by Zapier + SQL Server Integrations

How to connect Jotform + Webhooks by Zapier + SQL Server

Do even more with Jotform + Webhooks by Zapier + SQL Server

New Submission

Assign Form

Select a formRequired

Asignee emailRequired

Invitation Message

Assignee Permission

Create Submission

Select a formRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Catch Raw Hook

Custom Request

MethodRequired

URLRequired

Data Pass-Through?

Data

Unflatten

Basic Auth

Headers

POST

URLRequired

Payload Type

Data

Wrap Request In Array

File

Unflatten

Basic Auth

Headers

New Column

Table/ViewRequired

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

New Signed Document

DocumentRequired

Assign Prefilled Form

Select a formRequired

Assignee emailRequired

Invitation Message

Prefilled Field Permissions

App Extensions (Beta)

Owner

App ExtensionRequired

Retrieve Poll

URLRequired

Key

Deduplication Key

Xpath

Basic Auth

Headers

Catch Hook

Pick off a Child Key

GET

URLRequired

Query String Params

Send As JSON

JSON key

Unflatten

Basic Auth

Headers

PUT

URLRequired