> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avidoai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get distinct values for a column

> Returns a list of distinct values from a specific column in a datasource. For relation columns (e.g., topicId), returns the related records with their IDs and display names.



## OpenAPI

````yaml https://app.stainless.com/api/spec/documented/avido/openapi.documented.yml get /v0/reporting/datasources/{id}/columns/{columnId}/values
openapi: 3.1.1
info:
  title: Avido API
  description: >-
    Avido's API for LLM usage events, tool calls, trace management, webhook
    validation, and more. See each endpoint's request/response schema for
    details.
  version: 0.1.0
  contact:
    name: Avido Support
    email: support@avidoai.com
    url: https://avidoai.com/support
servers:
  - url: https://api.avidoai.com
    description: Production API
security:
  - ApiKey: []
    ApplicationId: []
paths:
  /v0/reporting/datasources/{id}/columns/{columnId}/values:
    get:
      tags:
        - Reports
      summary: Get distinct values for a column
      description: >-
        Returns a list of distinct values from a specific column in a
        datasource. For relation columns (e.g., topicId), returns the related
        records with their IDs and display names.
      operationId: getColumnValues
      parameters:
        - in: path
          name: id
          schema:
            $ref: '#/components/schemas/ReportingQueryDatasource'
            description: Datasource identifier
            example: task
          required: true
          description: Datasource identifier
        - in: path
          name: columnId
          schema:
            type: string
            description: Column identifier
            example: status
          required: true
          description: Column identifier
      responses:
        '200':
          description: Successfully retrieved column values
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ReportingColumnValuesResponse'
              examples:
                statusValues:
                  summary: Status column values
                  value:
                    data:
                      - id: PENDING
                        name: PENDING
                      - id: IN_PROGRESS
                        name: IN_PROGRESS
                      - id: COMPLETED
                        name: COMPLETED
                topicValues:
                  summary: Topic relation values
                  value:
                    data:
                      - id: 123e4567-e89b-12d3-a456-426614174000
                        name: Topic A
                      - id: 456e7890-e89b-12d3-a456-426614174000
                        name: Topic B
        '400':
          description: bad request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '401':
          description: unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '403':
          description: forbidden
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '422':
          description: invalid input
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValidationErrorResponse'
        '500':
          description: internal server error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
components:
  schemas:
    ReportingQueryDatasource:
      type: string
      enum:
        - task
        - test
        - eval
        - topic
        - tag
        - human_annotation
    ReportingColumnValuesResponse:
      type: object
      properties:
        data:
          type: array
          items:
            $ref: '#/components/schemas/ReportingColumnValueOutput'
          description: List of distinct values for the column
      required:
        - data
      additionalProperties: false
      title: ReportingColumnValuesResponse
      description: Response containing distinct column values
    ErrorResponse:
      type: object
      properties:
        message:
          type: string
          description: A human-readable error message explaining the error.
          example: Resource not found
      required:
        - message
      additionalProperties: false
      title: ErrorResponse
      description: Standard error format for failed API operations.
    ValidationErrorResponse:
      type: object
      properties:
        message:
          type: string
          description: A human-readable error message indicating what went wrong.
          example: Invalid request data
        issues:
          type: array
          items:
            type: object
            properties:
              code:
                type: string
              message:
                type: string
              path:
                type: array
                items:
                  type: string
            required:
              - code
              - message
              - path
            additionalProperties: false
          description: Array of detailed validation error objects.
          example:
            - code: invalid_string
              message: Invalid UUID
              path:
                - id
      required:
        - message
        - issues
      additionalProperties: false
      title: ValidationErrorResponse
      description: Details about validation errors in incoming requests.
    ReportingColumnValueOutput:
      type: object
      properties:
        id:
          type: string
          description: Value identifier
          example: PENDING
        name:
          type: string
          description: Human-readable value name
          example: PENDING
      required:
        - id
        - name
      additionalProperties: false
      title: ReportingColumnValue
      description: >-
        A distinct value from a datasource column with id and display name. Can
        be null for optional fields.
  securitySchemes:
    ApiKey:
      type: apiKey
      in: header
      name: x-api-key
      description: Your unique Avido API key
    ApplicationId:
      type: apiKey
      in: header
      name: x-application-id
      description: Your unique Avido Application ID

````