Power BI Connector for HubSpot

Build 26.0.9770

TaskAssociations

Returns object IDs associated with specific tasks, supporting task-related CRM associations.

Table-Specific Information

SELECT

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

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

SELECT * FROM ContactAssociations WHERE Type = 'Tasks'

Columns

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

Unique identifier for the task association record.

AssociationId [KEY] Long False False

Identifier of the object associated with this task, such as a contact, deal, or ticket.

Type [KEY] String False False

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

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