Skip to main content
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"
    }
  ]
}
Productos compatibles
Se requiere uno de los siguientes productos o productos de ediciones superiores.
Marketing HubMarketing HubGratuito
Sales HubSales HubGratuito
Service HubService HubGratuito
Content HubContent HubGratuito

​
Ámbitos Requeridos

Esta API requiere uno de los siguientes ámbitos:
  • 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