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