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

# Get Dataset Rows

> Retrieve paginated rows. Supports column projection and sorting.



## OpenAPI

````yaml GET /datasets/{datasetId}/rows
openapi: 3.1.1
info:
  title: Adaline API
  version: 2.0.0
  description: >-
    Public API for managing Adaline projects, prompts, datasets, evaluators,
    evaluations, providers, models, and deployments.


    Generated from Zod schemas — this spec is the single source of truth.
servers:
  - url: https://api.adaline.ai/v2
    description: Production API
security: []
tags:
  - name: datasets
    description: Manage prompt datasets and their columns and rows.
  - name: projects
    description: List and manage Adaline projects.
  - name: providers
    description: List configured LLM providers and their settings.
  - name: models
    description: List available models across providers.
  - name: prompts
    description: Create and manage prompts and their drafts.
  - name: evaluators
    description: Configure evaluators attached to a prompt.
  - name: evaluations
    description: Run and inspect evaluation results.
  - name: deployments
    description: Retrieve deployed prompt snapshots.
  - name: logs
    description: Ingest execution traces and spans for observability.
paths:
  /datasets/{datasetId}/rows:
    get:
      tags:
        - datasets
      summary: Get dataset rows
      description: Retrieve paginated rows. Supports column projection and sorting.
      operationId: getDatasetRows
      parameters:
        - schema:
            $ref: '#/components/schemas/BaseEntityId'
          required: true
          name: datasetId
          in: path
        - schema:
            type: string
          required: false
          name: columns
          in: query
        - schema:
            $ref: '#/components/schemas/SortOrder'
          required: false
          name: sort
          in: query
        - schema:
            type:
              - integer
              - 'null'
            minimum: 0
          required: false
          name: createdAfter
          in: query
        - schema:
            type:
              - integer
              - 'null'
            minimum: 0
          required: false
          name: createdBefore
          in: query
        - schema:
            type: integer
            exclusiveMinimum: 0
            maximum: 200
          required: false
          name: limit
          in: query
        - schema:
            type: string
            minLength: 1
          required: false
          name: cursor
          in: query
      responses:
        '200':
          description: Rows retrieved.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ListDatasetRowsResponse'
          headers:
            X-Request-Id:
              description: >-
                Unique identifier for the request. Returned in every response.
                Send a custom value to correlate requests, or omit to receive a
                generated UUID.
              schema:
                type: string
                format: uuid
        '400':
          description: Bad request — validation error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '401':
          description: Unauthorized — invalid or missing API key.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '403':
          description: Forbidden — API key lacks access.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '404':
          description: Not found.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
      security:
        - bearerAuth: []
