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 add-in 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 add-in 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. |