ThingWorx Flow > Out-of-the-Box Services, Utilities, and Devices > Services > SQL Connector > Update Rows
Update Rows
Use the Update Rows action to update rows in the database.
Complete the following steps to use the Update Rows action in your workflow:
1. Drag the Update Rows action under SQL Connector to the canvas, place the pointer on the action, and then click or double-click the action. The Update Rows window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add an SQL connector type, refer to Supported SQL Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid SQL connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the Table list, select the appropriate database table where you want to update the rows.
You can update multiple rows at a time.
7. In the Where Clause Using list, do one of the following:
If you chose Selection in the Where Clause Using list
a. Under the Where group, in the Join Clauses by list, select one of the following options:
◦ AND—All conditions specified under the Attributes group must return true.
◦ OR—Either of the conditions specified under the Attributes group must return true.
* 
If you do not select any condition under the Where group, the action updates all rows in the selected table.
b. Under the Attributes group, click Add, and do the following:
a. In the Attribute list, select the column that you want to filter.
b. In the Operator list, select the appropriate conditional operator.
c. In the Value field, enter the value of the column for the filter.
Click Add to add multiple columns. Click to delete any column that you added.
If you add the same attributes and select AND in the Join Clauses by list, the attributes are joined by the OR operator.
OR
If you chose Query in the Where Clause Using list
In the Where Clause field, enter all required inputs in following SQL Query format:
column1 = 'text value' AND column2 >= 13
* 
If you do not specify any condition, the action updates all rows in the selected table.
8. Select Form to provide inputs for individual input fields listed in the form, or select Assign JSON to specify a single JSON with all required inputs.
If you chose Form
Under the Set Columns group, do the following:
a. In the Column list, select the column for which you want to add a value for the row that you updated.
* 
If there is a NOT NULL constraint on any columns in the table, ensure that you specify values for those columns. These columns are listed as required fields in the Column list.
b. In the Value field, enter the value that you want to add in the selected column.
If the column has an existing value, and you want to remove the value from this column, specify the Value field as <NULL>.
Click Add to add multiple columns. Click to delete any column that you added.
OR
If you chose Assign JSON
In the Set Columns field, enter all required inputs in the [{"column":"string", "value":"string"}] format.
9. Click Done.
Output schema
The output schema for the Update Rows action returns a message string and a count with the number of rows that have been updated.
Was this helpful?