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

Table Specific Information

SELECT

The SubscriptionAssociations table provides access to the relationship data between subscription records and other HubSpot objects.

A query to this table returns the Ids of records and the corresponding object types.

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 the fully qualified object type name.

INSERT

To add an association between a subscription record and a contact record, specify the subscription Id, the contact Id, and the object type.

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

Columns

Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False	Subscriptions.Id	False	Subscriptions ID
AssociationId [KEY]	Long	False		False	ID of the object that this Subscriptions object is associated with.
Type [KEY]	String	False		False	Type of the associated object, which can be a contact, deal etc.