Schedule a Webi Report, to be emailed to a user

[Former Member]

Hi everyone,

After a huge amount of effort, I managed to get my C# application to schedule Webi Reports, passing it parameters, and writing the resulting .pdf or Excel file to an external file.

But, my next task:  how do I get the REST SDK to schedule a report, but email the results to a user ?

I can't find an example of how to do this anywhere.

For example, here's the XML I send to the REST service to schedule a report, and write it to an external file.

I want to change this to email the file directly to a user...  but can't find any examples of what XML is needed.

One other thing: to get my scheduling code to work would've been impossible until I found an .xsd file on the SAP site showing the required order of the XML elements which was required.  Get the order wrong, and the scheduling web service would throw an exception (but give no idea how to fix it).

The problem is... I can't find this .xsd file anymore on the SAP website.

Can someone tell me where I can find the .xsd file, showing the required order of XML elements needed when calling the scheduling REST web service ?  

Mike

[eric_festinger · Accepted solution]

hello Mike,

The destination should look like:

    <destination>

        <mail>

            <from>somebody@company.com</from>

            <to>person1@company.com;person2@company.com</to>

            <cc>somebody_in_copy@company.com</cc>

            <bcc>list_of_people_in_blind_copy.company.com</bcc>

            <subject>Web Intelligence Restful WS</subject>

            <message>Text to send</message>

            <addAttachment>true</addAttachment>

        </mail>

    </destination>

I got this from the 4.2 SP3 documentation.

Regards,

eric

[Former Member · Accepted solution]

Brilliant - many thanks !

Can I ask though - which SP3 documentation did you find this in ?

I read the "Business Intelligence Platform RESTful Web Service Developer Guide" document, and it doesn't even mention it.

sbo42sp3_bip_rest_ws_en.pdf

But yes, with the XML attributes you suggested, this worked straightaway.  Many thanks.

[eric_festinger · Accepted solution]

You're welcome!

"Business Intelligence Platform RESTful Web Service Developer Guide" relates to the platform common services, whereas the "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer" is specific to Web Intelligence and Semantic Layer.

eric