Navigation

Mobile Docs

Data Table

Read, write, and query your built-in data tables.

Interact with your built-in data tables directly from workflows. List available tables, query rows with search/filters, insert new rows, update existing rows, or delete rows. Supports Smart Insert (auto-detect format and columns), Auto Save (find-or-create table by name), Lookup/Exists (check if a value exists before acting), Upsert (insert or update by match column), and Bulk Update (update all rows matching a filter). Manage tables in the Tables section of your workspace.

Datadata_table

Usage

01Add the block to your workflow and connect it to the upstream step.
02Configure any required credentials or tokens in the inputs.
03Fill in required inputs and optional parameters for the run.
04Run a test execution, inspect outputs, and iterate before deploying.
05Deploy the data_table block with monitoring enabled in production.

Inputs (UI)

Operation

dropdown

Layout: half

Options: Smart Insert, Auto Save, Query Rows, List Tables

Table ID

short-input

Placeholder: Enter table ID...

Layout: half

Condition: operation = ["query_rows","insert_row","update_row","delete_row","smart_insert","lookup","exists","upsert","bulk_update"]

Table Name

short-input

Placeholder: Table name (created if not exists)...

Layout: half

Condition: operation = "auto_save"

Raw Data

long-input

Placeholder: Any format: JSON object/array, CSV, markdown table, key:value text...

Layout: full

Condition: operation = ["smart_insert","auto_save"]

Deduplicate Column (optional)

short-input

Placeholder: Column name to prevent duplicates...

Layout: half

Condition: operation = ["smart_insert","auto_save"]

Update Duplicates (Upsert)

switch

Layout: half

Condition: operation = ["smart_insert","auto_save"]

Lookup Column

short-input

Placeholder: Column name (e.g. email)...

Layout: half

Condition: operation = ["lookup","exists"]

Lookup Value

short-input

Placeholder: Value to find...

Layout: half

Condition: operation = ["lookup","exists"]

Match Column

short-input

Placeholder: Column to match on (e.g. email)...

Layout: half

Condition: operation = "upsert"

Match Value

short-input

Placeholder: Value to match...

Layout: half

Condition: operation = "upsert"

Filter Column

short-input

Placeholder: Column to filter by (e.g. status)...

Layout: half

Condition: operation = "bulk_update"

Filter Value

short-input

Placeholder: Value to match (e.g. pending)...

Layout: half

Condition: operation = "bulk_update"

Search

short-input

Placeholder: Search term to filter rows...

Layout: full

Condition: operation = "query_rows"

Filters

code

Placeholder: { "status": "active" }

Layout: full

Condition: operation = "query_rows"

Limit

short-input

Placeholder: 50

Layout: half

Condition: operation = "query_rows"

Page

short-input

Placeholder: 1

Layout: half

Condition: operation = "query_rows"

Row Data

code

Placeholder: { "Name": "Example", "Status": "active" }

Layout: full

Condition: operation = ["insert_row","update_row","upsert","bulk_update"]

Row ID

short-input

Placeholder: Row ID to update or delete...

Layout: full

Condition: operation = ["update_row","delete_row"]

Inputs (API)

operation

string

Required

tableId

string

Optional

rowId

string

Optional

rowData

json

Optional

search

string

Optional

page

number

Optional

limit

number

Optional

filters

json

Optional

rawData

json

Optional

createMissingColumns

boolean

Optional

deduplicateColumn

string

Optional

upsertOnDuplicate

boolean

Optional

tableName

string

Optional

workspaceId

string

Optional

description

string

Optional

lookupColumn

string

Optional

lookupValue

string

Optional

matchColumn

string

Optional

matchValue

string

Optional

filterColumn

string

Optional

filterValue

string

Optional

Outputs

Primary response type:

{
  "tables": "json",
  "rows": "json",
  "row": "json",
  "data": "json",
  "success": "boolean",
  "totalRows": "number",
  "page": "number",
  "insertedRows": "number",
  "skippedRows": "number",
  "createdColumns": "json",
  "format": "string",
  "tableId": "string",
  "tableName": "string",
  "isNewTable": "boolean",
  "found": "boolean",
  "exists": "boolean",
  "action": "string",
  "updatedRows": "number",
  "upsertedRows": "number"
}

Tool Access

data_table_manager