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

# Query data tables

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

## Request

- Base URL: `https://api.telerivet.com`
- URL: `https://api.telerivet.com/v1/projects/{project_id}/tables`
- 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 data tables within the given project.

## Path parameters

- `project_id` string, required

## Query parameters

- `name` string
- `solution_id` string: ID of Solution
- `sort` 'default' | 'name'
- `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` DataTable[]: Array of results (omitted when count=1)
    - `id` string: ID of the data table
    - `name` string: Name of the data table
    - `num_rows` integer: Number of rows in the table. For performance reasons, this number may sometimes be out-of-date.
    - `show_add_row` boolean: Whether to allow adding or importing rows via the web app
    - `show_stats` boolean: Whether to show summary charts (pie charts, bar charts, tables of top values) for this data table in the web app
    - `show_contact_columns` boolean: Whether to show 'Contact Name' and 'Phone Number' columns in the web app
    - `vars` object: Custom variables stored for this data table. 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.
    - `solution_id` string, nullable: ID of the solution that this data table belongs to, if any
    - `project_id` string: ID of the project this data table belongs to
    - `url` string: URL to this data table in the Telerivet web app
  - `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)