ODBC Driver for HubSpot

Build 23.0.8839


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.


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'


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)


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' 


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')


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 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839