query-table-rows

Read rows from a Data Table with paging, sorting, free-text search and structured filtering. 'page' is 1-based. 'search_filters' filters over the table's columns with the operators eq, gt, gte, in, lt, lte, ne, nin.

What it is called on each surface

The wire name is query-table-rows everywhere: it is what the Wexa MCP server advertises, the REST path is POST /v1/query-table-rows, and each SDK exposes it under its own language's naming convention.

Surface	Name
Wexa MCP server	`query-table-rows`
REST API	`POST /v1/query-table-rows`
TypeScript SDK	`fabric.queryTableRows()`
Python SDK	`fabric.query_table_rows()`

Arguments

1 of the 7 arguments is required. Omitting a required one is refused before the tool runs, at the validation stage, so it costs nothing and changes nothing.

Argument	Type	Required	Notes
`page`	integer	Optional	1-based page number (default 1).
`page_size`	integer	Optional	Rows per page (default 50).
`search`	string	Optional	Free-text search across the table.
`search_filters`	array	Optional	Structured filter over the table's columns. Each entry is {column, operator, value, type}; operator is one of eq, gt, gte, in, lt, lte, ne, nin.
`sort`	integer	Optional	1 ascending, -1 descending.
`sort_key`	string	Optional	Column to sort by.
`table_id`	string	Required	Table id from list-tables.

project_id, projectID, organization_id and executed_by are not arguments you pass: the platform binds all four from the credential you authenticated with, and both SDKs refuse them before the request leaves your process — see server-bound arguments.

What it returns

The three surfaces wrap this differently, and code written against one will not read another correctly — see return shape.

A real response, captured from a live call to query-table-rows:

{
  "lifecycle_id": "qlc_000196",
  "result": {
    "page": 1,
    "page_size": 3,
    "rows": [
      {
        "6ab1944e12917e3705beb0b9": true,
        "6ab1944e56ac670306c8deed": 120,
        "6ab1944eb6557622b2632872": "Acme",
        "_id": "6ab1945e7566f41b5c28e301",
        "coworker_user_id": "6a79a770b6c128ccc24bfca7",
        "row_id": 1
      },
      {
        "6ab1944e12917e3705beb0b9": false,
        "6ab1944e56ac670306c8deed": 75,
        "6ab1944eb6557622b2632872": "Globex",
        "_id": "6ab1945e7566f41b5c28e302",
        "coworker_user_id": "6a79a770b6c128ccc24bfca7",
        "row_id": 2
      }
    ],
    "table_id": "6ab1944e7566f41b5c28e2eb",
    "total_count": 2
  }
}

// the object you get back IS the result — there is no `.result` to read
{
  page: 1,
  page_size: 3,
  rows: [
    {
      '6ab1944e12917e3705beb0b9': true,
      '6ab1944e56ac670306c8deed': 120,
      '6ab1944eb6557622b2632872': 'Acme',
      _id: '6ab1945e7566f41b5c28e301',
      coworker_user_id: '6a79a770b6c128ccc24bfca7',
      row_id: 1
    },
    {
      '6ab1944e12917e3705beb0b9': false,
      '6ab1944e56ac670306c8deed': 75,
      '6ab1944eb6557622b2632872': 'Globex',
      _id: '6ab1945e7566f41b5c28e302',
      coworker_user_id: '6a79a770b6c128ccc24bfca7',
      row_id: 2
    }
  ],
  table_id: '6ab1944e7566f41b5c28e2eb',
  total_count: 2
}

// The TS SDK names these camelCase — lifecycleId, traceId — where Python uses
// lifecycle_id and trace_id. Both are non-enumerable: readable, but omitted by
// Object.keys() and JSON.stringify(). `result.lifecycleId` here is undefined.
result.lifecycleId // 'qlc_000196'

# a dict subclass; `result` is already unwrapped
{
 "page": 1,
 "page_size": 3,
 "rows": [
  {
   "6ab1944e12917e3705beb0b9": True,
   "6ab1944e56ac670306c8deed": 120,
   "6ab1944eb6557622b2632872": "Acme",
   "_id": "6ab1945e7566f41b5c28e301",
   "coworker_user_id": "6a79a770b6c128ccc24bfca7",
   "row_id": 1
  },
  {
   "6ab1944e12917e3705beb0b9": False,
   "6ab1944e56ac670306c8deed": 75,
   "6ab1944eb6557622b2632872": "Globex",
   "_id": "6ab1945e7566f41b5c28e302",
   "coworker_user_id": "6a79a770b6c128ccc24bfca7",
   "row_id": 2
  }
 ],
 "table_id": "6ab1944e7566f41b5c28e2eb",
 "total_count": 2
}

out.lifecycle_id  # 'qlc_000196' — an attribute, not a key

Keeping the lifecycle_id is what lets you ask later why a call was allowed, refused or held.

Calling it

The same call on all four surfaces. Pick a tab once and every code block in the documentation follows it.

The ids in this example are real: they resolve against the project the documentation is written against, so the call runs as written once you point it at your own deployment. Swap them for the ids of your own objects.

curl -sS https://fabric.wexa.ai/v1/query-table-rows \
  -H "authorization: Bearer $FABRIC_API_KEY" \
  -H "content-type: application/json" \
  -d '{"table_id":"6ab1944e7566f41b5c28e2eb"}'

import { Fabric } from '@wexa-fabric/sdk'

const fabric = new Fabric()
const { result } = await fabric.queryTableRows({
  table_id: "6ab1944e7566f41b5c28e2eb"
})

from wexa import Fabric

fabric = Fabric()
out = fabric.query_table_rows(table_id="6ab1944e7566f41b5c28e2eb")

Errors

Both SDKs raise the same typed errors, chosen from the gateway's own error string first and its HTTP status second. query-table-rows checks the fabric:table.read grant, and reaches the seven classes every tool reaches — listed under the common set. These are the ones specific to it:

Error	Status	Raised when
`NotFound`	404	`table_id` matches no table in this project.
`ConfigurationError`	5xx	`query-table-rows` is not available to you. Retrying will not help.

Governance

Every call to query-table-rows runs through the same ten-stage lifecycle as every other Wexa tool: the credential is resolved to a scope, the fabric:table.read grant is checked, quota is drawn down, the arguments are validated, policy rules are evaluated, the call is executed, the result is shaped and redacted, and an audit record is written. The lifecycle_id in the response is the handle to that record.

query-table-rows only reads, so it is not marked consequential: it is audited lightly and is never held for approval. It still consumes quota and is still refused by policy like anything else.