activities
latest
false
- Overview
- Cryptography
- Database
- Java
- Python
- WebAPI
Developer Activities
Last updated Jul 3, 2025
Bulk Update
UiPath.Database.Activities.BulkUpdate
Updates a compatible
DataTable in an existing database table. The activity also updates all the columns that are not in the collection of column names used
as a primary key. Returns the number of rows affected.
Designer panel
- Configure Connection...—Select an existing database connection or add a new one using the Connection Wizard.
- Target table name—The target database table. This field supports only
Stringvariables. - Input data table—The
DataTableobject that is used in updating the table. TheDataTablecolumns descriptions must match the columns from the database table and be a subset of them. This field supports onlyDataTablevariables. - Column used for matching rows—The collection of column names used for row matching. This field supports only
String[]variables.
Properties panel
-
Common
- Continue on error—This field only supports
Booleanvalues (True, False). The default value in this field is False. As a result, if this field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error. - DisplayName—The display name of the activity. This field supports only
Stringvariables.
- Continue on error—This field only supports
-
Connection Configuration
- Bulk/batch update—Check this box to enable the creation of a temp table using Bulk insert and to update using join between tables. Otherwise, bulk updates are issued in batch.
- Connection string—The connection string used to establish a database connection. This field supports only
Stringvariables. - Existing connection—An already open database connection. If such a connection is provided, the
ConnectionStringandSecureConnectionStringproperties are ignored. This field supports onlyDatabaseConnectionvariables. - Provider name—The name of the database provider used to access the database. This field supports only
Stringvariables. - Secure connection string—The connection string used to establish a database connection as Secure String. This field supports only
SecureStringvariables.
-
Input
- Column used for matching rows—The collection of column names used for row matching. This field supports only
String[]variables. - Input data table—The
DataTableobject that is used in updating the table. TheDataTablecolumns descriptions must match the columns from the database table and be a subset of them. This field supports onlyDataTablevariables. - Target table name—The target database table. This field supports only
Stringvariables.
- Column used for matching rows—The collection of column names used for row matching. This field supports only
-
Misc
- Private—If selected, the values of variables and arguments are no longer logged at Verbose level.
-
Output
- Affected rows count—The number of updated rows. This field supports only
Int64variables.
- Affected rows count—The number of updated rows. This field supports only
- Existing connection—An already opened database connection obtained from the Connect to Database activity.
- Input data table—The
DataTablevariable that is used to update the database table. TheDataTablecolumns' name and description must match the columns from the database table and be a subset of them. - Target table name—The target database table in which the data is to be updated.
- Columns used for matching rows - The collection of column names used for row matching. These column names is be changed by the Bulk Update activity.
Advanced options
-
Other
- Continue On Error—Specifies if the automation should continue even when the activity throws an error.
-
Output
-
Affected rows count—The number of affected rows stored in an Int64 variable.
-
