query

Get Distinct Values

Get distinct values for a column in a source table.

This endpoint is used to populate filter dropdowns in dashboards. It returns unique values sorted by frequency (most common first).

Supports both cloud sources and external database sources.

post/query/distinct-values

Request

  • Base URL: https://api.pandas-ai.com (the document declares no server; this is the origin it was published from)
  • URL: https://api.pandas-ai.com/query/distinct-values
  • Auth: none declared

Request body

sourcestring nullable

Legacy source table name. Optional when source_id is provided. If omitted, the backend resolves the table name from source_id.

source_idstring nullable

Source UUID for unambiguous lookup. When provided, takes priority over source.

columnstring required

Column name to get distinct values from

limitinteger

Maximum values to return

searchstring nullable

Optional search term to filter values

Response

Successful Response

total_countinteger required

Total number of distinct values

truncatedboolean

Whether the list was truncated

Changes

No recorded changes to this operation across all 1 revision of this API.