Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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,
Best Answers
-
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.
2 -
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".0 -
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".0
Answers
-
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,
Kentaro1 -
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,
0 -
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)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.htmAPIs 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.
1 -
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
0 -
0
-
This is the path in the properties
I used the same path and am still getting the same error.
0 -
Thanks, Mate, it worked
0
