List Rows

List Rows

curl --request GET \
  --url https://api.sheetninja.io/{endpointNamespace}/{projectName}/{tabSlug} \
  --header 'Authorization: Bearer <token>'

{
  "data": [
    {
      "id": 123
    }
  ],
  "meta": {
    "limit": 123,
    "offset": 123,
    "has_more": true,
    "next_offset": 123
  }
}

GET

{endpointNamespace}

{projectName}

{tabSlug}

List Rows

curl --request GET \
  --url https://api.sheetninja.io/{endpointNamespace}/{projectName}/{tabSlug} \
  --header 'Authorization: Bearer <token>'

{
  "data": [
    {
      "id": 123
    }
  ],
  "meta": {
    "limit": 123,
    "offset": 123,
    "has_more": true,
    "next_offset": 123
  }
}

Authorization

string

header

required

The Bearer Token associated with your endpoint. This is only required if you have enabled protection for this endpoint.

endpointNamespace

string

required

Your unique user namespace (e.g., c01c052...)

projectName

string

required

The slugified name of your project

tabSlug

string

required

The slugified name of the specific worksheet (tab)

limit

integer

default:100

Number of rows to return per page (Default: 100 for Trial)

offset

integer

default:0

Number of rows to skip (0-indexed)

The row data will be returned to you as JSON along with the row ID

Enveloped response containing the requested worksheet data and pagination metadata

data

object[]

An array of row objects corresponding to the Google Sheet rows

Show child attributes