Distributing OTBI reports with HTML email body via SOAP

Zachary Gurevich 726

I am trying to schedule an OTBI report to be created and then sent via email. I want to include a hyperlink in the email body to a document.

I am trying to accomplish this programmatically by hitting a SOAP endpoint at:

https://{pod name}.oraclecloud.com/xmlpserver/services/v2/ScheduleService?WSDL

I am providing an XML payload specifying which job I want scheduled and various email details. I can trigger the job and get it to send via email. However, when I try inserting html code as the value for the “emailBody” I get emails that are blank (I am using html as I do not know of any other to make a hyperlink).

Example XML code:  …<v2:emailBody><![CDATA[ <a href='www.example.com'> my document </a> ]]></v2:emailBody>…

I have tried manually entering that html code directly into the message box on the OTBI site and it sends the correctly hyperlinked text in the email body.

If putting html code in the body of the email via SOAP is not an option, is there a way to specify an attachment in the same payload to get not only the report attached to the email, but also the other document? Any advice or clarification would be greatly appreciated.

WSDL snippet with email options:

<complexType name="EMailDeliveryOption">
  <sequence>
    <element name="emailAttachmentName" nillable="true" type="xsd:string"/>
    <element name="emailBCC" nillable="true" type="xsd:string"/>
    <element name="emailBody" nillable="true" type="xsd:string"/>
    <element name="emailCC" nillable="true" type="xsd:string"/>
    <element name="emailFrom" nillable="true" type="xsd:string"/>
    <element name="emailReplyTo" nillable="true" type="xsd:string"/>
    <element name="emailServerName" nillable="true" type="xsd:string"/>
    <element name="emailSubject" nillable="true" type="xsd:string"/>
    <element name="emailTo" nillable="true" type="xsd:string"/>
    <element name="emailDeliveryStatusNotification" type="xsd:boolean" minOccurs="0"/>
    <element name="emailReturnReceipt" type="xsd:boolean" minOccurs="0"/>
  </sequence>
</complexType>