---
title: "Get a data table's data."
method: GET
path: "/api/v1/DataTables/Data"
tags: ["DataTables"]
---

# Get a data table's data.

`GET /api/v1/DataTables/Data`

## Request

- Base URL: `https://api.slopesoftware.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.slopesoftware.com/api/v1/DataTables/Data`
- Auth: HTTP bearer
- TypeScript: <https://skmtc.dev/slopesoftware/apis/akur8-life-api/docs/api/v1/DataTables/Data/get.ts> (a function with typed inputs; its response is checked against the schema)

Either the data table ID must be provided, or the data table's name along with its associated table structure ID must be provided. <br/>If the data table is file only, then a file path to the file along with the file version will be returned so that it can be used with the GetDownloadUrl endpoint. <br/>For other data tables the rows are returned in the response up to the limit. The default limit is 2,000 and the max limit is 10,000. <br/>If the row limit is reached, then an offset is returned that can be used in a subsequent request to get the next set of rows. <br/>The response includes the TableStructureId of the table structure the data table is a part of, even when the requested data table is not the latest version.

## Query parameters

- `DataTableId` integer
- `Name` string
- `Version` integer
- `TableStructureId` integer
- `Fields` string
- `Limit` integer
- `Offset` integer

## Response `200`

OK

- GetDataTableResponseV1
  - `id` integer
  - `name` string, nullable
  - `tableStructureId` integer, nullable
  - `filePath` string, nullable
  - `fileVersion` integer, nullable
  - `columns` GetDataTableResponseColumnV1[], nullable
    - `name` string, nullable
    - `order` integer
    - `isIndex` boolean
    - `indexReadMethod` string, nullable
    - `dataType` string, nullable
    - `displayPrecision` integer, nullable
    - `dropDownListArrayId` integer, nullable
    - `nestedTableStructureId` integer, nullable
  - `rows` array[], nullable
    - string[]
  - `offset` integer, nullable

## Other responses

- `201`: Created
- `400`: Bad Request
- `401`: Unauthorized
- `403`: Not Allowed To Access
- `404`: Not Found
- `429`: Too Many Requests

---

[API](https://skmtc.dev/slopesoftware/apis/akur8-life-api.md) - [All operations](https://skmtc.dev/slopesoftware/apis/akur8-life-api/llms.txt) - [OpenAPI document](https://skmtc.dev/slopesoftware/apis/akur8-life-api/revisions/9771b2c79880?raw)