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

Why I Think Python Is the Perfect Programming Language for Beginners

30 Days of Code — Day 4

[Leetcode 283]Move Zeros

Why We Serve: Jordan Ginn

Deploying Istio in Kubernetes to protect APIs using JWT verification

Vector graphic of a golden key

Deploy Serverless Golang Functions with Netlify

40 New Workers Go Live on the VideoCoin Network

AWS RDS (Relational Database Service) With WordPress..

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

Day 3.2 Deep Dive 6 Phases of data analysis

How to Plan to Migrate Azure Synapse Analytics | Saxon

Snowflake — Introduction to Architecture, Caching, Clustering and Virtual Warehouse.

Get S3 Locations of Hive tables from Hive Metastore