---
title: "GetDatasetValues"
method: POST
path: "/textql.rpc.public.dataset.DatasetService/GetDatasetValues"
tags: ["DatasetService"]
---

# GetDatasetValues

`POST /textql.rpc.public.dataset.DatasetService/GetDatasetValues`

## Headers

- `Connect-Protocol-Version` 1, required — Define the version of the Connect protocol
- `Connect-Timeout-Ms` number — Define the timeout, in ms

## Request body

- TextqlRpcPublicDatasetGetDatasetValuesRequest
  - `datasetId` string
  - `versionId` integer, nullable — default to latest version
  - `limit` integer, nullable — defaults to 10,000
  - `page` integer, nullable
  - `sheet` integer, nullable — for multi-sheet excels

## Response `200`

Success

- TextqlRpcPublicDatasetGetDatasetValuesResponse
  - `df` TextqlRpcPublicDataframeDataFrame
    - `schema` TextqlRpcPublicDataframeDataFrameField[]
      - `columnName` string
      - `columnType` string
      - `columnIndex` integer
    - `records` TextqlRpcPublicDataframeDataFrameRecord[]
      - `columns` TextqlRpcPublicDataframeDataFrameColumn[]
        - union
          - object
            - `columnIndex` integer
            - `bools` TextqlRpcPublicDataframeBoolValues, required
              - …
          - object
            - `columnIndex` integer
            - `bytes` TextqlRpcPublicDataframeByteValues, required
              - …
          - object
            - `columnIndex` integer
            - `doubles` TextqlRpcPublicDataframeDoubleValues, required
              - …
          - object
            - `columnIndex` integer
            - `floats` TextqlRpcPublicDataframeFloatValues, required
              - …
          - object
            - `columnIndex` integer
            - `int32` TextqlRpcPublicDataframeInt32Values, required
              - …
          - object
            - `columnIndex` integer
            - `int64` TextqlRpcPublicDataframeInt64Values, required
              - …
          - object
            - `columnIndex` integer
            - `strings` TextqlRpcPublicDataframeStringValues, required
              - …
          - object
            - `columnIndex` integer
            - `timestamps` TextqlRpcPublicDataframeTimestampValues, required
              - …
          - object
            - `columnIndex` integer
            - `uint32` TextqlRpcPublicDataframeUint32Values, required
              - …
          - object
            - `columnIndex` integer
            - `uint64` TextqlRpcPublicDataframeUint64Values, required
              - …
  - `numCols` union
    - integer
    - string, int64
  - `numRows` union
    - integer
    - string, int64

## Other responses

- `default` — Error

---

[API](https://skmtc.net/textql/apis/textql-rpc-platform.md) · [All operations](https://skmtc.net/textql/apis/textql-rpc-platform/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/textql/textql-rpc-platform/versions/31ce2b0c4427/schema)