Skip to main content
GET
/
public
/
v1
/
board
/
{boardId}
/
table
/
{tableId}
/
rows
Node.js SDK
import { CoperaAI } from '@copera.ai/sdk';

const copera = CoperaAI({
  apiKey: 'your-api-key-here'
});

const rows = await copera.board.listTableRows({
  boardId: 'board_id_here',
  tableId: 'table_id_here',
  filter: {
    match: 'and',
    conditions: [
      { column_id: 'col_status', operator: 'equals', value: ['opt_done'] },
      { column_id: 'col_due',    operator: 'before', value: '2026-12-31' }
    ]
  },
  sort: [{ column: 'col_due', dir: 'asc' }]
});
console.log(rows);
[
  {
    "_id": "<string>",
    "rowId": 123,
    "owner": "<string>",
    "table": "<string>",
    "board": "<string>",
    "createdAt": "<string>",
    "updatedAt": "<string>",
    "columns": [
      {
        "columnId": "<string>",
        "value": "<unknown>",
        "linkValue": "<unknown>",
        "lookupValue": [
          {
            "foreignRowId": "<string>",
            "foreignRowValue": "<unknown>"
          }
        ]
      }
    ],
    "description": "<string>"
  }
]

​
Overview

Retrieves rows (records) from the specified table. Each row contains values for the table’s columns. You can optionally search, filter, and sort the result with the q, filter, and sort query parameters. Pass q to run a case-insensitive search across searchable table columns. This uses the same indexed table search path as the web grid.

​
Filtering

Pass a JSON object as the filter query parameter: 
{
  "match": "and",
  "conditions": [
    { "column_id": "col_abc", "operator": "contains", "value": "foo" },
    { "column_id": "col_xyz", "operator": "between", "value": ["2026-01-01", "2026-12-31"] },
    { "column_id": "col_empty", "operator": "is_empty" }
  ]
}
  • match: "and" (default) or "or" — how to combine multiple conditions.
  • conditions[]: up to 20 conditions. Each has column_id, operator, and (for most operators) value.

​
Operators by column type

Column typeOperators
stringequals, not_equals, contains, not_contains, starts_with, ends_with, is_empty, is_not_empty
numberequals, not_equals, gt, gte, lt, lte, includes, not_includes, is_empty, is_not_empty
select (status / dropdown / labels)equals, not_equals, includes, not_includes, is_empty, is_not_empty
boolequals, not_equals, is_empty, is_not_empty
dateequals, before, after, between, today, yesterday, tomorrow, next_7_days, last_7_days, current_week, last_week, next_week, current_month, last_month, next_month, is_empty, is_not_empty

​
Value shape

  • string operators take a string value.
  • number operators take a number value; includes / not_includes take number[].
  • select operators take a single string or string[] of option IDs.
  • date equals/before/after take an ISO date string; between takes a [startISO, endISO] tuple; the relative operators (today, current_week, …) take no value.
  • is_empty / is_not_empty take no value.

​
Sorting

Pass a comma-separated spec as the sort query parameter: 
sort=col_a:asc,col_b:desc
Each entry is <columnId>:asc or <columnId>:desc. Sorting by password columns is not allowed.

​
Response

Returns an array of row objects with:
  • Row ID and internal rowId number
  • Owner and timestamps
  • Column values (columnId and value pairs)

Authorizations

​
Authorization
string
header
required

Bearer token

Path Parameters

​
boardId
string
required

ObjectId

Required string length: 24
Pattern: ^[0-9a-fA-F]{24}$
​
tableId
string
required

ObjectId

Required string length: 24
Pattern: ^[0-9a-fA-F]{24}$

Query Parameters

​
q
string

Case-insensitive row search across searchable table columns.

Maximum string length: 200
​
filter
string

JSON filter as a string, e.g. {"match":"and","conditions":[{"column_id":"…","operator":"contains","value":"foo"}]}. See the list-table-rows endpoint docs for the full operator catalog.

​
sort
string

Comma-separated sort spec, e.g. "col_a:asc,col_b:desc". Defaults to no sorting.

Response

Default Response

​
_id
string
required
​
rowId
number
required
​
owner
string
required
​
table
string
required
​
board
string
required
​
createdAt
string
required
​
updatedAt
string
required
​
columns
object[]
required
​
description
string