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 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 association between a Contacts record and a Deals one, you simply need to specify the Id-s of the two records to be associated.

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

DELETE

To delete an existing association between a Contacts record and a Deals one, you simply need to specify the Id-s of the two records to be associated.

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

Columns