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 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

Name Type ReadOnly References Filterable Description
ContactsId [KEY] Long False

Contacts.Id

False

Contacts ID

DealsId [KEY] Long False

Deals.Id

False

Deals ID

TypeId [KEY] String False

AssociationsLabels.TypeId

False

The numeric ID for the association type. This column is empty for more general associations queries.

Category [KEY] String False

AssociationsLabels.Category

False

The category of the association type for the specified object pair. This column is empty for more generic associations queries.

TypeLabel String True

AssociationsLabels.Label

False

The label assigned to the association type between objects.

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