Standard REST API To Run a BI Report(ERP Cloud/Common)

User_Z4C9F

Organization Name

CherryRoad

Description

Standard API Call to perform below tasks: 

Run report

Get report definition
Get report parameters
Get report sample data
Get report template
Get report template parameters
Get XDO schema

 

Use Case and Business Need

For our client they require the report data to be sent via REST. 

Business flow affected: Most clients requires REST API to extract the data of a report

Benefit : Client/Customer satisfaction. 

More details

Current product is very limited option and has no additional features.

Standard API Call to perform below tasks(not available in SaaS): 

Run report

Get report definition
Get report parameters
Get report sample data
Get report template
Get report template parameters
Get XDO schema

Original Idea Number: 4d057906da

Sreekanth Mukalla

Hi Sivakumar,

I don't think the REST APIs are available yet.

However, you can use the SOAP - ReportService as a workaround for achieving similar functionality.

Best Regards,

Sreekanth Mukalla

User_Z4C9F

Thanks Sreekanth ! At present, we are already using the workaround, but for most of the modern applications and integrations client prefers REST APIs than the SOAP. 

Regards, 

Sivakumar

User_LAS3X

Hi,

This could be really usefull to us too.

We have some report that generates Excel File or PDF.

But we want archive them as CSV file (through eText).

ErpIntegrationService only provides a way to get the default template (in our case PDF / Excel), while we want to be able to submit them with the CSV output.

We are unable to do so at the moment.

Regards,

Maxime

Varun Jain-Oracle

Currently, ERP Integration Service downloadEssJobExecutionDetails Operation supports only 3 formats -- CSV, XML, TXT as these formats are primarily used for integration purposes.

https://docs.oracle.com/middleware/bi12214/bip/BIPAP/send-requests.html