Products

Retrieves product records configured in HubSpot, useful for inventory, pricing, and catalog management.

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 unique internal ID assigned to the product in HubSpot.
Name	String	False		The name of the product as it appears in HubSpot.
Sku	String	False		The Stock Keeping Unit (SKU) code used to identify and track the product.
Price	String	False		The price of the product, typically represented as a string to allow currency symbols or formatting.
Description	String	False		A descriptive summary of the product, detailing its key features or specifications.
Version	Integer	True		The version number of the product record. This value increments each time the product is updated to track changes.
IsDeleted	Boolean	False		Boolean indicating whether the product has been marked as deleted. Deleted products are excluded from results unless explicitly requested.

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


Name	Type	Description
IncludeDeleted	String	Optional input parameter that, when set, includes deleted product records in query results. Useful for auditing or historical data retrieval.