Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Fusion: Is there a SOAP Web Service to find Job IDs based on a report's Absolute Path
Hi
I need to download the output PDF of a report that's scheduled daily, but all I have to start with is the name of the report (or the Absolute Path of the XDO file).
Is there an API in the Fusion version of Analytics Publisher that I can use to get the Job ID's of runs of this report? I can't seem to find a link between absolutePath and scheduledJobId in the services offered by /xmlpserver/services/PublicReportWSSService
Best Answer
-
Hi @TyskJohan
If you looking for any addition at Product level, please log an Idea's lab request .
Regards
Arjun
0
Answers
-
Hi @TyskJohan
You can Get the JobId using getAllScheduledReportHistory
How To Schedule BI Publisher Report And Download Output Via Web Service? (Doc ID 2543601.1)
Regards,
Arjun
0 -
HI @Mallikarjuna Kuppauru-Oracle
That Web Service seems to require jobInstanceID
My challenge is that the job is scheduled from the GUI in Fusion (it's actually a job that runs by default), so it is not me scheduling it with a web service call.
All I have is the absolutePath of the report.
0 -
Hi @TyskJohan
I don't think we have an method with only report path As parameter. Can you check below tables From fusion end?
ESS_REQUEST_HISTORY
ESS_REQUEST_PROPERTY
Regards,
Arjun
0 -
I will try that, but not very satisfying as we'll have to hard-code it on the OIC side then.
0 -
Thanks, I created https://community.oracle.com/products/oracleanalytics/discussion/23377/api-to-get-job-ids-based-in-full-path-of-a-report-fusion/p1?new=1
0 -
0