HUhubspot
Tables

Get details of a published table

Changed on

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.

get/cms/hubdb/2026-03/tables/{tableIdOrName}

Request

  • Base URL
    https://api.hubapi.com
  • URL
    https://api.hubapi.com/cms/hubdb/2026-03/tables/{tableIdOrName}
  • Auth
    • OAuth 2
      Authorization code: https://app.hubspot.com/oauth/authorize
      Token URL: https://api.hubapi.com/oauth/v1/token scopes: hubdb
    • or OAuth 2
      Authorization code: https://app.hubspot.com/oauth/authorize
      Token URL: https://api.hubapi.com/oauth/v1/token scopes: hubdb.tables.read

Path parameters

tableIdOrNamestring required

The unique identifier or name of the table to retrieve.

Query parameters

archivedboolean

Whether to return only results that have been archived.

includeForeignIdsboolean

Include foreign IDs in the response.

isGetLocalizedSchemaboolean

Retrieve the localized schema if available.

Response

successful operation

allowChildTablesboolean required

Specifies whether child tables can be created

allowPublicApiAccessboolean required

Specifies whether the table can be read by public without authorization

columnCountinteger required

Number of columns including deleted

createdAtstring date-time required

Timestamp at which the table is created

deletedboolean required

Specifies whether the table is marked as deleted.

deletedAtstring date-time required

The timestamp indicating when the table was deleted.

dynamicMetaTagsobject required

Specifies the key value pairs of the metadata fields with the associated column IDs.

enableChildTablePagesboolean required

Specifies creation of multi-level dynamic pages using child tables

idstring required

Id of the table

isOrderedManuallyboolean

Indicates whether the table rows are ordered manually.

labelstring required

Label of the table

namestring required

Name of the table

publishedboolean required

Indicates whether the table is currently published.

publishedAtstring date-time required

Timestamp at which the table is published recently

rowCountinteger required

Number of rows in the table

updatedAtstring date-time required

Timestamp at which the table is updated recently

useForPagesboolean required

Specifies whether the table can be used for creation of dynamic pages

Changes

  • 2026-0357dfaa14c811Revision changes
    • info

      the security scope hubdb was added to the endpoint's security scheme oauth2

    • info

      the security scope hubdb.tables.read was removed from the endpoint's security scheme oauth2

  • 2026-0308b7d0c88aa0Revision changes
    • info

      the security scope hubdb.tables.read was added to the endpoint's security scheme oauth2

    • info

      the security scope hubdb-schemas-read was removed from the endpoint's security scheme oauth2