Upsert record

Updates a record in a data table if it matches a given primary key. Otherwise, the upsert record action inserts a new record into a data table.

You must specify new values for all columns/fields you plan to update and all required columns.

Input fields

Choose a data table

Select a data table where to make changes.

Primary key column

The column Workato uses to detect whether the record already exists for a given set of fields.

Additional input fields

Additional input fields correspond to columns in the data table you select.

You must specify a new value for each column you plan to upsert. If you do not specify a value for a field, Workato does not update its corresponding column in the data table.

Required fields/columns

The values you enter in these fields must meet the conditions specified in that data table. For example, required columns appear as required fields.

Additionally, the values you enter must match the column type. For example, if a column is of an integer type, its corresponding input field in the recipe editor only accepts a whole number.

See column types for more information on the values columns/input fields accept.

---

Output

Record

Includes all fields from the object. This includes the following fields:

Record ID

The unique ID of the record.

Created time

The creation time of the record.

Last modified time

The last edit time of the record.

Record created

Whether a new record was created. If no record matched the specified primary key and Workato inserted a new record, or if a record matched the primary key, Workato updated the record.