With the release of EPM 21.04 version update you can now send custom emails from EPM using EPM Automate or EPM REST APIs. You can read more about the new release in Mark Rinaldi’s update.
Make sure to upgrade to the latest version of EPM Automate.
Sending Emails using EPM Automate
With EPM automate you can use the “sendMail” command to
- Email one or more recipients
- Include custom Subject and Body
- Include attachments (files from EPM)
Without Attachments
epmautomate login username password url
epmautomate sendMail arun@example.com "Data Load Finished" Body="Data Load Finished at 9 AM EST"
With Attachments
epmautomate login username password url
epmautomate sendMail arun@example.com "Data Load Finished" Body="Data Load Finished at 9 AM EST" Attachments=JanActuals.csv
Multiple Recipients and Multiple Attachments
epmautomate login username password url
epmautomate sendMail arun@example.com;raj@example.com "Data Load Finished" Body="Data Load Finished at 9 AM EST" Attachments=JanActuals.csv,outbox/FebPlan.csv
Make sure to separate the email ids with a semi colon (;).
Sending Emails using EPM REST APIs
You can use the sendmail EPM REST API to send emails from EPM. At the time of writing this blog, the Oracle documentation suggests using the below end point
/interop/rest/security/<api_version>/services/sendmail
However the above is wrong, and you should use the below end point for sending email. Thanks to
/interop/rest/<api_version>/services/sendmail
You can use the below Python code snippet to test the REST API.
If you are using Postman, make sure to select x-www-form-urlencoded for the body section and provide values for to, subject and body. The attachments field is optional.
This is a amazing feature to be included in EPM. Are you excited? Let me know your thoughts.