curl --request GET \
--url https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName} \
--header 'Authorization: Bearer <token>'
{
"dynamicMetaTags": {},
"updatedBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"allowPublicApiAccess": true,
"useForPages": true,
"publishedAt": "2023-11-07T05:31:56Z",
"columns": [
{
"createdByUserId": 123,
"foreignTableId": 123,
"updatedBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"description": "<string>",
"label": "<string>",
"updatedByUserId": 123,
"type": "NULL",
"optionCount": 123,
"foreignIds": [
{
"name": "<string>",
"id": "<string>",
"type": "<string>"
}
],
"createdAt": "2023-11-07T05:31:56Z",
"deleted": true,
"createdBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"name": "<string>",
"options": [
{
"createdByUserId": 123,
"createdAt": "2023-11-07T05:31:56Z",
"updatedBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"createdBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"name": "",
"id": "",
"label": "",
"updatedByUserId": 123,
"type": "",
"order": 123,
"updatedAt": "2023-11-07T05:31:56Z"
}
],
"width": 123,
"id": "<string>",
"foreignIdsById": {},
"foreignColumnId": 123,
"foreignIdsByName": {},
"updatedAt": "2023-11-07T05:31:56Z"
}
],
"label": "<string>",
"published": true,
"columnCount": 123,
"allowChildTables": true,
"createdAt": "2023-11-07T05:31:56Z",
"deletedAt": "2023-11-07T05:31:56Z",
"deleted": true,
"createdBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"name": "<string>",
"enableChildTablePages": true,
"id": "<string>",
"rowCount": 123,
"isOrderedManually": true,
"updatedAt": "2023-11-07T05:31:56Z"
}
Returns the details for the published version of the specified table. This will include the definitions for the columns in the table and the number of rows in the table.
Note: This endpoint can be accessed without any authentication if the table is set to be allowed for public access. To do so, you’ll need to include the HubSpot account ID in a portalId
query parameter.
curl --request GET \
--url https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName} \
--header 'Authorization: Bearer <token>'
{
"dynamicMetaTags": {},
"updatedBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"allowPublicApiAccess": true,
"useForPages": true,
"publishedAt": "2023-11-07T05:31:56Z",
"columns": [
{
"createdByUserId": 123,
"foreignTableId": 123,
"updatedBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"description": "<string>",
"label": "<string>",
"updatedByUserId": 123,
"type": "NULL",
"optionCount": 123,
"foreignIds": [
{
"name": "<string>",
"id": "<string>",
"type": "<string>"
}
],
"createdAt": "2023-11-07T05:31:56Z",
"deleted": true,
"createdBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"name": "<string>",
"options": [
{
"createdByUserId": 123,
"createdAt": "2023-11-07T05:31:56Z",
"updatedBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"createdBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"name": "",
"id": "",
"label": "",
"updatedByUserId": 123,
"type": "",
"order": 123,
"updatedAt": "2023-11-07T05:31:56Z"
}
],
"width": 123,
"id": "<string>",
"foreignIdsById": {},
"foreignColumnId": 123,
"foreignIdsByName": {},
"updatedAt": "2023-11-07T05:31:56Z"
}
],
"label": "<string>",
"published": true,
"columnCount": 123,
"allowChildTables": true,
"createdAt": "2023-11-07T05:31:56Z",
"deletedAt": "2023-11-07T05:31:56Z",
"deleted": true,
"createdBy": {
"firstName": "<string>",
"lastName": "<string>",
"id": "<string>",
"email": "<string>"
},
"name": "<string>",
"enableChildTablePages": true,
"id": "<string>",
"rowCount": 123,
"isOrderedManually": true,
"updatedAt": "2023-11-07T05:31:56Z"
}
hubdb
The access token received from the authorization server in the OAuth 2.0 flow.
successful operation
The response is of type object
.