Querying Data

Query your table data through the UI, within flows, or via the REST API.

UI Filtering

Add a Filter

1. Open a table
2. Click Filter in the toolbar
3. Select a column, operator, and value
4. The table updates in real-time

Filter Operators

Operator	Applicable Types	Description
equals	All	Exact match
not equals	All	Excludes exact match
contains	Text, Email, URL	Substring match
starts with	Text, Email, URL	Prefix match
ends with	Text, Email, URL	Suffix match
greater than	Number, Date	Values above threshold
less than	Number, Date	Values below threshold
is empty	All	Null or empty values
is not empty	All	Non-null values
is one of	Select, Multi-Select	Matches any of the specified options

Combine Filters

Add multiple filters with AND logic:

• Filter 1: status equals "Active"
• Filter 2: created greater than 2026-04-01

Result: Only active records created after April 1st.

Sorting

1. Click any column header to sort ascending
2. Click again to sort descending
3. Click a third time to remove the sort
4. Add multiple sort levels via Sort in the toolbar

Searching

Use the search bar to perform full-text search across all text columns. The search is case-insensitive and matches partial words.

Querying in Flows

Flow Builder (Tables Piece)

Add a Tables → Search Rows action:

Table: Leads
Filters:
  - status equals "New"
  - source equals "Website"
Sort: created (descending)
Limit: 10

The action returns matching rows as an array that you can loop over or use in subsequent steps.

Workflow Builder (Code Node)

Query tables via the FlowStack API:

const response = await fetch('https://app.onflowstack.com/api/v1/tables/tbl_abc123/rows', {
  method: 'POST',
  headers: {
    'Authorization': `Bearer ${$env.FLOWSTACK_API_KEY}`,
    'Content-Type': 'application/json',
  },
  body: JSON.stringify({
    filters: [
      { column: 'status', operator: 'equals', value: 'New' }
    ],
    sort: [{ column: 'created', direction: 'desc' }],
    limit: 10,
  }),
});

const { data } = await response.json();
return data.map(row => ({ json: row }));

API Queries

curl -X POST "https://app.onflowstack.com/api/v1/tables/tbl_abc123/rows/query" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "filters": [
      {"column": "status", "operator": "equals", "value": "Active"}
    ],
    "sort": [{"column": "created", "direction": "desc"}],
    "limit": 50,
    "cursor": null
  }'

Performance Tips

• Add filters — Avoid fetching all rows when you only need a subset
• Limit results — Use pagination (limit + cursor) for large tables
• Use Select columns — Filter by Select/Multi-Select columns is faster than text search
• Archive old data — Export and delete old rows to keep tables performant