Power BI Connector for HubSpot

Build 26.0.9770

EmailAssociations

Lists object IDs associated with specific email records, enabling email engagement tracking.

Table-Specific Information

SELECT

Note: You cannot reference custom objects by base name. When querying EmailAssociations, if Type refers to a custom object, the value must now be the fully qualified object type name.

This table is not listed by default. Set IncludeCustomTables to True to include it. The Type filter is required, for example:

SELECT * FROM EmailAssociations WHERE Type = 'Contact'

The object-side associations table provides equivalent data, for example:

SELECT * FROM ContactAssociations WHERE Type = 'Email'

Columns

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

Unique identifier for the email engagement record.

AssociationId [KEY] Long False False

ID of the HubSpot object associated with this email, such as a contact, company, or deal.

Type [KEY] String False False

Specifies the type of object associated with the email, such as contact, deal, company, or ticket.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770