QuoteAssociations
Returns object IDs associated with specific quotes in HubSpot for managing quote associations.
Table-Specific Information
SELECT
The QuoteAssociations table always includes the same set of columns, but some return NULL unless you filter by Id and Type, which allows the component to retrieve full association details.
To return full details for Quote associations, filter by both the Quote 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 Quote and its related Deals
SELECT *
FROM QuoteAssociations
WHERE Id = '436648510605' -- Quote Id
AND Type = 'Deal'; -- Associated object type
Note: Fetching all fields can cause a reduction in performance, as it requires the component to make requests for each Quote.
DELETE
To remove a Quote association, include both the Quote Id and the association Type:
-- Delete a Quote-Deal association
DELETE FROM QuoteAssociations
WHERE Id = '436648510605' -- Quote Id
AND Type = 'Deal'; -- Associated object type
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | False |
Quotes.Id | False |
Unique identifier for the quote record. |
| AssociationId [KEY] | Long | False | False |
Identifier of the object that this quote is linked or associated with. | |
| Type [KEY] | String | False | False |
Type of the associated object, such as a contact, deal, or ticket. | |
| TypeId [KEY] | String | False |
AssociationsLabels.TypeId | False |
Numeric identifier for the association type. Typically used in specific or advanced association queries; may be empty for general use. |
| Category [KEY] | String | False |
AssociationsLabels.Category | False |
Category describing the nature of the association between the quote and the associated object. This field may be blank for general associations. |
| TypeLabel | String | True |
AssociationsLabels.Label | False |
Human-readable label describing the type of relationship between the quote and the associated object. |