---
title: "Query Rows"
method: GET
path: "/api/datastore/{block_id}/rows"
tags: ["datastore"]
---

# Query Rows

`GET /api/datastore/{block_id}/rows`

## Request

- Base URL: `https://app.ctlsurf.com` (the document declares no server; this is the origin it was published from)
- URL: `https://app.ctlsurf.com/api/datastore/{block_id}/rows`
- Auth: HTTP bearer

Query rows from a datastore block with optional filtering, sorting, and pagination.

## Path parameters

- `block_id` string, uuid, required

## Query parameters

- `where` string, nullable: JSON-encoded filter object, e.g. {"Status": "scouted"} or {"Score": {"$gt": 50}}
- `order_by` string, nullable: Column name to sort by
- `order` string, nullable: Sort direction: asc or desc
- `limit` integer
- `offset` integer
- `select` string, nullable: Comma-separated column names to return

## Response `200`

Successful Response

- unknown

## Other responses

- `422`: Validation Error

---

[API](https://skmtc.dev/ctlsurf/apis/notebook-control-plane.md) · [All operations](https://skmtc.dev/ctlsurf/apis/notebook-control-plane/llms.txt) · [OpenAPI document](https://skmtc.dev/ctlsurf/apis/notebook-control-plane/revisions/ddfbbe20d5ce?raw)