Retrieve the IDs of all the objects associated to specific Subscriptions objects in HubSpot.

Table Specific Information

SELECT

A query to this table will return the Id-s of all the records and their corresponding object type associated to a specific Subscription record.

SELECT * FROM SubscriptionAssociations

Note: You cannot reference custom objects by base name. When querying SubscriptionAssociations, if Type refers to a custom object, the value must now be either the short-hand object type name (p_<object_name>) or the fully qualified object type name.

INSERT

To add a new association between a Subscription record and a Contact one, you need to specify the Id-s of the two records to be associated and the contact object type.

INSERT INTO SubscriptionAssociations (Id, AssociationId, Type) VALUES ('3432', '34654', 'Contact')

Columns