List Rows

List rows in a sheet, each containing a map of column_id → cell. Supports cursor pagination. Pass include_columns=true on the first page to receive column metadata alongside rows.

GET /api/public/v2/tables/{table_id}/sheets/{sheet_id}/rows

List Rows

cURL

curl --request GET \
  --url https://api.promptlayer.com/api/public/v2/tables/{table_id}/sheets/{sheet_id}/rows \
  --header 'X-API-KEY: <api-key>'

200

{
  "data": [
    {
      "row_index": 123,
      "cells": {}
    }
  ],
  "next_cursor": "<string>",
  "has_more": true,
  "row_count": 123,
  "columns": [
    {
      "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "sheet_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "workspace_id": 123,
      "title": "<string>",
      "config": {},
      "position_rank": 123,
      "is_output_column": true
    }
  ],
  "version": 123
}

List rows in a sheet. Each row contains a map of column_id → cell.

Pass include_columns=true (the default on the first page) to receive column metadata alongside rows — useful for building column headers.

Use cursor-based pagination for large sheets.

Authorizations

X-API-KEY · string · header · required

Path Parameters

table_id · string<uuid> · required

sheet_id · string<uuid> · required

Query Parameters

cursor · string

limit · integer · default: 100

Required range: 1 <= x <= 100

order · enum<string> · default: asc

Available options: asc, desc

include_columns · boolean

Include column metadata in the response. Defaults to true on the first page.

include_row_count · boolean · default: true

Response

200

application/json

List of rows

data · object[]

Each item represents one row.

Show child attributes

next_cursor · string | null

has_more · boolean

row_count · integer

columns · object[]

Show child attributes

version · integer