HubDB v3 API now in General Availability (GA)
Today we are excited to announce that we are releasing our HubDB V3 API into General Availability (GA) as part of our ongoing effort to improve the consistency and completeness of our developer APIs.
What's changing?
The following are changes in v3 of the HubDB API:
- Tables should have both
name
andlabel
. This name cannot be changed once the table is created. Names can only include lowercase letters, digits, and underscores and cannot begin with a number. Bothname
andlabel
should be unique in the account. - API supports both table
id
andname
in the URL paths. GET
row endpoints return columnname
instead ofid
invalues
field. Also,POST
/PUT
/PATCH
row endpoints require columnname
instead ofid
invalues
field.- Row update
PATCH
endpoints now accept sparse updates, which means you can specify only the column values that you need to update (whereas we had to specify all the column values in the previous versions). When you update a column with a list of values such as multi-select, you need to specify the list of all the values. In order to delete the value for a column, you need to specify the column with the value asnull
in the request. - Removed the endpoints to
GET
/UPDATE
/DELETE
a row cell in favor of the row updatePATCH
endpoints. - Import endpoint now supports an optional field
idSourceColumn
along with existing fields in the JSON-formatted options. You can use this field to specify the column in the csv file which contains row ids. To import new rows along with the new values for existing rows, you can specify0
as the row id for the new rows and the valid row ids for the existing columns. See more details in the Import section below. Also you can use column names or ids in the target field of the column mappings in the JSON-formatted options. - Clone endpoint requires a new name and new label.
If you have any questions or comments, please feel free to leave a message on the forum thread.