---
canonical_url: "https://docs.composio.dev/toolkits/stackby"
markdown_url: "https://docs.composio.dev/toolkits/stackby.md"
product: "platform"
version: null
last_updated: null
---

# Stackby

Stackby combines spreadsheets, databases, and workflow automation so teams can organize data, collaborate, and manage business processes.

- **Category:** spreadsheets
- **Auth:** API_KEY
- **Composio-managed OAuth available?** N/A
- **Tools:** 9
- **Triggers:** 0
- **Slug:** `STACKBY`
- **Version:** 00000000_00

## Tools

### Create Rows

**Slug:** `STACKBY_CREATE_ROWS`

Create 1 to 10 rows in a Stackby table in one request.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `records` | array | Yes | Rows to create (1-10). Each object maps Stackby column names to their values. |
| `stack_id` | string | Yes | ID of the stack containing the table. |
| `table_id` | string | Yes | ID of the table where rows will be created. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Rows

**Slug:** `STACKBY_DELETE_ROWS`

Delete 1 to 10 identified rows from a Stackby table.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `row_ids` | array | Yes | Stable IDs of 1 to 10 rows to permanently delete. |
| `stack_id` | string | Yes | ID of the stack containing the table. |
| `table_id` | string | Yes | ID of the table containing the rows. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Columns

**Slug:** `STACKBY_LIST_COLUMNS`

List columns and their types for a Stackby table so row field names can be chosen correctly.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `stack_id` | string | Yes | ID of the stack containing the table. |
| `table_id` | string | Yes | ID of the table whose columns to list. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Rows

**Slug:** `STACKBY_LIST_ROWS`

List one page of rows from a Stackby table, or retrieve specific rows by ID, with optional filtering, view selection, and single-field sorting.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `filter` | string | No | Stackby function-style filter, such as 'equal({Status},Open)'. Operators include equal, notEqual, toContains, doesNotContain, isEmpty, isNotEmpty, greaterThan, greaterThanEqual, lessThan, lessThanEqual, isExactly, and isAnyOf. Wrap column names in braces and combine expressions with 'and' or 'or'. |
| `offset` | integer | No | Zero-based numeric row offset; pass next_offset from a prior response to continue. |
| `row_ids` | array | No | Specific stable row IDs to retrieve; omit to browse the table. |
| `view_id` | string | No | Restrict rows to this view ID. |
| `stack_id` | string | Yes | ID of the stack containing the table. |
| `table_id` | string | Yes | ID of the table whose rows to return. |
| `page_size` | integer | No | Maximum rows in this page (1-100). |
| `sort_field` | string | No | Column name to sort by; provide sort_direction with it. |
| `sort_direction` | string ("asc" | "desc") | No | Sort direction for sort_field: asc or desc. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Stacks

**Slug:** `STACKBY_LIST_STACKS`

List accessible Stackby stacks in a known workspace and return IDs needed for table discovery.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `workspace_id` | string | Yes | Workspace ID whose stacks to list. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Tables

**Slug:** `STACKBY_LIST_TABLES`

List tables in a Stackby stack and return their IDs and names.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `stack_id` | string | Yes | ID of the stack whose tables to list. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Views

**Slug:** `STACKBY_LIST_VIEWS`

Return view IDs and names for a Stackby table for use in view-scoped row queries.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `stack_id` | string | Yes | ID of the stack containing the table. |
| `table_id` | string | Yes | ID of the table whose views to list. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Workspaces

**Slug:** `STACKBY_LIST_WORKSPACES`

List accessible Stackby workspaces and return the workspace IDs needed to discover stacks.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Rows

**Slug:** `STACKBY_UPDATE_ROWS`

Partially update 1 to 10 existing Stackby rows in one request.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `records` | array | Yes | Updates for 1 to 10 rows. Each update requires a stable row ID and a non-empty field map. |
| `stack_id` | string | Yes | ID of the stack containing the table. |
| `table_id` | string | Yes | ID of the table containing the rows. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |