Products
Query the available products in HubSpot.
Table Specific Information
Products are a foundational object in HubSpot CRM. Products represent goods or services sold by your company.
SELECT
When selecting products, they can be filtered by ID or by ID and IncludeDeleted. For example:
SELECT * FROM Products WHERE Id = '123456789' SELECT * FROM Products WHERE Id = '123456789' AND IncludeDeleted = 'true'
INSERT
When creating products, you can specify Name, Description and Price. For example:
INSERT INTO Products (Name, Description, Price) VALUES ('NameExample', 'This is a description', 1324)
UPDATE
When updating products, you can change Name, Description and Price by specifying the product Id. For example:
UPDATE Products SET Name = 'UpdatedName', Description = 'Updated desciption', Price = 123 WHERE id = '123'
DELETE
You can delete products singularly by Id, or in batches. For example:
DELETE FROM Products WHERE Id = 123 DELETE FROM Products WHERE Id IN ( '123', '234')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The internal ID for this product. | |
| Name | String | False |
The name of the product. | |
| Sku | String | False |
The SKU of the product. | |
| Price | String | False |
The price of the product. | |
| Description | String | False |
The description of the product. | |
| Version | Integer | True |
The current version of the product. This is incremented each time the product is updated. | |
| IsDeleted | Boolean | False |
Boolean indicating whether or not the product is deleted. Deleted records will not be included unless you specifically request that deleted records be included. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description |
| IncludeDeleted | String |
By default, deleted records will not be returned by the API. When selecting by Id, you can include this parameter to make sure that records are returned even when they are deleted |