---
name: "rows_query"
area: "tables"
title: "Find rows"
price: "free"
method: "POST"
url: "https://api.conecto.chat/v1/tools/rows_query"
mcp_server: "https://api.conecto.chat/mcp/tables"
auth: "Authorization: Bearer <conecto_sk_ key>"
docs_url: "https://conecto.chat/tools/tables/rows_query"
---

# Find rows (`rows_query`)

Rows matching filters, all or any of them, sorted by up to 3 columns, a page at a time.

Rows matching filters ([{"column": "Stage", "op": "eq", "value": "New"}]; ops: eq, neq, contains, not_contains, gt, gte, lt, lte for numbers and dates, empty, not_empty, in), all or any of them, sorted by columns, a page at a time.

Price: Free up to 1,000,000 reads a month for the whole account, then $0.50 per 10,000 reads. A call that fails costs nothing.

## Use it when

Someone asks what is in a table: what is due, what is open, what matches.

## Say this to your agent

> Which jobs are due by the end of the month and not picked up yet?

## Inputs

| Name | Type | Required | Description | Allowed values | Default |
|---|---|---|---|---|---|
| `table` | string | yes | The table's name (or its table_id). 1 to 80 characters. |  |  |
| `filters` | array of objects | no | Up to 20 items. |  |  |
| `filters[].column` | string | yes, in each item of `filters` | Up to 60 characters. |  |  |
| `filters[].op` | string | no |  | `"eq"`, `"neq"`, `"contains"`, `"not_contains"`, `"gt"`, `"gte"`, `"lt"`, `"lte"`, `"empty"`, `"not_empty"`, `"in"` |  |
| `filters[].value` | any | no |  |  |  |
| `match` | string | no |  | `"all"`, `"any"` | `"all"` |
| `sort` | array of objects | no | Up to 3 items. |  |  |
| `sort[].column` | string | yes, in each item of `sort` |  |  |  |
| `sort[].direction` | string | no |  | `"asc"`, `"desc"` |  |
| `limit` | integer | no | 1 to 500. |  | `100` |
| `offset` | integer | no | At least 0. |  | `0` |

## Example

Written for Halverson Cycle & Repair, a bike shop with a repair workshop in Portland, Oregon.

MCP: call `rows_query` on the MCP server `https://api.conecto.chat/mcp/tables` with these arguments:

```json
{
  "table": "Workshop jobs",
  "filters": [
    {
      "column": "Status",
      "op": "neq",
      "value": "Picked up"
    },
    {
      "column": "Due",
      "op": "lte",
      "value": "2026-10-31"
    }
  ],
  "sort": [
    {
      "column": "Due",
      "direction": "asc"
    }
  ]
}
```

REST:

```bash
curl https://api.conecto.chat/v1/tools/rows_query \
  -H "Authorization: Bearer $CONECTO_KEY" \
  -H "Content-Type: application/json" \
  -d '{"table": "Workshop jobs", "filters": [{"column": "Status", "op": "neq", "value": "Picked up"}, {"column": "Due", "op": "lte", "value": "2026-10-31"}], "sort": [{"column": "Due", "direction": "asc"}]}'
```

## Response

```json
{
  "call_id": "5f0c8a2e-3b7d-4c1e-9a64-2d8e1f7b0c93",
  "tool": "rows_query",
  "status": "succeeded",
  "replayed": false,
  "cost_usd": "$0.00",
  "balance_usd": "$19.75",
  "result": {
    "rows": [
      {
        "row": 1,
        "Order": "W-2026-118",
        "Customer": "Rachel Kim",
        "Bike": "Willamette 8",
        "Work": "Full tune-up",
        "Due": "2026-10-22",
        "Status": "On the stand",
        "Price": 180
      }
    ],
    "total": 1
  }
}
```

`result`: rows: each with its row number and values; total: how many matched; next_offset when there are more.

## Errors

| Code | Status | When | Fix |
|---|---|---|---|
| `not_found` | 404 | No table has that name or table_id, or the table has no column of that name. | Call tables_list for the tables and their columns. |
| `invalid_input` | 400 | A filter's op is unknown, compares with the wrong kind of value, or uses gt, gte, lt or lte on a column that is not a number or a date. | Use the ops this page lists, with values of the column's type. |

The refusals every tool can give (401 key, 402 balance, 429 limits) are on the errors page: https://conecto.chat/docs/errors.md

## Related

- [tables_create](https://conecto.chat/tools/tables/tables_create.md): Creates a table with typed columns: text, numbers with decimals or a currency, checkboxes, dates, choices, emails, links, phone numbers or files. $0.001 a call.
- [tables_list](https://conecto.chat/tools/tables/tables_list.md): Every table with its columns and how many rows it has. Free up to 1,000,000 reads a month.
- [tables_change_columns](https://conecto.chat/tools/tables/tables_change_columns.md): Adds, renames or removes columns; rows keep their values through a rename. $0.001 a call.
- [rows_add](https://conecto.chat/tools/tables/rows_add.md): Adds up to 500 rows, each checked against its columns; if one is wrong, none is added. $0.001 per row added.
- [rows_update](https://conecto.chat/tools/tables/rows_update.md): Changes values in up to 500 rows by row number; only the columns given change, and null clears a cell. $0.001 per row changed.
- [rows_upsert](https://conecto.chat/tools/tables/rows_upsert.md): Updates the rows whose key column matches and adds the rest, so a list from anywhere syncs without reading the table first. $0.001 per row added or updated.
- [rows_summarize](https://conecto.chat/tools/tables/rows_summarize.md): Counts rows, and sums, averages, minimums and maximums of number columns, overall and per group, in one call. Free up to 1,000,000 reads a month.
- [rows_delete](https://conecto.chat/tools/tables/rows_delete.md): Deletes rows by their numbers, for good. Free.
- [tables_export](https://conecto.chat/tools/tables/tables_export.md): A CSV of a table, or of the rows matching filters, saved in the file store with a download link. $0.001 a call.
- [tables_import](https://conecto.chat/tools/tables/tables_import.md): Adds the rows of a CSV in the file store to a table, or makes a new table from it. $0.001 per row imported.
- [tables_delete](https://conecto.chat/tools/tables/tables_delete.md): Deletes a table and all its rows, for good. Free.