> ## Documentation Index
> Fetch the complete documentation index at: https://docs.crewship.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Query Rows

> Query table rows with filtering, sorting, and pagination

## Path Parameters

<ParamField path="id" type="string" required>
  Table ID
</ParamField>

## Request

<ParamField body="filter" type="object">
  Filter expression. Use `and` / `or` groups with conditions like `{ "column": "score", "operator": "gte", "value": 10 }`
</ParamField>

<ParamField body="sort_by" type="string">
  Column name to sort by
</ParamField>

<ParamField body="sort_direction" type="string" default="desc">
  Sort direction: `asc` or `desc`
</ParamField>

<ParamField body="limit" type="number" default="50">
  Rows to return (max 1000)
</ParamField>

<ParamField body="offset" type="number" default="0">
  Rows to skip
</ParamField>

## Response

<ResponseField name="rows" type="array">
  Matching rows
</ResponseField>

<ResponseField name="total" type="number">
  Total rows matching the filter
</ResponseField>

<ResponseField name="limit" type="number">
  Effective limit used
</ResponseField>

<ResponseField name="offset" type="number">
  Effective offset used
</ResponseField>

<RequestExample>
  ```bash cURL theme={null}
  curl -X POST https://api.crewship.dev/v1/tables/tbl_abc123xyz789/query \
    -H "Authorization: Bearer YOUR_API_KEY" \
    -H "Content-Type: application/json" \
    -d '{
      "filter": {
        "and": [
          { "column": "status", "operator": "eq", "value": "qualified" },
          { "column": "score", "operator": "gte", "value": 50 }
        ]
      },
      "sort_by": "score",
      "sort_direction": "desc",
      "limit": 25,
      "offset": 0
    }'
  ```
</RequestExample>

<ResponseExample>
  ```json Success theme={null}
  {
    "rows": [
      {
        "id": "row_abc123xyz789",
        "company": "Acme",
        "score": 92,
        "status": "qualified",
        "_meta": {
          "created_at": "2024-01-15T10:35:00Z",
          "created_by": "api:Production Key",
          "updated_at": "2024-01-20T08:12:00Z",
          "updated_by": "api:Production Key"
        }
      }
    ],
    "total": 1,
    "limit": 25,
    "offset": 0
  }
  ```
</ResponseExample>