Get rows for a table

curl --request GET \
  --url https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName}/rows \
  --header 'Authorization: Bearer <token>'

{
  "results": [
    "<unknown>"
  ],
  "total": 123,
  "type": "RANDOM_ACCESS",
  "paging": {
    "next": {
      "offset": 123,
      "link": "<string>"
    }
  }
}

Rows

Get rows for a table

Returns a set of rows in the published version of the specified table. Row results can be filtered and sorted. Filtering and sorting options will be sent as query parameters to the API request. For example, by adding the query parameters column1__gt=5&sort=-column1, API returns the rows with values for column column1 greater than 5 and in the descending order of column1 values. Refer to the overview section for detailed filtering and sorting options. Note: This endpoint can be accessed without any authentication, if the table is set to be allowed for public access.

GET

cms

hubdb

tables

{tableIdOrName}

rows

Get rows for a table

curl --request GET \
  --url https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName}/rows \
  --header 'Authorization: Bearer <token>'

{
  "results": [
    "<unknown>"
  ],
  "total": 123,
  "type": "RANDOM_ACCESS",
  "paging": {
    "next": {
      "offset": 123,
      "link": "<string>"
    }
  }
}

Supported products

Requires one of the following products or higher.

Marketing Hub -Professional

Sales Hub -Free

Service Hub -Free

Content Hub -Professional

Data Hub -Free

Required Scopes

Authorizations

Authorization

string

header

required

The access token received from the authorization server in the OAuth 2.0 flow.

Path Parameters

tableIdOrName

string

required

The ID or name of the table to query.

Query Parameters

after

string

The cursor token value to get the next set of results. You can get this from the paging.next.after JSON property of a paged response containing more results.

archived

boolean

Specifies whether to include archived rows in the response.

limit

integer<int32>

The maximum number of results to return. Default is 1000.

offset

integer<int32>

The number of rows to skip before starting to return results.

properties

string[]

Specify the column names to get results containing only the required columns instead of all column details.

sort

string[]

Specifies the column names to sort the results by. See the above description for more details.

Response

successful operation

RANDOM_ACCESS
STREAMING

results

any[]

required

total

integer<int32>

required

The total number of rows available in the collection.

type

enum<string>

default:RANDOM_ACCESS

required

Indicates the type of response, which is 'RANDOM_ACCESS' by default.

Available options:

RANDOM_ACCESS

paging

object

Show child attributes

Last modified on December 16, 2025