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. To remove an existing value from a column, use the remove values from a record action instead.

Input fields

Input field	Description
Data table	The data table in which you plan to make changes.
Primary key column	Workato uses this column 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

Output field	Description
Record	The fields removed from the record, including the following fields: Record ID, Created time, and Last modified time.
Record created	This field indicates whether a new record was created or not. Workato inserts a new record if no record matched the primary key you specified. Workato updates the record if a record matched the primary key you specified.