Update record action

Updates a record in a data table. You must specify a new value for all columns you plan to update.

Input fields

Choose a data table

Select a data table where to make changes.

Record ID

The ID of the record you plan to update. Workato automatically generates a unique ID for each record in a data table. Obtain the Record ID by viewing the Record ID column in the data table, which is hidden by default.

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 update. If you do not specify a value for a field, Workato does not update its corresponding column.

Required fields/columns

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.

Specify values for all fields/columns you plan to update

Output

Record

Includes all fields from the record. 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.