Zum Hauptinhalt springen
GET
/
cms
/
v3
/
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>'
{
  "paging": {
    "next": {
      "link": "<string>",
      "offset": 123
    }
  },
  "results": [
    "<any>"
  ],
  "total": 123,
  "type": "RANDOM_ACCESS"
}

Produits pris en charge

Exige l'un des produits suivants ou un produit supérieur.
Marketing HubMarketing Hub -Gratuit
Sales HubSales Hub -Gratuit
Service HubService Hub -Gratuit
Content HubContent Hub -Gratuit
Cette API requiert l'une des portées suivantes :
hubdb

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
​
limit
integer

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

​
offset
integer
​
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
required
​
type
enum<string>
default:RANDOM_ACCESS
required
Verfügbare Optionen:
RANDOM_ACCESS
​
paging
object