Returns object IDs associated with specific line items in HubSpot, supporting deal line item relationships.

Table-Specific Information

SELECT

The LineitemAssociations table always includes the same set of columns, but some return NULL unless you filter by Id and Type, which allows the connector to retrieve full association details.

To return full details for Line Item associations, filter by both the Line Item Id and the association Type. The Type identifies the associated object (such as a Deal, Company, Contact, or Ticket).

-- Retrieve all fields for associations between a specific Line Item and its related Deals
SELECT *
FROM LineItemAssociations
WHERE Id = '436648510605'   -- LineItem Id
  AND Type = 'Deal';        -- Associated object type

Note: Fetching all fields can cause a reduction in performance, as it requires the connector to make requests for each LineItem.

DELETE

To remove a Line Item association, include both the Line Item Id and the association Type:

-- Delete a LineItem-Deal association
DELETE FROM LineItemAssociations
WHERE Id = '436648510605'   -- LineItem Id
  AND Type = 'Deal';        -- Associated object type

Columns