Power BI Connector for Salesforce

Build 26.0.9770

CaseTeamRole

Defines roles assigned to team members working on case records, such as Support Rep or Manager.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the case team role record.

Name String False

Name of the role assigned to members of the case team.

AccessLevel String False

The level of access granted to team members with this role, such as Read or Read/Write.

PreferencesVisibleInCSP Bool False

Indicates whether this role is visible in the Customer Portal (true) or hidden (false).

CreatedDate Datetime True

Date and time when the case team role was created.

CreatedById String True

User.Id

ID of the user who created the case team role.

LastModifiedById String True

User.Id

ID of the user who last modified the case team role.

SystemModstamp Datetime True

Timestamp of the most recent system update to the case team role.

LastModifiedDate Datetime True

Date and time when the case team role was last modified.

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
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