OIC/Integration/10 → Send e-Mail with attachment

integratio
3 min readAug 28, 2023

--

This is a post on Oracle Integration Cloud highlighting Send Email with attachment feature.

Integration

(1) Flow: [a] Trigger → [b] Configure Notification → [c] Map to Reply → [d] Reply

(2) Flow Description: Here we are creating an App Driven Orchestration flow exposing via REST which can be invoked with email details such as Mail Subject, Mail To etc. along with an file attachment and flow will send the email to the target user with the file attached.

(3) Steps:

Go to OIC console → Integrations → Create an App Driven Integration with your project name.

[a] Trigger:

{
"Param_Body":"Test Body",
"Param_From":"no-reply@oracle.com",
"Param_Subj":"Test Email",
"Param_To":"<your email address>"
}
{
"Result":"Mail Sent !!"
}

[b] Configure Notification:

Mapped to : /nssrcmpr:execute/nsmpr6:request-wrapper/nsmpr6:Param_From

Mapped to source fields:

/nssrcmpr:execute/nsmpr6:request-wrapper/nsmpr6:Param_From

/nssrcmpr:execute/nsmpr6:request-wrapper/nsmpr6:Param_To

/nssrcmpr:execute/nsmpr6:request-wrapper/nsmpr6:Param_Subj

/nssrcmpr:execute/nssrcmpr:attachments/nsmpr4:attachment/nsmpr4:attachmentReference

[c] Map to Reply:

"Test.html"

<table style="background-color:#00FF00">
<tr>
<th>Test Html</th>
<th>Hello !!</th>
</tr>
</table>

………………………………………………………………………………………………

--

--

integratio

📌 IT Backend enthusiast 📌 Blogging about Oracle FMW, Python, Cloud related technologies 📌 Non monetized, non hustle 📌 Knowledge sharing sole purpose