ContactsToDealsAssociations
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
Name | Type | ReadOnly | References | Filterable | Description |
ContactsId [KEY] | Long | False |
Contacts.Id | False |
Contacts ID |
DealsId [KEY] | Long | False |
Deals.Id | False |
Deals ID |
Type | String | False | False |
Association type between associated objects. |