---
title: "Query rows in a data table"
method: GET
path: "/v1/projects/{project_id}/tables/{id}/rows"
tags: ["DataTable"]
---

# Query rows in a data table

`GET /v1/projects/{project_id}/tables/{id}/rows`

## Request

- Base URL: `https://api.telerivet.com`
- URL: `https://api.telerivet.com/v1/projects/{project_id}/tables/{id}/rows`
- Auth: one of:
  - HTTP basic
  - OAuth 2 (authorization code, authorization URL `https://telerivet.com/oauth/authorize`, token URL `https://api.telerivet.com/oauth/token`)

Queries rows in this data table.

## Path parameters

- `project_id` string, required
- `id` string, required

## Query parameters

- `time_created` integer: Unix timestamp in seconds
- `contact_id` string: ID of Contact
- `vars` object
- `sort` 'default'
- `sort_dir` 'asc' | 'desc'
- `page_size` integer
- `offset` integer
- `marker` string
- `count` boolean

## Response `200`

Successful response. When count=1 parameter is provided, returns {"count": N} instead.

- object
  - `data` DataRow[]: Array of results (omitted when count=1)
    - `id` string: ID of the data row
    - `contact_id` string: ID of the contact this row is associated with (or null if not associated with any contact)
    - `from_number` string: Phone number that this row is associated with (or null if not associated with any phone number)
    - `vars` object: Custom variables stored for this data row. Variable names may be up to 32 characters in length and can contain the characters a-z, A-Z, 0-9, and _. Values may be strings, numbers, or boolean (true/false). String values may be up to 4096 bytes in length when encoded as UTF-8. Up to 100 variables are supported per object. Setting a variable to null will delete the variable.
    - `time_created` integer: The time this row was created in Telerivet
    - `time_updated` integer: The time this row was last updated in Telerivet
    - `table_id` string: ID of the table this data row belongs to
    - `project_id` string: ID of the project this data row belongs to
  - `truncated` boolean: True if there are more results
  - `next_marker` string: Marker for pagination
  - `page_size` integer: Number of results per page
  - `sort_dir` 'asc' | 'desc': Sort direction
  - `count` integer: Total count of matching items (only when count=1 parameter is provided)

## Other responses

- `400`: Invalid request parameters
- `401`: Invalid or missing API key or Bearer token
- `404`: Resource not found

---

[API](https://skmtc.dev/telerivet/apis/telerivet-api.md) · [All operations](https://skmtc.dev/telerivet/apis/telerivet-api/llms.txt) · [OpenAPI document](https://skmtc.dev/telerivet/apis/telerivet-api/revisions/4e14b1c8d917?raw)