Update records action (batch)

The Update records batch action updates multiple records in a Workato data table you specify. This action supports up to 200 records per batch.

Update records action (batch)

Input

Field	Description
Data table	Select the Workato data table in which you plan to update records. You can view the selected data table by clicking the link in the field.
Choose the desired output format	Specify how to map the updated record data to the table fields. Refer to the Output formats section for more information.
Records	Provide the list of records to update in the specified data table. You can input a list datapill for dynamic records or define individual fields for each record.
Record ID	Provide the unique identifier for the record you plan to update. Workato automatically generates a unique ID for each record in a data table. You can retrieve the record ID by viewing the record ID column in the data table, which is hidden by default.
Record fields	Fill in the fields to update for each record.

ADDITIONAL INPUT FIELDS

Additional input fields correspond to the 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.

Ensure the values you provide match the column's data type. For instance, integer columns only accept whole numbers, and text columns accept alphanumeric characters. When updating records, invalid values cause errors and prevent the update process from completing successfully.

Refer to column types for detailed information on the accepted values for each data type.

Output

Field	Description
Records	A list of records updated in the selected data table.
Record	Details of each individual record updated, such as the Record ID, Column, Created at timestamp, and Updated at timestamp .
List size	Total number of records in the list.
List index	Position of each record in the list.