Zum Hauptinhalt springen
GET
/
cms
/
v3
/
hubdb
/
tables
/
draft
Return all draft tables
curl --request GET \
  --url https://api.hubapi.com/cms/v3/hubdb/tables/draft \
  --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"
    }
  ]
}
Unterstützte Produkte
Erfordert eines der folgenden Produkte oder höher.
Marketing HubMarketing HubKostenlos
Sales HubSales HubKostenlos
Service HubService HubKostenlos
Content HubContent HubKostenlos

Erforderliche Bereiche

Diese API erfordert einen der folgenden Bereiche:
  • 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
I