Can I make a select to obtain information from these emails (activities) from Einstein Activity Capture or just using "view full email"?

enter image description here

2 Answers 2


You can query the EmailMessage object to see the details of the outbound communication.

SELECT FromAddress, Status, Subject, TextBody, ToAddress FROM EmailMessage

I suggest you modify the field list to capture the data points you need from the object but more importantly, add a filter to this SOQL as the table for this object can grow exponentially. RelatedToId is a candidate for filtering.

  • I appreciate your reply but EmailMessage did not serve what I need and it was my fault for not adding this detail. Sending is being done through Einstein Activity Capture and EmailMessage does not keep this. May 7, 2021 at 17:48

Now, I haven't verified it, but you should be able to use the Tableau CRM REST API to query, with SAQL, the Emails stored in the Activities Tableau CRM Dashboard.

See Salesforce help on the Activity Dashboard included with EAC: Review the Activities Dashboard

See Tableau CRM REST API: Query Resource

A sample POST body response will look like this, per SF Documentation: Example SAQL Response Body (without metadata)

  "results": {
  "query":"q = load \"0Fbxx0000000006CAA/0Fcxx000000001dCAA\";
           q = group q by 'FirstName';
           q = foreach q generate 'FirstName' as 'FirstName', count() as 'count';
           q = limit q 2000;",

Not the answer you're looking for? Browse other questions tagged .