---
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

## Changes

- **2026-05-22** `b1dc4ea67567` — 5 breaking, 13 info
  - added `#/components/schemas/metabase.agent-api.api.field-id` to the `metrics/oneOf[subschema #1]/items/default_time_dimension_field_id` response property `oneOf` list for the response status `2XX`
  - added `#/components/schemas/metabase.agent-api.api.field-type` to the `fields/items/type` response property `oneOf` list for the response status `2XX`
  - added `#/components/schemas/metabase.agent-api.api.field-type` to the `related_tables/oneOf[subschema #1]/items/fields/oneOf[subschema #1]/items/type` response property `oneOf` list for the response status `2XX`
  - the `fields/items/field_id` response's property type/format changed from `string`/`` to ``/`` for status `2XX`
  - …14 more
- **2026-03-09** `78297d193ca4` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/agent/v1/table/:id/get.md)

---

[API](https://skmtc.dev/metabase/apis/metabase-api.md) · [All operations](https://skmtc.dev/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/b1dc4ea67567/schema)