CData Python Connector for HubSpot

Build 24.0.9060

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

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