Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

EmailMessage

The Email Message DMO is a Data Cloud data model object (DMO) for an email message, usually text, but possibly HTML, including attachments sent or received over the network.

Columns

Name Type References Description
Case Id Varchar A reference ID to the associated case.
Channel Engagement Number Varchar The channel engagement number for the email messagel.
Country Region Varchar The country or region for the email message.
Created By Varchar A reference ID to the user who created the record.
Created Date Datetime The date the record was created.
Created Date Time Datetime The time the record was created.
Data Source Varchar A reference ID for the logical name for a system that is the source of records identified by external record ID.
Data Source Object Varchar A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object.
Email Header Varchar The header text for the email message.
Email Message Varchar The message text for the email message.
Email Message Id Varchar A unique ID used as the primary key for the email message DMO.
Email Status Varchar The status of the email message.
Email Subject Varchar The subject text for the email message.
Email Thread Varchar A reference ID to the email thread the message is associated with.
Engagement Channel Type Varchar The engagement channel type for the email message.
External BCC Email Address List Varchar The external BCC email address list for the email message.
First Open Date Datetime The date the message was first opened.
From Address Varchar The from address of the email message.
From Name Varchar The from name of the email message.
HasRelatedDocument Varchar An indicator if the email message has a related document.
HTML Body Varchar The HTML body text for the email message.
Internal BCC Email Address List Varchar The internal BCC email address list for the email message.
Internal CC Email Address List Varchar The internal CC email address list for the email message.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the email message.
Is Bounced Varchar An indicator if the email message has bounced.
Is Incoming Varchar An indicator if the email message is an incoming message.
Is Opened Varchar An indicator if the email message has been opened.
Is Private Draft Varchar An indicator if the email message is a private draft.
Is Tracked Varchar An indicator if the email message is tracked.
Last Modified By Varchar A reference ID to the user that made the last update.
Last Modified Date Datetime The date when a user last modified the record.
Lastest Open Date Datetime The date the message was opened last.
Market Journey Activity Varchar The market journey activity for the email message.
Message Date Datetime The date the email message was sent.
Message Purpose Varchar The purpose for the email message.
Name Varchar The name of the case.
Related To Varchar A reference ID to the related item for the email message.
Related To Object Varchar The related object for the message.
Reply To Address Varchar The reply to address for the email message.
Reply To Email Message Varchar A reference ID to the reply to message for the email message.
Software Application Varchar The software application for the email message.
Subject Varchar The subject for the email message.
To Email Address List Varchar The to email address list for the email message.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175