ADO.NET Provider for HubSpot

Build 21.0.8137

CustomObjectAssociations

Retrieve and manage associations between Custom object types in HubSpot. This table supports both OAuth and APIKey authentications.

View Specific Information

Note: Insert and Delete operations may not work for the OAuth Authentication scheme due to insufficient OAuth Apps scopes, use the API Key authentication instead.

Select

A query to this table will return all the available associations for each custom object type.

SELECT * FROM CustomObjectAssociations

Insert

To add a new association between a custom object type and another object type (custom or standard object type), the user must specify at least the ObjectFullyQualifiedName for the source custom object and the Object Type Id-s of the two objects to be associated, ToObjectTypeId and FromObjectTypeId.

INSERT INTO [CustomObjectAssociations] (ObjectFullyQualifiedName, Name, FromObjectTypeId, ToObjectTypeId, Cardinality, InverseCardinality) 
VALUES('p5692228_MachinesObject', 'machine_to_contactAssoc', '2-1128325', 'contact', 'ONE_TO_MANY', 'ONE_TO_MANY')

Delete

To delete an association for a custom object, you will need to specify the ObjectFullyQualifiedName and the AssociationId.

DELETE [CustomObjectAssociations] WHERE Id='330' AND ObjectFullyQualifiedName='p5692228_MachinesObject'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] String True False

A unique ID for this association.

ObjectFullyQualifiedName [KEY] String False False

A unique ID for this schema's object type. It is defined as {meta-type}-{unique ID}.

ObjectTypeId String True False

The ID of the custom object type.

ObjectId String True False

An assigned unique ID for the object, including portal ID and object name.

ObjectName String True False

A unique name for the schema's object type.

ObjectLabelSingular String True False

Singular label for the object. Used in CRM display.

ObjectLabelPlural String True False

Plural label for the object. Used in CRM display.

Name String False False

A unique name for this association.

Cardinality String False False

The cardinality type.

InverseCardinality String False False

The inverseCardinality type.

FromObjectTypeId String False False

ID of the primary object type to link from.

ToObjectTypeId String False False

ID of the target object type ID to link to.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137