How to SOQL Email Conversation from EAC [closed]

Question

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

Answer 1

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.

Answer 2

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)

{
  "action":"query",
  "responseId":"3vy-E9YmX-TIWe0769juD-",
  "results": {
    "records":[
      {"FirstName":"","count":1},
      {"FirstName":"Admin","count":1},
      {"FirstName":"Integration","count":1},
      {"FirstName":"Security","count":1}
    ]
  },
  "query":"q = load \"0Fbxx0000000006CAA/0Fcxx000000001dCAA\";
           q = group q by 'FirstName';
           q = foreach q generate 'FirstName' as 'FirstName', count() as 'count';
           q = limit q 2000;",
  "responseTime":544
}