Fusion: Is there a SOAP Web Service to find Job IDs based on a report's Absolute Path

TyskJohan

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

Mallikarjuna Kuppauru-Oracle

Hi @TyskJohan

If you looking for any addition at Product level, please log an Idea's lab request .

https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

Regards

Arjun

Mallikarjuna Kuppauru-Oracle

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

TyskJohan

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.

Mallikarjuna Kuppauru-Oracle

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

TyskJohan

I will try that, but not very satisfying as we'll have to hard-code it on the OIC side then.

TyskJohan

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

Mallikarjuna Kuppauru-Oracle

Hi @TyskJohan

Yes i got an alert for the same.

Can you mark this thread as Answered.

Regards,

Arjun