LineItems
Retrieves all line items in HubSpot, commonly used in association with deals and transactions.
Table Specific Information
A line item represents a line in an order, containing details such as the product, quantity, and price for each line of an order.
SELECT
When selecting line items, they can be filtered by ID or by ID and IncludeDeleted. For example:
SELECT * FROM LineItems WHERE Id = '123456789' SELECT * FROM LineItems WHERE Id = '123456789' AND IncludeDeleted = 'true'
INSERT
When creating a new line item ProductId is required. You can also specify Name, Description, Price and Quantity. For example:
INSERT INTO LineItems (ProductId, Name, Description, Quantity, Price) VALUES ('123', 'NameExample', 'DescriptionExample', '50', '1324')
UPDATE
When updating line items, you can change non readOnly field by specifying the line item Id. For example:
UPDATE LineItems SET Name = 'UpdatedName', Description = 'Updated description', Price = 123 WHERE id = '123'
DELETE
You can delete line items singularly by Id, or in batches. For example:
DELETE FROM LineItems WHERE Id = 123 DELETE FROM LineItems WHERE Id IN ( '123', '234')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Unique internal identifier assigned to the line item. | |
| Name | String | False |
Name of the product associated with this line item. | |
| Price | String | False |
Price of the line item. This is typically the price per unit before discounts. | |
| Quantity | String | False |
Quantity of the product specified in the line item. | |
| Description | String | False |
Detailed description of the product or service in the line item. | |
| ProductId | String | False |
Object ID of the associated product. Required when creating a new line item to specify the product being sold. | |
| Version | Integer | True |
Current version number of the line item, incremented with each update. | |
| IsDeleted | Boolean | True |
Boolean flag indicating whether the line item has been deleted. Deleted records are excluded by default. |
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 |
Optional parameter to include deleted line items in the query results. Set this to true to return deleted records when selecting by ID. |