---
title: "Get a data table"
method: GET
path: "/api/v3/data-tables/{data_table_id}"
tags: ["Data tables"]
---

# Get a data table

`GET /api/v3/data-tables/{data_table_id}`

## Request

- Base URL: `https://embedded.improvado.io`
- URL: `https://embedded.improvado.io/api/v3/data-tables/{data_table_id}`
- Auth: one of:
  - HTTP bearer
  - API key in cookie `dts_session_id`
- TypeScript: <https://skmtc.dev/improvado/apis/improvado-embedded-api-v3/docs/api/v3/data-tables/:data_table_id/get.ts> (a function with typed inputs; its response is checked against the schema)

Get detailed info about data table

## Path parameters

- `data_table_id` integer, required

## Response `200`

Get a Data Table

- DataTableDetail: Data Table Detail object
  - `title` string: Data Table title
  - `freshness` string: Data Table freshness date
  - `datasource_name` string: Data source name
  - `report_type` string: Report type
  - `data_class` string: Data class
  - `workspace` integer: Workspace ID
  - `sql_name` string: SQL name
  - `auto_extract_new_accounts` boolean: Auto extract new accounts
  - `fields` object: Fields object
    - `name` Field: Field object
      - `title` string: Field title
      - `name` string: Field name
      - `user_kind` string: Field kind
      - `user_type` string: Field type
      - `selected` boolean: Is the field selected
      - `can_edit` boolean: Can the field be edited
      - `sql_name` string: Sql Name of a Field
      - `format` 'string' | 'float' | 'integer' | 'iso_8601_date' | 'currency' | 'percent' | 'duration' | 'url' | 'image_url': Hint on how the value is meant to be rendered — not a storage contract. Metrics fall back to `float` whenever a data source does not declare a format explicitly, so `float` does not imply the value is fractional, and no decimal precision is guaranteed: values are passed through exactly as the data source returns them, without rounding. New formats may be added over time, so treat an unrecognised value as an unformatted string rather than failing.
      - `is_dynamic` boolean: Is the field dynamic

## Other responses

- `401`: Forbidden
- `404`: Not Found

---

[API](https://skmtc.dev/improvado/apis/improvado-embedded-api-v3.md) - [All operations](https://skmtc.dev/improvado/apis/improvado-embedded-api-v3/llms.txt) - [OpenAPI document](https://skmtc.dev/improvado/apis/improvado-embedded-api-v3/revisions/a881099bd6c4?raw)