DealAssociations
Manages relationships between deals and associated CRM objects, supporting insertion and deletion of associations.
Table Specific Information
Deal associations represent Company and Contact associations made with existing deals that may be modified.
SELECT
When selecting deal associations, they can only be filtered by the Id. For example:
SELECT * FROM DealAssociations WHERE DealId = 12345
INSERT
New associations may be inserted by specifying the DealId, AssociationId, and the AssociationType during an INSERT statement. For example:
INSERT INTO DealAssociations (DealId, AssociationId, AssociationType) VALUES (12345, 6789, 'COMPANY')
DELETE
Associations may be removed by specifying the DealId, AssociationId, and the AssociationType during a DELETE statement. For example:
DELETE FROM DealAssociations WHERE DealId = 12345 AND AssociationId = 6789 AND AssociationType = 'COMPANY'
Columns
| Name | Type | ReadOnly | References | Description |
| DealId [KEY] | Long | False |
Deals.DealId |
Unique identifier of the deal in HubSpot. |
| AssociatedId [KEY] | Long | False |
Unique identifier of the entity associated with the deal, such as a contact or company. | |
| AssociationType [KEY] | String | False |
Specifies the type of association, for example, 'Company' or 'Contact'. |