Power BI Connector for Salesforce

Build 26.0.9770

MessagingChannel

Represents a messaging channel, such as WhatsApp or SMS, configured for customer conversations.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

DeveloperName String False

The unique name used by the API and managed packages.

Language String False

Language of the record or user interface.

MasterLabel String False

The custom object label that appears in the user interface.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

Description String False

Text description of the record.

ChannelAddressIdentifier String True

Field containing ChannelAddressIdentifier information.

MessageType String False

Type classification for Message.

MessagingPlatformKey String False

Field containing MessagingPlatformKey information.

IsoCountryCode String False

Indicates whether the record has the oCountryCode characteristic.

PlatformType String False

Type classification for Platform.

IsActive Bool False

Indicates whether the record is active.

RoutingType String False

Type classification for Routing.

TargetQueueId String False

Group.Id

ID of the TargetQueue associated with this record.

SessionHandlerId String False

ID of the SessionHandler associated with this record.

FallbackQueueId String False

Group.Id

ID of the FallbackQueue associated with this record.

ConsentType String False

Type classification for Consent.

OptInPrompt String False

Field containing OptInPrompt information.

DoubleOptInPrompt String False

Field containing DoubleOptInPrompt information.

IsRequireDoubleOptIn Bool False

Indicates whether the record has the RequireDoubleOptIn characteristic.

DefaultResponse String False

Default response message sent on this messaging channel.

InitialResponse String False

Field containing InitialResponse information.

EngagedResponse String False

Field containing EngagedResponse information.

ConversationEndResponse String False

Field containing ConversationEndResponse information.

OfflineAgentsResponse String False

Field containing OfflineAgentsResponse information.

OutsideBusinessHoursResponse String False

Field containing OutsideBusinessHoursResponse information.

BusinessHoursId String False

BusinessHours.Id

ID of the business hours associated with this record.

IsRestrictedToBusinessHours Bool False

Indicates whether the record has the RestrictedToBusinessHours characteristic.

LinkingPreference String False

Field containing LinkingPreference information.

IsLinkedRecordOpenedAsSubTab Bool False

Indicates whether the record has the LinkedRecordOpenedAsSubTab characteristic.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record 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
SessionHandlerIdType String

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

SessionHandlerIdExternalFieldName String

Specifies the external field name of the 'SessionHandlerId' 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