Power BI Connector for HubSpot

Build 26.0.9770

NoteAssociations

Lists object IDs associated with specific notes, supporting associations of notes to other CRM objects.

Table-Specific Information

SELECT

Note: You cannot reference custom objects by base name. When querying NoteAssociations, 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 NoteAssociations WHERE Type = 'Contact'

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

SELECT * FROM ContactAssociations WHERE Type = 'Note'

Columns

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

Unique identifier of the note record.

AssociationId [KEY] Long False False

Unique identifier of the object associated with this note, such as a contact, deal, or company.

Type [KEY] String False False

Type of the object associated with the note, such as contact, deal, or company.

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