Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.

Pick which type of object you want to search for.

Pick which type of object you want to search for.

Enter a SOQL WHERE clause. See our help docs for Tips and Examples.

Warning! This is an advanced trigger! Uses Node 10.x.x. Please read the Code documentation for more information.

Use the Input Data fields above to assign key names (left) and map values (right) from previous steps. Use notation inputData.keyName or inputData['keyName'] to access the values within your code. The data will be provided as strings. Learn more here.

Warning! This is an advanced action! Uses Node 10.x.x. Please read the Code documentation for more information.

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

Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].

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 on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.

You should include desired ordering and limiting (usually to 1 record) in the query.

This query must run in less than ~30 seconds.

Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.

API docs for Salesforce are located here https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_list.htm

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

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.

Pick which type of object you want to search for. You can only search for multiple records which are all the same object type.

Select the format of search results to be returned. If multiple search values are provided, the choice will be applied to each search value.

Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Warning! This is an advanced trigger! Please read the Code documentation for more information.

Use the Input Data fields above to assign key names (left) and map values (right) from previous steps. Use notation input_data['keyName'] to access the values within your code. The data will be provided as strings. Learn more here.

Warning! This is an advanced trigger! Please read the Code documentation for more information.

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.

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 [ ].

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.