---
title: "Read an attached file column's value distribution and raw values"
method: GET
path: "/chat-attachments/{attachment_id}/columns/{source_index}/values/"
tags: ["assistant", "mcp-searchable-tool"]
---

# Read an attached file column's value distribution and raw values

`GET /chat-attachments/{attachment_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/chat-attachments/{attachment_id}/columns/{source_index}/values/`
- Auth: one of:
  - API key in header `X-API-Key`
  - HTTP bearer

Inspect one column of your attached CSV or XLSX file, or of the table a PDF you attached holds. Counts cover every nonblank data row in its sheet, with the top 20 values, percentages of all rows, empty and distinct counts, and other_count. Raw values are paged in file order without coercion. source_index is zero-based, counted as a page of the file's rows shows its columns; `sheet` reads another workbook sheet, and `header_row` names the row holding the column names under a title.

## Path parameters

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

## Query parameters

- `offset` integer
- `limit` integer
- `sheet` string, nullable: A workbook sheet by name; omit for the attached sheet.
- `header_row` integer: The row holding the column names under a title, numbered as a page of the file's rows numbers them; the column is named from it and counted over the rows below. 0 keeps the first row.

## Response `200`

Successful Response

- ChatAttachmentColumnValuesResponseSchema: One attached file column's exact value frequencies and a page of its raw values. Counts cover every nonblank data row of the file's selected sheet, before any import row cap. Raw values are a page in file order, uncoerced.
  - `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: The column's name, from the header row.
  - `offset` integer, required: Where this page of raw values starts, counted from zero.
  - `raw_values` string[], required: Raw values for this page, in file order.
  - `source_index` integer, required: The field's zero-based position in the file.

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