---
title: "Get a table column's value distribution"
method: GET
path: "/tables/{table_id}/columns/{column_id}/distribution/"
tags: ["table-columns", "mcp-searchable-tool"]
---

# Get a table column's value distribution

`GET /tables/{table_id}/columns/{column_id}/distribution/`

## Request

- Base URL: `https://api.getoneprofile.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.getoneprofile.ai/tables/{table_id}/columns/{column_id}/distribution/`
- Auth: one of:
  - API key in header `X-API-Key`
  - HTTP bearer

Get exact value frequencies across every live row of a table, independent of view filters or loaded pages. Returns total, empty and distinct counts, the 20 most common values with counts and percentages of all rows, and other_count for nonempty values outside that list. Null, missing and whitespace-only text cells are empty; zero and false are values. Objects and arrays are whole values.

## Path parameters

- `table_id` string, uuid, required
- `column_id` string, uuid, required

## Response `200`

Successful Response

- ValueDistribution
  - `distinct_count` integer, required
  - `empty_count` integer, required
  - `other_count` integer, required
  - `total_count` integer, required
  - `values` ValueFrequency[], required
    - `count` integer, required
    - `percentage` number, required
    - `value` string, required

## Other responses

- `401`: Unauthorized
- `403`: Forbidden
- `404`: Column or source not found
- `422`: Invalid request made to the API.
- `500`: Internal server error.
- `502`: Bad gateway error.
- `503`: Service unavailable.

---

[API](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile.md) · [All operations](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/llms.txt) · [OpenAPI document](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/revisions/4a6bd71e3f02?raw)