Update Data Row
Update Data Row
Section titled “Update Data Row”Type: update-row · Package: DataTable Activities v1.0.5 · Output: none
Updates several columns of a row (DataRow) at once.
How it works
Section titled “How it works”Takes a { column: value } dictionary and assigns each value to its column in the row, in the order they appear. Each value is converted to its column type; a null or an empty string leaves the cell empty. Columns you don’t mention stay untouched.
Values are applied one by one: if one fails (missing column or incompatible type), the previous ones are already written. If you need all or nothing, validate the values first.
Required parameters
Section titled “Required parameters”| Parameter | Type | Default | Description |
|---|---|---|---|
row | DataRow | — | The row to modify, e.g. row. |
values | Dictionary | — | Columns to update as { column: value }. Each value accepts a literal or an expression. |
Optional parameters
Section titled “Optional parameters”None.
Output
Section titled “Output”This activity does not return a value; it modifies the row in place.
Common errors
Section titled “Common errors”| Message | Cause and fix |
|---|---|
'row' must evaluate to a DataRow. | row is not a row (for example, null). |
'values' must be an object { column: value }. | values is not a dictionary. For a list of values by position, use Add Data Row when creating the row. |
Column '…' does not exist. Available columns: …. | A dictionary key is not a column of the table. |
A value is not compatible with the type '…' of column '…'. | A value cannot be converted to its column type. |
Example
Section titled “Example”Update the status and payment date of an invoice found by number:
Find Data Row table = invoices conditions: Number equals "INV-1024" → output: row
Update Data Row row = row values: { Status: "Paid", PaidOn: today() }Related activities
Section titled “Related activities”- Set Cell — change a single column.
- Get Data Row — get the row to update by index.
- Data types › DataRow.