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 server 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 server 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. |