components:
  schemas:
    BaseEntityId:
      title: Base Entity ID
      type: string
      description: Unique identifier for an entity, between 20 and 80 characters.
      minLength: 20
      maxLength: 80
    SortOrder:
      title: Sort Order
      type: string
      enum:
        - createdAt:asc
        - createdAt:desc
      description: Sort order for list endpoints.
    ListDatasetRowsResponse:
      type: object
      properties:
        rows:
          type: array
          items:
            $ref: '#/components/schemas/DatasetRow'
        pagination:
          $ref: '#/components/schemas/Pagination'
      required:
        - rows
        - pagination
      title: List Dataset Rows Response
      description: Paginated list of dataset rows.
    ErrorResponse:
      title: Error Response
      type: object
      description: >-
        Standard error response envelope. Permits backend-specific sibling
        fields (e.g. Zod issue details) alongside the typed `error`.
      properties:
        error:
          description: >-
            Error details — typed envelope, or a raw string reason when the
            backend's validator produces a short summary (e.g. Zod validation
            fallback).
          oneOf:
            - type: string
            - type: object
              properties:
                code:
                  type: string
                  description: Machine-readable error code.
                  enum:
                    - VALIDATION_ERROR
                    - INVALID_CURSOR
                    - AUTHENTICATION_REQUIRED
                    - FORBIDDEN
                    - RESOURCE_NOT_FOUND
                    - CONFLICT
                    - PAYLOAD_TOO_LARGE
                    - RATE_LIMITED
                    - INTERNAL_ERROR
                message:
                  type: string
                  description: Human-readable error message.
                details:
                  type: array
                  description: Optional field-level validation details.
                  items:
                    type: object
                    properties:
                      field:
                        type: string
                      issue:
                        type: string
                    required:
                      - field
                      - issue
              required:
                - code
                - message
              additionalProperties: true
      required:
        - error
      additionalProperties: true
    DatasetRow:
      title: Dataset Row
      type: object
      description: >-
        A single row of data in a dataset. Each key in `values` is a column ID
        (or column name when `keyBy=name`), and each value is a typed cell with
        its modality.
      properties:
        id:
          $ref: '#/components/schemas/BaseEntityId'
        values:
          type: object
          description: Cell values keyed by column identifier.
          additionalProperties:
            $ref: '#/components/schemas/DatasetCellResponse'
        createdAt:
          $ref: '#/components/schemas/UnixTimestamp'
        updatedAt:
          $ref: '#/components/schemas/UnixTimestamp'
      required:
        - id
        - values
        - createdAt
        - updatedAt
    Pagination:
      title: Pagination
      type: object
      description: Pagination metadata for list endpoints with cursor-based navigation.
      properties:
        limit:
          type: integer
          exclusiveMinimum: 0
        returned:
          type: integer
          minimum: 0
        hasMore:
          type: boolean
        nextCursor:
          type:
            - string
            - 'null'
      required:
        - limit
        - returned
        - hasMore
        - nextCursor
    DatasetCellResponse:
      title: Dataset Cell Response
      description: >-
        A cell value returned by the API. Discriminated by `modality` — the
        shape of `value` depends on the modality.
      oneOf:
        - type: object
          title: Text Cell
          description: A plain text cell value.
          properties:
            modality:
              type: string
              enum:
                - text
            value:
              type:
                - string
                - 'null'
          required:
            - modality
            - value
        - type: object
          title: Image Cell
          description: >-
            An image cell — value is a URL reference, inline base64 data, or
            null.
          properties:
            modality:
              type: string
              enum:
                - image
            value:
              oneOf:
                - $ref: '#/components/schemas/DatasetCellUrlReference'
                - $ref: '#/components/schemas/DatasetCellBase64Image'
                - type: 'null'
          required:
            - modality
            - value
        - type: object
          title: PDF Cell
          description: >-
            A PDF cell — value is a URL reference (possibly with preview),
            inline base64, or null.
          properties:
            modality:
              type: string
              enum:
                - pdf
            value:
              oneOf:
                - $ref: '#/components/schemas/DatasetCellUrlReference'
                - $ref: '#/components/schemas/DatasetCellBase64Pdf'
                - type: 'null'
          required:
            - modality
            - value
        - type: object
          title: API Cell
          description: >-
            An API-driven cell — value contains the endpoint config (url +
            method), or null if unconfigured.
          properties:
            modality:
              type: string
              enum:
                - api
            value:
              oneOf:
                - $ref: '#/components/schemas/DatasetCellApiConfig'
                - type: 'null'
          required:
            - modality
            - value
        - type: object
          title: Prompt Cell
          description: >-
            A prompt-driven cell — value contains the prompt reference, or null
            if unconfigured.
          properties:
            modality:
              type: string
              enum:
                - prompt
            value:
              oneOf:
                - $ref: '#/components/schemas/DatasetCellPromptRef'
                - type: 'null'
          required:
            - modality
            - value
        - type: object
          title: Error Cell
          description: An error cell — value may contain error details or be null.
          properties:
            modality:
              type: string
              enum:
                - error
            value: {}
          required:
            - modality
            - value
      discriminator:
        propertyName: modality
    UnixTimestamp:
      title: Unix Timestamp
      type: integer
      format: int64
      description: Unix timestamp in milliseconds.
      minimum: 1672511400000
      maximum: 33229420200000
    DatasetCellUrlReference:
      title: Dataset Cell URL Reference
      type: object
      description: A reference to a file accessible via URL.
      properties:
        type:
          type: string
          enum:
            - url
        uri:
          type: string
          format: uri
        preview:
          type: string
          description: Optional base64-encoded preview (PDF only).
      required:
        - type
        - uri
    DatasetCellBase64Image:
      title: Dataset Cell Base64 Image
      type: object
      description: An inline base64-encoded image.
      properties:
        type:
          type: string
          enum:
            - base64
        base64:
          type: string
        mediaType:
          type: string
          enum:
            - png
            - jpeg
            - webp
            - gif
      required:
        - type
        - base64
        - mediaType
    DatasetCellBase64Pdf:
      title: Dataset Cell Base64 PDF
      type: object
      description: An inline base64-encoded PDF document.
      properties:
        type:
          type: string
          enum:
            - base64
        base64:
          type: string
      required:
        - type
        - base64
    DatasetCellApiConfig:
      title: Dataset Cell API Config
      type: object
      description: >-
        Configuration for an API-driven cell. Secret headers and request bodies
        are redacted.
      properties:
        url:
          type: string
        method:
          $ref: '#/components/schemas/ApiHttpMethod'
      required:
        - url
        - method
    DatasetCellPromptRef:
      title: Dataset Cell Prompt Reference
      type: object
      description: A reference to a prompt used by a prompt-driven cell.
      properties:
        promptId:
          $ref: '#/components/schemas/BaseEntityId'
      required:
        - promptId
    ApiHttpMethod:
      title: HTTP Method
      type: string
      enum:
        - GET
        - POST
        - PUT
        - PATCH
        - DELETE
      description: Standard HTTP request method.
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: API Key
      description: 'Workspace API key. Pass as `Authorization: Bearer <key>`.'

````