[SalesForce] How to query for email addresses listed under Email-To-Case routing addresses

Use Case
I am replacing the standard Email publisher action on case with a custom VF page using the apex:emailPubilsher tag. For certain cases, we need to be able to include an extra "From" address as an option.

Problem
The problem is when you specify the "fromAddresses" option in the emailPublisher tag, it replaces the entire list with what is supplied. I don't want to replace the list, just append a value to it.

TLDR
I am looking for a way to query for the email addresses listed under the Routing Address section of the Email-To-Case Settings page. Specifically those listed as Email2Case.

What I've tried
I know the OrgWideEmailAddress object is not what I'm looking for here. I did find a CaseSettings description but it doesn't seem like I can access that from within SFDC.

Any help would be appreciated. Thanks!

Best Answer

You can query the case-to-email address using the EmailServicesAddress object.

SELECT Id,AuthorizedSenders,EmailDomainName,IsActive,LocalPart FROM EmailServicesAddress

The LocalPart plus the EmailDomainName make up the routing email address.

Reference:

Salesforce SOAP API Developer Guide: EmailServicesAddress

Process builder!

I wasn't sure if this would work, but sure enough...

As of Spring '15 you can use the Process Builder for cool stuff like this.
Setup > Create > Workflow & Approvals > Process Builder

Previously this would have had to be done using APEX. I believe you would have to do something similar to what's being shown below in the Process Builder - create a new Task (not update the automatic one) since there's no real link between the EmailMessage record and the Task created from it.

Make sure you turn off the automatic Task creation for this routing address in the Email2Case settings or you'll get a duplicate.

Basically, when an Email Message comes in where IsInbound = True, create a task, relate it to the Case, set the Type, etc....

Here's an example

good luck!

quick note:
I had a problem the first time I tried this where the email bounced back to the sender with an ugly error. This is because Cases in my org are owned by a Queue and I tried to set Assigned To ID to the Case Owner. Since it wasn't a User, it wouldn't work. You can specify any User such as the Account.Owner. I used EmailMessage.CreatedBy. That just uses the automated workflow user I think.

"Unhandled process fault" 
caused by element : FlowRecordCreate.myRule_1_A1
caused by: UPSERT --- UPSERT FAILED --- ERRORS : (FIELD_INTEGRITY_EXCEPTION)     
Assigned To ID: id value of incorrect type: 00G30000002SjhQEAS --- for SFDC record with ID : null,

Name ID on the Activity might be problematic as well. You could use the parent Case's Contact field but that might either not be set, or could be someone different than the actual sender.

Make sure whatever you do that no Process Builder, Workflow, Validation, APEX errors will prevent emails from being processed.

Best Answer

Related Solutions

[SalesForce] Remove available “from” addresses on “send an email” page

[SalesForce] Email-to-Case: Create Activity from Email – how to populate Comments with Email Body

Process builder!

Related Topic