Actions32
Row → Upsert
AI-generatedSummary
Upsert a row in a specified table by checking for an existing row matching a field value; update the matching row if found, otherwise create a new row with the provided field values.
Inputs
- Base Name or ID (required) — Select the base containing the table to use, either from the dropdown or via an expression.
- Table Name or ID (required) — Select the table where the row will be upserted, either from the dropdown or via an expression.
- Match Field Name or ID (required) — Specify the field used to identify existing rows; the node checks this field's value to find a match.
- Match Value (required) — The value to look for in the match field to determine if an existing row should be updated.
- Field Values (required) — One or more field-value pairs to set on the row being created or updated. Choose each field and specify its value.
Output shape
A single record representing the created or updated row.
If a row with the specified match field value exists, it is updated with the provided field values and returned. Otherwise, a new row is created with those values and returned. The output includes the full row data as provided by the API's response.