Book a demo

Update Rows

stackby.update_rows
ActionDatabases & warehousesconnection required

Calls the Stackby API with the connection's credentials.

Patch up to ten rows in place, each identified by the Stackby row id carried inside it.

Ask about StackbyAll Stackby nodesProvider API docs ↗

Connection

Required
Yes — the node will not save without one
Auth type
API key
Providers
Stackby
Secret shape
the API key, or {"api_key": "…"}
Config it needs
base_url, stack_id, table
Resolved by
config.connection_id, else node.connection_id

Configuration

3 fields, 1 required. A dotted path is a nested object and name[] an array of objects — the editor renders the same tree.

FieldTypeRequiredDefaultConstraintsExample
stack_id
Id of the stack to act on, from the stack's URL. Overrides the default stack id on the connection.
stringNo——stqYn5AvM8wJP1pfjw
table
Name or id of the table to act on. Overrides the default table on the connection.
stringNo——tbmtIz6IUXZ1ogNJeB
records
Rows to update, each carrying its Stackby row 'id' alongside the columns to change. At most ten rows per call.
arrayYes—1–10 characters; array of object[{"field":{"Status":"Closed"},"id":"rw17054017479362efee7"}]

Example configuration

Every value below is the contract’s own example or default — nothing invented.

{
  "records": [
    {
      "field": {
        "Status": "Closed"
      },
      "id": "rw17054017479362efee7"
    }
  ],
  "stack_id": "stqYn5AvM8wJP1pfjw",
  "table": "tbmtIz6IUXZ1ogNJeB"
}

Output

One shape.

result

FieldTypeExample
rows
The rows Stackby returned, each as {id, field}.
array—
count
How many rows this response carried.
number—
stack_id
The stack the rows belong to.
string—
table
The table the rows belong to.
string—
requested
How many rows the request asked Stackby to write.
number—
{
  "count": 0,
  "requested": 0,
  "rows": [],
  "stack_id": "",
  "table": ""
}

Related Stackby nodes

See Update Rows run in a workflow.

In a technical demo we add the Stackby connection, drop the node on the canvas and let Workflow Health pre-flight it before the first real run.

Book a technical demoTalk to sales