Stackby

Read, write, and delete data in Stackby tables

Overview

Stackby is a spreadsheet-database platform that combines the simplicity of spreadsheets with the power of databases. This tool interacts with the Stackby REST API to append (create), read, list, and delete rows in Stackby tables within stacks. It supports offset-based pagination for listing rows, optional view filtering, and batching of append operations by stack/table combination.

Category: Data & Storage
Tool Name: stackby
Version: 1

Appearance: Icon: lucide-Table | Color: #5A67D8

Node Type

Action — processes input items and produces output

Input / Output

Direction	Port(s)
Input	Input
Output	Output, Error

Credentials

This tool requires Stackby API credentials. See the Credentials Guide for setup instructions.

Operations

Operation	Value	Description
Append	append	Create a new row in a table
Delete	delete	Delete a row from a table
List	list	List rows from a table
Read	read	Read a single row by ID

Parameters

Append (append)

Parameter	Type	Required	Default	Description
Columns	string	Yes	—	Comma-separated list of the properties which should be used as columns for the new rows. The input item must have JSON properties matching each column name. Supports expressions like {{ $json.columnList }}.

Delete (delete)

Parameter	Type	Required	Default	Description
ID	string	Yes	—	ID of the row to read or delete. Supports expressions like {{ $json.rowId }}.

List (list)

Parameter	Type	Required	Default	Description
Return All	boolean	No	true	Whether to return all results or only up to a given limit.
Limit	number	No	1000	Max number of results to return. (shown when Return All is false)
Additional Fields	collection	No	{}	Additional options for the list operation.
— View	string	No	—	The name or ID of a view in the table. If set, only the records in that view will be returned, sorted according to the view order.

Read (read)

Parameter	Type	Required	Default	Description
ID	string	Yes	—	ID of the row to read or delete. Supports expressions like {{ $json.rowId }}.

All Operations

Parameter	Type	Required	Default	Description
Stack ID	string	Yes	—	The ID of the Stackby stack to access. Find this in your Stackby stack URL. Supports expressions like {{ $json.stackId }}.
Table	string	Yes	—	The name of the table to operate on. Supports expressions like {{ $json.table }}.
Max Concurrency	number	No	10	Maximum number of items to process concurrently.

Output Data

The row is the output item: each output item’s JSON is the row’s own columns, so a column called email is addressable downstream as {{ $json.email }}. The input item’s other JSON fields do not pass through — put an Edit Fields or Merge node after this one if you need to carry them along. Binary data on the input item is forwarded.

Operation	What lands on the output item	Items produced per input item
append	The created row’s columns — the ones you named in Columns	One
read	The row’s columns	One per row returned by the lookup; an ID that matches nothing yields a single item with empty JSON
list	Each row’s columns	One per row returned — listing a 200-row table turns one input item into 200 output items. An empty table or view yields a single item with empty JSON
delete	The deletion confirmation Stackby returns for that row	One

A few behaviors worth planning around:

• Append batches by destination. All input items that resolve to the same Stack ID and Table are written in one call, and each input item still gets its own output item back. Items that resolve to a different stack or table form their own batch.
• Append reads the columns off the item. Every name in Columns must exist as a JSON property on the input item; a missing property fails that item rather than writing a blank cell.
• Return All pages through the whole table. With Return All off, Limit caps how many rows come back (up to 1000).

Usage Examples

• Create a new row in a Stackby table
• List all rows from a Stackby table
• Read a specific row by ID from Stackby
• Delete a row by ID from a Stackby table

Example Configuration

Append one row per input item, built from three of the item’s properties:

{
  "type": "stackby",
  "parameters": {
    "operation": "append",
    "stackId": "st-abc123def456",
    "table": "Contacts",
    "columns": "name,email,phone",
    "maxConcurrency": 5
  }
}

List every row in a table:

{
  "type": "stackby",
  "parameters": {
    "operation": "list",
    "stackId": "st-abc123def456",
    "table": "Contacts",
    "returnAll": true
  }
}

List up to 50 rows from a single view:

{
  "type": "stackby",
  "parameters": {
    "operation": "list",
    "stackId": "st-abc123def456",
    "table": "Contacts",
    "returnAll": false,
    "limit": 50,
    "additionalFields": {
      "view": "Active Contacts"
    }
  }
}

Read the row whose ID arrives on the item:

{
  "type": "stackby",
  "parameters": {
    "operation": "read",
    "stackId": "st-abc123def456",
    "table": "ProcessingQueue",
    "id": "{{ $json.recordId }}"
  }
}

Delete the row whose ID arrives on the item:

{
  "type": "stackby",
  "parameters": {
    "operation": "delete",
    "stackId": "st-abc123def456",
    "table": "TempData",
    "id": "{{ $json.obsoleteRecordId }}",
    "maxConcurrency": 5
  }
}

Error Handling

Mode	Behavior
stop	Halts workflow on first error
continue	Skips failed items, passes successful ones through
errorPort	Routes failed items to Error output port

Tips

Read, write, list, and delete rows in Stackby spreadsheet database tables using the Stackby REST API.