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.

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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。詳細については、WHERE 句のセクションを参照してください。


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