Execute Update Activity
The Execute Update activity enables users to run a specified SQL query against a connected database. This activity is primarily used for Data Manipulation Language (DML) operations such as INSERT, UPDATE, or DELETE, processing the query and returning metadata about the execution.
| Field | Description | Requirement |
|---|---|---|
| Connection name | Specifies the name of the pre-configured database connection to use. | Required |
| Param1 | Defines the value for the first parameter in the SQL query. | Optional |
| Param2 | Defines the value for the second parameter in the SQL query. | Optional |
| Param3 | Defines the value for the third parameter in the SQL query. | Optional |
| Param4 | Defines the value for the fourth parameter in the SQL query. | Optional |
| Param5 | Defines the value for the fifth parameter in the SQL query. | Optional |
| Parameters | Allows defining multiple parameters as a list of lists for the SQL query. | Optional |
| Query sql | The SQL query to be executed on the database. | Required |
| Result dataset name | A unique name for the dataset that will store the query execution metadata. | Required |
Action Types & Examples
Query Result Dataset
- Format: Dataset
- Example Result:
employeesDataset
Implementation Examples
Field Setup - Connection name: robustaConnection - Query sql: insert into rpa_turkey_tablo2 (Ad,Soyad,Sirket_Adi,Unvan) values(':1',':2',':3',':4'); - Result dataset name: employeesDataset
Execution Parameters - Param1: ['1', 'STRING', 'in', '2314589'] - Param2: ['2', 'STRING', 'in', '${companyName}'] - Param3: ['3', 'STRING', 'in', '${companyName}'] - Param4: ['4', 'STRING', 'in', '${companyName}'] - Param5: ['5', 'STRING', 'in', '${companyName}'] - Parameters: [['1', 'STRING', 'in', '2314589'], ['2', 'STRING', 'in', '${companyName}']]
Technical Notes
This activity is designed for Data Manipulation Language (DML) operations such as INSERT, UPDATE, or DELETE. It does not typically return a result set in the same way a SELECT query would, but rather the number of affected rows or a confirmation of execution. The 'Result dataset name' field will store metadata about the execution rather than row data for DML operations.