---
title: "GET /api/agent/v1/table/{id}"
method: GET
path: "/api/agent/v1/table/{id}"
tags: ["/api/agent"]
---

# GET /api/agent/v1/table/{id}

`GET /api/agent/v1/table/{id}`

Get details for a table by ID.

## Path parameters

- `id` integer, required

## Query parameters

- `with-field-values` boolean, nullable
- `with-fields` boolean, nullable
- `with-related-tables` boolean, nullable
- `with-metrics` boolean, nullable
- `with-measures` boolean, nullable
- `with-segments` boolean, nullable

## Response `2XX`

Successful response

- MetabaseAgentApiApiTable — Full details of a table including its fields, related tables, metrics, and segments.
  - `database_engine` string, required
  - `database_id` integer, required
  - `database_schema` string, nullable
  - `description` string, nullable
  - `display_name` string, required
  - `fields` MetabaseAgentApiApiField[], required
    - `base_type` string, nullable
    - `coercion_strategy` string, nullable
    - `database_type` string, nullable
    - `description` string, nullable
    - `display_name` string, required
    - `effective_type` string, nullable
    - `field_id` union, required — Field id as accepted by agent_api endpoints — either a real app-DB field id (positive integer) or a string alias for expression/aggregation columns.
      - integer — Valid Field ID
      - string
    - `field_values` unknown[], nullable
      - unknown
    - `name` string, required
    - `semantic_type` string, nullable
    - `type` 'boolean' | 'date' | 'datetime' | 'time' | 'number' | 'string' — A data type for a field derived from Metabase's type hierarchy.
  - `id` integer, required
  - `measures` MetabaseAgentApiApiMeasure[], nullable
    - `description` string, nullable
    - `display_name` string, nullable
    - `id` integer, required
    - `name` string, required
  - `metrics` MetabaseAgentApiApiMetricSummary[], nullable
    - `default_time_dimension_field_id` union — Field id as accepted by agent_api endpoints — either a real app-DB field id (positive integer) or a string alias for expression/aggregation columns.
      - integer — Valid Field ID
      - string
    - `description` string, nullable
    - `id` integer, required
    - `name` string, required
    - `type` 'metric', required
  - `name` string, required
  - `related_tables` MetabaseAgentApiApiRelatedTable[], nullable
    - `database_engine` string, nullable
    - `database_id` integer, nullable
    - `database_schema` string, nullable
    - `description` string, nullable
    - `display_name` string, nullable
    - `fields` MetabaseAgentApiApiField[], nullable
      - `base_type` string, nullable
      - `coercion_strategy` string, nullable
      - `database_type` string, nullable
      - `description` string, nullable
      - `display_name` string, required
      - `effective_type` string, nullable
      - `field_id` union, required — Field id as accepted by agent_api endpoints — either a real app-DB field id (positive integer) or a string alias for expression/aggregation columns.
        - integer — Valid Field ID
        - string
      - `field_values` unknown[], nullable
        - unknown
      - `name` string, required
      - `semantic_type` string, nullable
      - `type` 'boolean' | 'date' | 'datetime' | 'time' | 'number' | 'string' — A data type for a field derived from Metabase's type hierarchy.
    - `id` integer, required
    - `name` string, required
    - `related_by` string, nullable
    - `type` 'table', required
  - `segments` MetabaseAgentApiApiSegment[], nullable
    - `description` string, nullable
    - `display_name` string, nullable
    - `id` integer, required
    - `name` string, required
  - `type` 'table' | 'metric', required — The type of queryable entity.

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

---

[API](https://skmtc.net/metabase/apis/metabase-api.md) · [All operations](https://skmtc.net/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/metabase/metabase-api/versions/08b5a2bafb4f/schema)