Update Records (Deprecated)
Use Update Record for new workflows. Recreate the column mappings and filter. The current activity can update all matching rows and exposes Updated Records Count.
Keep the existing node when maintaining a legacy workflow until its mappings and downstream bindings have been migrated and tested. The current activity is a replacement, not a drop-in change to the old output schema.
Description
The Update Records activity modifies existing records in a specified database table based on defined filter criteria. It enables controlled, automated updates during workflow execution.
Common settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
Design-Time Configuration
The following properties define how the activity connects to the database and updates records.
Connection Type
Specifies the database engine (for example, SQL Server, Oracle, MySQL). Selecting the correct type ensures compatibility with the target database.
Connection Name
Select a preconfigured database connection that defines the server, credentials, and security settings.
Schema
Specifies the database schema that contains the target table.
Table Name
Specifies the name of the database table where records will be updated.
Filter
Defines the conditions that determine which records are updated. Filters are built using the Filter Expression builder.
Column Mapping
Defines how workflow values are mapped to database columns for the update operation using the Schema Mapper.
Only the mapped columns will be updated for the records that match the filter criteria.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the update operation to complete. The default value is 600 seconds.
Outputs
Affected Records Count
Returns the number of records successfully updated in the target table.
This value can be used for:
- Validation
- Reporting
- Conditional workflow logic
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.