Upsert Row in Table

Adds a row to an in-memory table, or replaces an existing row matched by the table's key columns. Preferred over TablePushMany for single-row writes. Requires key columns to be set on the table (via CreateTable, TableImport, or SetTableKeyColumns) unless append=true.

Category: Named Tables & Rules Engine · Group: Tables · Activity name: TableUpsertRow

Example

outputVariable = TableUpsertRow("<tableName>", {}, append=False)

Inputs

Name	Type	Required	Default	Description
Table Name	string	Yes		Name of the target table.
Row	object	Yes		Row as a flat object, e.g. {"OrderId": "A-1", "Status": "Shipped"}. Must include values for all key columns unless append=true.
Append Only	boolean		False	If true, always append the row without matching key columns. Default false performs an upsert by key columns.

Outputs

Name	Type	Description
outputVariable	json	Stores result (tableName, action: 'inserted'|'updated', totalRows).