There's a new version of the HubSpot API

Check out the new API
View Beta Docs

We're also working on a new documentation website, you're invited to check it out and give us your feedback.

Update a table

Last updated January 31, 2024

PUT /hubdb/api/v2/tables/:tableId

Please note: as of January 31, 2024, the HubDB v2 API has been sunsetted. The associated endpoints will not be fully turned off until a future date in 2024, but if you're using this API, please migrate to the HubDB v3 API, which includes many performance, usability, and API consistency improvements over the previous two versions. Learn more about this sunset on the HubSpot Developer Changelog.

Update an existing HubDB table. You can use this endpoint to add or remove a column, or to publish a table that's ready to be used.

Table updates will modify the draft table. Use the /publish  endpoint to push all changes live.

Required Parameters How to use Description
OAuth access token or private app access token Authorization: Bearer {token} header Used to authenticate the request. Please see this page for more details about authentication.

Optional Parameters How to use Description
Update Draft details /draft
Used in the request URL		 Include /draft at the end of the request path to update the draft version of the table.
Name "name": {new name}
Used in the request		 Renames the table
Use for pages "useForPages": {true or false}
Used in the request		 Set this to true to enable the table for dynamic pages.
Published at "publishedAt":{millisecond timestamp
Used in the request		 Set this to the current (or a past) time to publish a table that's ready to be used
Columns "columns": [ {column list} ]
Used in the request		 Updates the columns in the table. See creating a table for the column definitions.
IMPORTANT: Data in this field overwrites the existing columns. If you want to add a new column, you'll need to include the existing columns and the new column in the request.

About

Jobs

Learn Inbound

Support

Locations

HubSpot, Inc.
25 First Street, 2nd Floor
Cambridge, MA 02141
European Headquarters
Ground Floor, Two Dockland Central
Guild Street, Dublin 1
Asia/Pacific Office
20 Hunter St, Level 7
Sydney NSW 2000
View our other locations
Example PUT URL: https://api.hubapi.com/hubdb/api/v2/tables/360123 Example requests: Update the name of the table: {"name":"Updated Table"} Publish a table: {"publishedAt":1483246800000} Enable the table for use in dynamic pages: {"useForPages": true} Update the table to include an existing TEXT column named 'Name' and id 1, and add a new NUMBER column named 'number' IMPORTANT: You must include the 'id' for any existing columns to prevent a new column with the same name and type from replacing the existing column. New column IDs are assigned automatically: { "columns": [ { "name": "Name", "label": null, "id": 1, "type": "TEXT" }, { "label": "number", "name": "number", "type": "NUMBER" } ] } Example response: { "id": 360123, "name": "Updated Table", "useForPages": false, "createdAt": 1483726257970, "publishedAt": null, "updatedAt": 1483735050011, "columns": [ { "name": "Name", "label": null, "id": 1, "type": "TEXT" }, { "name": "number", "label": "number", "id": 4, "type": "NUMBER" } ], "deleted": false, "rowCount": 0, "createdBy": null, "updatedBy": null, "columnCount": 4 }