Oracle Communities

Oracle Analytics and AI

Child Item

API for Automating the OTBI Report download

Hello Experts,

I have a data model and a report created from that data model. I need to automate the report download through an API call. Later, I need to run a Python script for post-processing.

Can anyone please share an API endpoint that I can use for this purpose?

Thanks,

Sam,

Find more posts tagged with

Accepted answers

ravikiran goda-Oracle

HI @Sam Bandara

You can use below method from Catalog service

downloadObjectInSession() Method

Use downloadObjectInSession() method to download an object from the BI Publisher catalog for a given user.

Kurasaki-Oracle

absolute path from schedule.jpg

You can get the path of bip report from "Schedule Report Job" screen as well.
For example, the path is like "/Custom/kurasaki/per_users_rp.xdo".

Kurasaki-Oracle

absolute path from schedule.jpg

@Sam Bandara

You can get the path of bip report from "Schedule Report Job" screen.
For example, the path is like "/Custom/kurasaki/per_users_rp.xdo".

All comments

Kurasaki-Oracle

Hello
I recommend you check the followings.

Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)
How To Schedule BI Publisher Report And Download Output Via Web Service? (Doc ID 2543601.1)

Regards,
Kentaro

Sam Bandara

https://community.oracle.com/products/oracleanalytics/discussion/comment/65947#Comment_65947

Thanks mate, I cannot open the doc (I don't have access unfortunately). I would appreciate it if you could download and attach those two documents.

Cheers,

Kurasaki-Oracle

How about the doc number KB151330 / KB7075 ?
Please login to My Oracle Support and search above Doc number.

Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (KB151330)
How To Schedule BI Publisher Report And Download Output Via Web Service? (KB7075)

Search_on_MOS.png

For the record, the following is the manual for BIP SOAP API.
Fusion Middleware Developer's Guide for Oracle Business Intelligence Publisher
https://docs.oracle.com/middleware/12213/bip/BIPDV/toc.htm

APIs in the above manual could be used both for BIP in OTBI(Fusion Applications) and On-Premise BI Publisher.

Specific to Fusion Application integration, Oracle have developed following webservices other than above APIs. PublicReportWSSService, ScheduleReportWSSService, ExternalReportWSSService.

The details are described in KB151330.

ravikiran goda-Oracle

HI @Sam Bandara

You can use below method from Catalog service

downloadObjectInSession() Method

Use downloadObjectInSession() method to download an object from the BI Publisher catalog for a given user.

Sam Bandara

https://community.oracle.com/products/oracleanalytics/discussion/comment/65951#Comment_65951

Thanks Ravikiran,

One more question.

How do I find the absolute report path?

I tried with this path, "/users/samxxxa@xxxx.com/Reports/All_item_attributes_report.xdo"

But got the following error:

PublicReportService::executeDownloadReport Failure: Unable to download Report for [/users/samxxx@xxxxx.com/Reports/All_item_attributes_report.xdo] Due to unable to find ReportObject

ravikiran goda-Oracle

@Sam Bandara

Go to report properties and copy the report location from there.

Kurasaki-Oracle

absolute path from schedule.jpg

You can get the path of bip report from "Schedule Report Job" screen as well.
For example, the path is like "/Custom/kurasaki/per_users_rp.xdo".

Sam Bandara

@ravikiran goda-Oracle Hi,

This is the path in the properties

I used the same path and am still getting the same error.

Kurasaki-Oracle

absolute path from schedule.jpg

@Sam Bandara

You can get the path of bip report from "Schedule Report Job" screen.
For example, the path is like "/Custom/kurasaki/per_users_rp.xdo".

Sam Bandara

https://community.oracle.com/products/oracleanalytics/discussion/comment/66002#Comment_66002

Thanks, Mate, it worked