Upsert Record

Create a record, or update it if one already exists with the same primary key

Use it in a workflow

Add a step and choose the Data Table connector.
Pick the Upsert Record action (under database).
Fill in the fields below, then reference the result from later steps as {{upsertRecord.response.data}}.

tableSlugstringrequired

The data table to upsert into

datastringrequired

JSON object with the record's fields, including the primary key field(s) — those determine which record is created or updated

Creates the record if id 'order_123' doesn't exist yet, or fully replaces its data if it does

json

{
  "tableSlug": "orders",
  "data": "{\"id\": \"order_123\", \"status\": \"active\"}"
}

Need more? See the Data Table guide for connection setup and behaviour shared by every action.

Was this page helpful?