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.

--

--

--

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

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

EPIC Values: My Thoughts on them

CryptoTips Treasure Hunt: Puzzle 02— Solved

Advanced string templates in Mendix with {{ Handlebars.java }}

Drawing Die Faces with SwiftUI-Part 3

My Engineering Daybook: How not to Default

NetShop ISP Announces the Availability of IT-as-a-Service (ITaaS) Solution

Vault Part 8 - Vault Authorization: Policy Path Templating

ApsaraDB for HBase Publishes Full-Text Indexing Service to Handle Complex Queries

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

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

More from Medium

How Can Russian Films with English Subtitles Help You Learn to Speak Russian?

Continuation of Postgress Sql

One Ring to Track Them All

One Ring to Track Them All

AHM Backlink Data Index 92