Power BI Connector for Salesforce

Build 26.0.9770

ConversationParticipant

Represents a participant, such as a customer or agent, involved in a conversation.

Columns

Name Type References Description
Id [KEY] String Unique identifier for the record.
Name String Name of the record.
IsDeleted Bool Indicates whether the record has been moved to the Recycle Bin.
CreatedById String

User.Id

ID of the user who created the record.
LastModifiedDate Datetime Date and time when the record was last modified.
LastModifiedById String

User.Id

ID of the user who last modified the record.
ConversationId String

Conversation.Id

ID of the Conversation associated with this record.
AppType String Type classification for App.
JoinedTime Datetime Field containing JoinedTime information.
JoinedTimeMilliSecs Int Time the participant joined the conversation, in milliseconds.
ParticipantEntityId String ID of the ParticipantEntity associated with this record.
ParticipantKey String Field containing ParticipantKey information.
ParticipantRole String Field containing ParticipantRole information.
ParticipantContext String Field containing ParticipantContext information.
ParticipantDisplayName String Field containing ParticipantDisplayName information.
LeftTime Datetime Field containing LeftTime information.
LeftTimeMilliSecs Int Time the participant left the conversation, in milliseconds.
LastActiveTime Datetime Field containing LastActiveTime information.
LastActiveTimeMilliSecs Int Time the participant was last active in the conversation, in milliseconds.
CreatedDate Datetime Date and time when the record was created.

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
ParticipantEntityIdType String Specifies the type of the 'ParticipantEntityId' polymorphic field to use in the statement.
ParticipantEntityIdExternalFieldName String Specifies the external field name of the 'ParticipantEntityId' 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