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

# GET /api/agent/v1/table/{id}/field/{field-id}/values

`GET /api/agent/v1/table/{id}/field/{field-id}/values`

Get statistics and sample values for a table field.

## Path parameters

- `id` integer, required
- `field-id` string, required

## Response `2XX`

Successful response

- MetabaseAgentApiApiFieldValues — Statistics and sample values for a specific field.
  - `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
  - `statistics` MetabaseAgentApiApiStatistics — Statistical summary of a field's values computed during database sync. Includes counts, percentages, numeric summaries (min/max/avg/quartiles/sd), and date ranges.
    - `average_length` number, nullable
    - `avg` number, nullable
    - `distinct_count` integer, nullable
    - `earliest` string, nullable
    - `latest` string, nullable
    - `max` number, nullable
    - `min` number, nullable
    - `percent_email` number, nullable
    - `percent_json` number, nullable
    - `percent_null` number, nullable
    - `percent_state` number, nullable
    - `percent_url` number, nullable
    - `q1` number, nullable
    - `q3` number, nullable
    - `sd` number, nullable
  - `values` unknown[], nullable
    - unknown

## Other responses

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

## Changes

- **2026-05-22** `b1dc4ea67567` — 2 breaking, 2 info
  - added `#/components/schemas/metabase.agent-api.api.field-id` to the `field_id` response property `oneOf` list for the response status `2XX`
  - added `#/components/schemas/metabase.agent-api.api.statistics` to the `statistics` response property `oneOf` list for the response status `2XX`
  - removed `#/components/schemas/metabase-enterprise.agent-api.api.statistics` from the `statistics` response property `oneOf` list for the response status `2XX`
  - removed `subschema #1` from the `field_id` response property `oneOf` list for the response status `2XX`
- **2026-03-09** `78297d193ca4` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/agent/v1/table/:id/field/:field-id/values/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/e879e0319b12/schema)