Lineitems

Lists all line item records in HubSpot, supporting both OAuth and private-app token authentications.

Table Specific Information

In HubSpot, line items can be thought of as a subset of products. When a product is attached to a deal, it becomes a line item. You can create line items that are unique to an individual quote, but they will not be added to your product library.

SELECT

When selecting line items, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =.

SELECT * FROM LineItems WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM LineItems WHERE Archived = TRUE;

INSERT

INSERT INTO LineItems (Description, [Product ID]) VALUES ('description', '33318601')

UPDATE

UPDATE LineItems SET Description = 'new description' WHERE ID = '168209183'

DELETE

DELETE FROM Deals WHERE ID = '168209183'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	True		True	Unique identifier of the line item record.
Archived	Bool	True		False	Indicates whether the line item has been archived.
CreatedAt	Datetime	True		False	Timestamp when the line item was created.
UpdatedAt	Datetime	True		False	Timestamp of the most recent update to the line item.
Net price	Decimal	True		True	The net amount for the line item after discounts, excluding taxes and fees.
Create Date	Datetime	False		True	The original creation date of the line item record.
Description	String	False		True	Detailed description of the product associated with the line item.
Unit discount	Decimal	False		True	Flat discount amount applied to a single unit of the line item.
Annual contract value	Decimal	True		True	The annual contract value (ACV) of the product in the line item.
All accessible team IDs	String	True		False	Team IDs, including hierarchical relationships, that have access to this line item record.
Business units	String	False		False	Business units associated with this line item.
All owner ids	String	True		False	User IDs for all owners assigned to this line item, including default and custom properties.
All team ids	String	True		False	Team IDs corresponding to owner properties for this line item.
Allow buyer selected quantity	String	True		True	Specifies whether the buyer can select the quantity of the line item during checkout.
Annual recurring revenue	Decimal	True		True	The annual recurring revenue (ARR) generated by this product.
Delayed billing start by days	Decimal	False		True	Number of days to delay the billing start date from the deal close date.
Delayed billing start by months	Decimal	False		True	Number of months to delay the billing start date from the deal close date.
Start billing terms	String	True		False	Type of billing delay, such as fixed start date or relative delay in days or months.
Unit cost	Decimal	False		True	Internal cost of the product being sold, used to calculate margin.
Created by user ID	Decimal	True		True	User ID of the creator of the line item. Automatically set by HubSpot.
Object create date_time	Datetime	True		True	Date and time when the line item object was created. Automatically set by HubSpot.
Discount Percentage	Decimal	False		True	Percentage discount applied to the line item.
External LineItem id	Decimal	True		True	External system identifier for the line item.
Image URL	String	False		True	URL of the image representing the product in this line item.
Last Modified Date	Datetime	True		True	Timestamp when any property on the line item was last modified.
Currency	String	False		False	Currency code used for the line item.
Margin	Decimal	True		True	The profit margin calculated from unit price and unit cost.
Annual contract value margin	Decimal	True		True	Profit margin calculated using the annual contract value.
Annual recurring revenue margin	Decimal	True		True	Profit margin calculated using the annual recurring revenue.
Monthly recurring revenue margin	Decimal	True		True	Profit margin calculated using the monthly recurring revenue.
Total contract value margin	Decimal	True		True	Profit margin calculated using the total contract value.
Merged object IDs	String	True		False	List of object IDs that have been merged into this line item record. Automatically set by HubSpot.
Monthly recurring revenue	Decimal	True		True	The monthly recurring revenue (MRR) generated by the product in this line item.
Record ID	Decimal	True		True	Unique identifier for this line item record. Automatically set by HubSpot.
Position on quote	Decimal	False		True	The display order of this line item on the quote document.
Pre Discount Amount	Decimal	True		True	The original amount of the line item before any discounts were applied.
Product ID	Decimal	False		True	Identifier of the product this line item is based on or associated with.
Read Only Object	Bool	True		True	Indicates whether this line item is read-only and cannot be edited by users.
End Date	Date	True		True	The end date for the line item's recurring billing period.
Number of payments	Decimal	True		True	Number of billing cycles for the recurring line item payment schedule.
Term	String	False		True	The billing term or duration associated with the line item, such as monthly or annual.
Billing start date	Date	False		True	Start date for the line item's billing schedule.
Billing terms	String	True		False	Specifies whether the billing is fixed-term or indefinite (until canceled).
SKU	String	False		True	Stock Keeping Unit identifier for the product in this line item.
Sync amount	Decimal	True		True	Amount synced from an external ecommerce platform for this line item.
Total contract value	Decimal	True		True	The total contract value (TCV) for the product, considering price, quantity, and term.
Term in months	Decimal	True		True	The total number of months in the billing term for this line item.
Calculated Total Discount	Decimal	True		True	Combined discount amount calculated from percentage and flat discounts.
Unique creation key	String	True		True	Custom key used to prevent duplicate line item creation during data sync or import.
Updated by user ID	Decimal	True		True	User ID of the person who last updated the line item. Automatically set by HubSpot.
URL	String	False		True	The URL of the product linked to this line item, if available.
User IDs of all notification followers	String	True		False	IDs of users who opted to receive updates about this line item.
User IDs of all notification unfollowers	String	True		False	IDs of users who opted out of receiving updates about this line item.
User IDs of all owners	String	True		False	IDs of all users who are owners of this line item.
Variant id of the product	Decimal	True		True	Shopify variant ID corresponding to this product if applicable.
Owner Assigned Date	Datetime	True		True	Timestamp when ownership of the line item was last assigned. Automatically set by HubSpot.
Owner	String	False		True	User assigned as the current owner of this line item.
HubSpot Team	String	True		False	Primary team associated with the owner of the line item.
Name	String	False		True	The name of the product shown in this line item.
Unit price	Decimal	False		True	Price per unit of the product in this line item.
Quantity	Decimal	False		True	The number of units for this product in the line item.
Billing frequency	String	False		False	How often this line item is billed, such as monthly or annually.
Tax	Decimal	False		True	Tax amount applied to the line item, if applicable.