HubSpot · JSON Structure

Cms Hubdb Api Hub Dbcolumn Structure

A column definition in a HubDB table.

Type: object Properties: 5
AnalyticsCommerceContentCRMCustomer ServiceEmail MarketingMarketingMarketing AutomationOperationsSales

HubDBColumn is a JSON Structure definition published by HubSpot, describing 5 properties. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.

Properties

id name label type options

Meta-schema: https://json-structure.org/meta/core/v0/#

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/meta/core/v0/#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/hubspot/refs/heads/main/json-structure/cms-hubdb-api-hub-dbcolumn-structure.json",
  "name": "HubDBColumn",
  "description": "A column definition in a HubDB table.",
  "type": "object",
  "properties": {
    "id": {
      "type": "string",
      "description": "The unique identifier for the column.",
      "example": "500123"
    },
    "name": {
      "type": "string",
      "description": "The machine-readable name of the column.",
      "example": "Example Record"
    },
    "label": {
      "type": "string",
      "description": "The human-readable label for the column.",
      "example": "Example Record"
    },
    "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"
      ],
      "example": "TEXT"
    },
    "options": {
      "type": "array",
      "description": "Available options for SELECT and MULTISELECT columns.",
      "items": {
        "type": "object"
      },
      "example": [
        {}
      ]
    }
  }
}