Photo by Sigmund on Unsplash

Sending Emails from EPM

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.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Arun Raj

Arun Raj

108 Followers

Manager (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)