Add a new row to a table

POST /hubdb/api/v1/tables/:tableId/rows

Method Details

HTTP Methods:

POST

Content Type:

application/json

Response Format:

json

Requires Authentication?

Yes

Rate Limited?

Yes

Headers

User-Agent

Products:

Marketing

Add a new row to a HubDB table.
Required Parameters How to use Description
OAuth Access Token or API Key Authorization: Bearer {token} header
or hapikey={key} query parameter.
Used to authenticate the request. Please see this page for more details about authentication.
Table ID :tableId
used in the URL
The ID of the table you want to add the row to.

Optional Parameters How to use Description
Cell Value "values": [ {list of cell values} ]
Used in the request
A list of values for the cells in the row. Each entry retuires a column id that you would get when pulling the the details for the table, and the value being set for that column. For example, when setting a field with id 2 and type TEXT to use the value 'test':
"2": "test"
See below for more details for the values used by specific column types.

Value types

Below you'll find details for the format of the data used for the different column types. Each Example assumes you're setting a field with the column id of '2'

Column Type Value type Example
TEXT A simple string "2": "Example Text"
RICHTEXT A string that supports HTML "2": "<p>This is some text.</p>"
NUMBER A number, supports decimal values "2": 7.1354
BOOLEAN 0 for false or 1 for true "2": 1
DATE A Unix formatted timestamp in milliseconds. Must be set to midnight UTC time for the specified date. For example, the value of 02 Jan 2017 is 1483315200000. "2": 1483315200000
DATETIME A Unix formatted timestamp in milliseconds. The example would be for 06 Jan 2017 05:00:00 UTC "2": 1483678800000
SELECT An object representing one of a set of options set in the column definition. The name and id of the value will correspond to the column settings. "2": {"id": 4,"name": "d","type": "option"}
URL A string representing a URL "2" : "https://integrate.hubspot.com/"
LOCATION An object representing latitude and longitude coordinates. "2":{"lat": 41.836826, "long": -88.461914, "type": "location"}
IMAGE An object including a URL of an image. "2" : {"url": "http://s3.amazonaws.com/cdn1.hubspot.com/StockImages/Expressions/7K0A0014-2.jpg}