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"
    }
  ]
}
Produtos suportados
Requer um dos seguintes produtos ou superior.
Marketing HubMarketing HubGrátis
Sales HubSales HubGrátis
Service HubService HubGrátis
Content HubContent HubGrátis

Escopos Necessários

Esta API requer um dos seguintes escopos:
  • 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