HubDBTable is a JSON Structure definition published by HubSpot, describing 9 properties. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.
{
"$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-dbtable-structure.json",
"name": "HubDBTable",
"description": "A HubDB table.",
"type": "object",
"properties": {
"id": {
"type": "string",
"description": "The unique identifier for the table.",
"example": "500123"
},
"name": {
"type": "string",
"description": "The machine-readable name of the table.",
"example": "Example Record"
},
"label": {
"type": "string",
"description": "The human-readable label for the table.",
"example": "Example Record"
},
"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.",
"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": [
{}
]
}
}
},
"example": [
{
"id": "500123",
"name": "Example Record",
"label": "Example Record",
"type": "TEXT",
"options": [
{}
]
}
]
},
"published": {
"type": "boolean",
"description": "Whether the table has been published.",
"example": true
},
"rowCount": {
"type": "int32",
"description": "The number of rows in the published table.",
"example": 10
},
"createdAt": {
"type": "datetime",
"description": "The date and time the table was created.",
"example": "2025-03-15T14:30:00Z"
},
"updatedAt": {
"type": "datetime",
"description": "The date and time the table was last updated.",
"example": "2025-03-15T14:30:00Z"
},
"publishedAt": {
"type": "datetime",
"description": "The date and time the table was last published.",
"example": "2025-03-15T14:30:00Z"
}
}
}