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>"
}
}
}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.
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
Supported products
Required Scopes
Required Scopes
Authorizations
The access token received from the authorization server in the OAuth 2.0 flow.
Path Parameters
The ID or name of the HubDB table.
Query Parameters
The paging cursor token of the last successfully read resource will be returned as the paging.next.after JSON property of a paged response containing more results.
Whether to return only results that have been archived.
The maximum number of results to display per page.
The properties to return.
The sorting behavior of the returned results.
Response
successful operation
- RANDOM_ACCESS
- STREAMING
Was this page helpful?