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>'
{
  "total": 123,
  "paging": {
    "next": {
      "offset": 123,
      "link": "<string>"
    }
  },
  "type": "RANDOM_ACCESS",
  "results": [
    "<any>"
  ]
}
Produits pris en charge
Exige l'un des produits suivants ou un produit supérieur.
Marketing HubMarketing HubGratuit
Sales HubSales HubGratuit
Service HubService HubGratuit
Content HubContent HubGratuit

​
Portées requises

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

​
sort
string[]

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

​
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.

​
limit
integer

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

​
properties
string[]

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

​
offset
integer
​
archived
boolean

Response

successful operation

  • RANDOM_ACCESS
  • STREAMING
​
total
integer
required
​
type
enum<string>
default:RANDOM_ACCESS
required
Available options:
RANDOM_ACCESS
​
results
any[]
required
​
paging
object
⌘I