HubSpot · JSON Structure

Hubspot Cms Hubdb Collection Response Hub Db Table Structure

A paginated list of HubDB tables.

Type: object Properties: 2
AnalyticsCommerceContentCRMCustomer ServiceEmail MarketingMarketingMarketing AutomationOperationsSales

CollectionResponseHubDBTable is a JSON Structure definition published by HubSpot, describing 2 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

results paging

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑
{
  "type": "object",
  "description": "A paginated list of HubDB tables.",
  "name": "CollectionResponseHubDBTable",
  "properties": {
    "results": {
      "type": "array",
      "items": {
        "type": "object",
        "description": "A HubDB table.",
        "properties": {
          "id": {
            "type": "string",
            "description": "The unique identifier for the table."
          },
          "name": {
            "type": "string",
            "description": "The machine-readable name of the table."
          },
          "label": {
            "type": "string",
            "description": "The human-readable label for the table."
          },
          "columns": {
            "type": "array",
            "description": "The column definitions for the table.",
            "items": {
              "type": "object",
              "description": "A column definition in a HubDB table.",
              "properties": {
                "id": {
                  "type": "string",
                  "description": "The unique identifier for the column."
                },
                "name": {
                  "type": "string",
                  "description": "The machine-readable name of the column."
                },
                "label": {
                  "type": "string",
                  "description": "The human-readable label for the column."
                },
                "type": {
                  "type": "string",
                  "description": "The data type of the column.",
                  "enum": [
                    "TEXT",
                    "NUMBER",
                    "URL",
                    "IMAGE",
                    "SELECT",
                    "MULTISELECT",
                    "BOOLEAN",
                    "LOCATION",
                    "DATE",
                    "DATETIME",
                    "CURRENCY",
                    "RICHTEXT",
                    "FOREIGN_ID"
                  ]
                },
                "options": {
                  "type": "array",
                  "description": "Available options for SELECT and MULTISELECT columns.",
                  "items": {
                    "type": "object"
                  }
                }
              }
            }
          },
          "published": {
            "type": "boolean",
            "description": "Whether the table has been published."
          },
          "rowCount": {
            "type": "integer",
            "description": "The number of rows in the published table."
          },
          "createdAt": {
            "type": "datetime",
            "description": "The date and time the table was created."
          },
          "updatedAt": {
            "type": "datetime",
            "description": "The date and time the table was last updated."
          },
          "publishedAt": {
            "type": "datetime",
            "description": "The date and time the table was last published."
          }
        }
      }
    },
    "paging": {
      "type": "object",
      "description": "Pagination information.",
      "properties": {
        "next": {
          "type": "object",
          "properties": {
            "after": {
              "type": "string"
            }
          }
        }
      }
    }
  },
  "$schema": "https://json-structure.org/draft/2020-12/schema"
}