Bulk Upsert Records

Create or update many records in one call, each matched on its own primary key

Use it in a workflow

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

Fields

tableSlugstringrequired

The data table to upsert into

recordsstringrequired

JSON array of record objects, each including the primary key field(s)

Examples

Import a batch of records

One bad row (e.g. failing a required-field check) is reported in errors without blocking the rest

json

{
  "tableSlug": "customers",
  "records": "[{\"email\": \"ada@example.com\", \"name\": \"Ada\"}, {\"email\": \"grace@example.com\", \"name\": \"Grace\"}]"
}

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

Was this page helpful?