---
title: "Read an import column's value distribution and raw values"
method: GET
path: "/table-imports/{import_id}/columns/{source_index}/values/"
tags: ["table-imports", "mcp-searchable-tool"]
---

# Read an import column's value distribution and raw values

`GET /table-imports/{import_id}/columns/{source_index}/values/`

## 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/table-imports/{import_id}/columns/{source_index}/values/`
- Auth: one of:
  - API key in header `X-API-Key`
  - HTTP bearer

Read exact value counts, percentages, empty and distinct counts across all data rows of an uploaded CSV or the selected XLSX sheet, before row caps. Includes the top 20 values and an explicit other_count, plus a page of raw values in file order. source_index is zero-based. Whitespace-only values are empty; other values retain their raw spelling. Blank data rows are skipped as in the import.

## Path parameters

- `import_id` string, uuid, required
- `source_index` integer, required

## Query parameters

- `offset` integer
- `limit` integer

## Response `200`

Successful Response

- ImportColumnValuesDTO
  - `distribution` ValueDistribution, required
    - `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
  - `name` string, required
  - `offset` integer, required
  - `raw_values` string[], required
  - `source_index` integer, 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)