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 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	False		True	Unique identifier of the object.
Archived	Bool	True		True	Whether the object is archived or not.
CreatedAt	Datetime	True		False	When the object was created.
UpdatedAt	Datetime	True		False	When the object was last updated.
Net price	Decimal	True		False	The amount of a line item.
Create Date	Datetime	False		False	The date the line item was created.
Description	String	False		False	Full description of product.
Unit discount	Decimal	False		False	The discount amount applied.
Annual contract value	Decimal	True		False	The annual contract value _ACV_ of this product.
All accessible team IDs	String	True		False	The team IDs_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom.
Business units	String	False		False	The business units this record is assigned to.
All owner ids	String	True		False	The value of all owner referencing properties for this object_ both default and custom.
All team ids	String	True		False	The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Allow buyer selected quantity	String	True		False	Whether buyer selected quantity is to be enabled or not for a LineItem.
Annual recurring revenue	Decimal	True		False	The annual recurring revenue _ARR_ of this product.
Delayed billing start by days	Decimal	False		False	Number of days billing should be delayed by. It allows the customers to start billing sometime in the future.
Delayed billing start by months	Decimal	False		False	Number of months billing should be delayed by. It allows the customers to start billing sometime in the future.
Start billing terms	String	True		False	The type of billing start delay. It can be a fixed date in the future_ relative delay in number of days or months.
Unit cost	Decimal	False		False	The amount that sold goods cost the HubSpot customer.
Created by user ID	Decimal	True		False	The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time	Datetime	True		False	The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Discount Percentage	Decimal	False		False	The discount percentage applied.
External LineItem id	Decimal	True		False	The ID of a line item.
Image URL	String	False		False	Product images.
Last Modified Date	Datetime	True		False	The date any property on this product was modified.
Currency	String	False		False	Currency code for the line item.
Margin	Decimal	True		False	The margin value of this product.
Annual contract value margin	Decimal	True		False	The margin annual contract value of this product.
Annual recurring revenue margin	Decimal	True		False	The margin annual recurring revenue of this product.
Monthly recurring revenue margin	Decimal	True		False	The margin monthly recurring revenue of this product.
Total contract value margin	Decimal	True		False	The margin total contract value of this product.
Merged object IDs	String	True		False	The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Monthly recurring revenue	Decimal	True		False	The monthly recurring revenue _MRR_ of this product.
Record ID	Decimal	True		False	The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Position on quote	Decimal	False		False	The order which the line item appears on the quotes.
Pre Discount Amount	Decimal	True		False	The pre_discount amount of a line item.
Product ID	Decimal	False		False	ID of the product this was copied from.
Read Only Object	Bool	True		False	Is the object read only.
End Date	Date	True		False	Recurring billing end date for a line item.
Number of payments	Decimal	True		False	Number of payments for the given period on a Line Item.
Term	String	False		False	Product recurring billing duration.
Billing start date	Date	False		False	Recurring billing start date for a line item.
Billing terms	String	True		False	If there are fixed number payments or it goes on until cancelled.
SKU	String	False		False	Unique product identifier.
Sync amount	Decimal	True		False	The amount set by Ecommerce sync.
Total contract value	Decimal	True		False	The total contract value _TCV_ of this product.
Term in months	Decimal	True		False	The number of months in the term of this product.
Calculated Total Discount	Decimal	True		False	Calculated total Discount for the line item taking in consideration the flat amount and discount percentage.
Unique creation key	String	True		False	Unique property used for idempotent creates.
Updated by user ID	Decimal	True		False	The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
URL	String	False		False	Product url.
User IDs of all notification followers	String	True		False	The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications
User IDs of all notification unfollowers	String	True		False	The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications
User IDs of all owners	String	True		False	The user IDs of all owners of this object.
Variant id of the product	Decimal	True		False	Varient id of the shopify product.
Owner Assigned Date	Datetime	True		False	The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner	String	False		False	The owner of the object.
HubSpot Team	String	True		False	The primary team of the owner.
Name	String	False		False	Product name.
Unit price	Decimal	False		False	Cost of product.
Quantity	Decimal	False		False	How many units of a product are in this line item.
Billing frequency	String	False		False	How often a line item with recurring billing is billed. It informs the pricing calculation for deals and quotes. Line items with one_time billing aren_t included.
Tax	Decimal	False		False	The tax amount applied.