CustomObjectAssociations
Retrieve and manage associations between Custom object types in HubSpot.
View Specific Information
Note: Insert and Delete operations may not work for the OAuth Authentication scheme because of insufficient OAuth Apps scopes. Use the Private App Token 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. |