Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications.

View Specific Information

This is a sample associations table exposed when the ExpandAssociations connection property is set to True.

SELECT

A query to this table will return all the Id pairs of the associated records from the two object types, Contacts and Deals.

SELECT * FROM ContactsToDealsAssociations

INSERT

To add a new default association between a Contacts record and a Deals record, specify the Ids of the two records to be associated.

INSERT INTO ContactsToDealsAssociations (ContactsId, DealsId) VALUES ('3432', '34654')

To add a new custom association between a Contacts record and a Deals record, you will need to also specify the TypeId and Category of the association.

INSERT INTO ContactsToDealsAssociations (ContactsId, DealsId, TypeId, Category) VALUES ('3432', '34654', '1', 'USER_DEFINED')

DELETE

To delete an existing association between a Contacts record and a Deals one, specify the Ids of the two associated records.

DELETE [ContactsToDealsAssociations] WHERE ContactsId = '3432' AND DealsId = '34654'

To delete an existing custom association between a Contacts record and a Deals record, you will need to also specify the TypeId and Category of the association.

DELETE ContactsToDealsAssociations WHERE ContactsId = '3432' AND DealsId = '34654' AND TypeId = '1' AND Category = 'USER_DEFINED'

Columns