Power BI Connector for Salesforce

Build 26.0.9770

TopicAssignment

Links topics to records, allowing users to categorize and filter content using topic tags.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the topic assignment record.

NetworkId String False

Network.Id

ID of the Experience Cloud site associated with this record.

TopicId String False

Topic.Id

Identifier of the topic that is being assigned.

EntityId String False

Identifier of the record (such as a case, account, or custom object) associated with the topic.

EntityKeyPrefix String True

Field containing EntityKeyPrefix information.

EntityType String True

Type classification for Entity.

CreatedById String True

User.Id

Identifier of the user who created the topic assignment.

IsDeleted Bool True

Indicates whether the topic assignment has been deleted from the system.

SystemModstamp Datetime True

System-generated timestamp indicating the most recent change to the topic assignment.

CreatedDate Datetime True

Date and time when the topic was assigned to the record.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
EntityIdType String

Specifies the type of the 'EntityId' polymorphic field to use in the statement.

EntityIdExternalFieldName String

Specifies the external field name of the 'EntityId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

SOQL String

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

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