Zum Hauptinhalt springen
GET
/
cms
/
v3
/
hubdb
/
tables
Get all published tables
curl --request GET \
  --url https://api.hubapi.com/cms/v3/hubdb/tables \
  --header 'Authorization: Bearer <token>'
{
  "total": 123,
  "paging": {
    "next": {
      "link": "",
      "after": ""
    }
  },
  "results": [
    {
      "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"
    }
  ]
}
サポートされる製品
次のいずれかの製品またはそれ以上が必要です。
Marketing HubMarketing Hub無料ツール
Sales HubSales Hub無料ツール
Service HubService Hub無料ツール
Content HubContent Hub無料ツール

必須スコープ

この API には、次のいずれかのスコープが必要です。
  • hubdb

Authorizations

Authorization
string
header
required

The access token received from the authorization server in the OAuth 2.0 flow.

Query Parameters

sort
string[]

Specifies which fields to use for sorting results. Valid fields are name, createdAt, updatedAt, createdBy, updatedBy. createdAt will be used by default.

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.

createdAt
string<date-time>

Only return tables created at exactly the specified time.

createdAfter
string<date-time>

Only return tables created after the specified time.

createdBefore
string<date-time>

Only return tables created before the specified time.

updatedAt
string<date-time>

Only return tables last updated at exactly the specified time.

updatedAfter
string<date-time>

Only return tables last updated after the specified time.

updatedBefore
string<date-time>

Only return tables last updated before the specified time.

contentType
string
archived
boolean

Specifies whether to return archived tables. Defaults to false.

isGetLocalizedSchema
boolean

Response

successful operation

total
integer
required
results
object[]
required
paging
object