DealAssociations
Lists object IDs associated with specific deals, supporting deal-to-object relationships management.
Table-Specific Information
SELECT
The DealAssociations 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 Deal associations, filter by both the Deal Id and the association Type.
The Type identifies the associated object (such as a Company, Contact, or Ticket).
-- Retrieve all fields for associations between a specific Deal and its Companies
SELECT *
FROM DealAssociations
WHERE Id = '436648510605' -- Deal Id
AND Type = 'Company'; -- Associated object type
Note: Fetching all fields can cause a reduction in performance, as it requires the add-in to make requests for each Deal.
DELETE
To remove a Deal association, include both the Deal Id and the association Type:
-- Delete a Deal-Company association
DELETE FROM DealAssociations
WHERE Id = '436648510605' -- Deal Id
AND Type = 'Company'; -- Associated object type
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | False |
Deals.Id | False |
The unique identifier of the deal involved in the association. |
| AssociationId [KEY] | Long | False | False |
The unique identifier of the object associated with the deal. | |
| Type [KEY] | String | False | False |
The type of object associated with the deal, such as contact, company, or ticket. | |
| TypeId [KEY] | String | False |
AssociationsLabels.TypeId | False |
The numeric identifier representing the specific association type, if available. |
| Category [KEY] | String | False |
AssociationsLabels.Category | False |
The classification of the association type for this object pair, if applicable. |
| TypeLabel | String | True |
AssociationsLabels.Label | False |
The descriptive label assigned to the type of association between the deal and the related object. |