Cmdlets for HubSpot

Build 24.0.9032

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9032