Get Row
stackby.get_row
ActionDatabases & warehousesconnection required
Calls the Stackby API with the connection's credentials.
Read one row of a table by its Stackby row id.
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.
| Field | Type | Required | Default | Constraints | Example |
|---|---|---|---|---|---|
stack_id Id of the stack to act on, from the stack's URL. Overrides the default stack id on the connection. | string | No | — | — | stqYn5AvM8wJP1pfjw |
table Name or id of the table to act on. Overrides the default table on the connection. | string | No | — | — | tbmtIz6IUXZ1ogNJeB |
row_id Stackby row id of the row to read, e.g. rw17054017479362efee7. | string | Yes | — | — | rw17054017479362efee7 |
Example configuration
Every value below is the contract’s own example or default — nothing invented.
{
"row_id": "rw17054017479362efee7",
"stack_id": "stqYn5AvM8wJP1pfjw",
"table": "tbmtIz6IUXZ1ogNJeB"
}Output
One shape.
result
| Field | Type | Example |
|---|---|---|
row The row as {id, field}, or null when it was not found. | object | — |
found False when the stack holds no row with that id. | boolean | — |
row_id The row id that was looked up. | string | — |
stack_id The stack the row belongs to. | string | — |
table The table the row belongs to. | string | — |
{
"found": false,
"row": {},
"row_id": "",
"stack_id": "",
"table": ""
}Related Stackby nodes
See Get Row 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.