Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

API to run custom BI Publisher report

Received Response
25
Views
4
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics Lead
in Oracle Transactional Business Intelligence

Summary:

I need to call report via API

Content (please ensure you mask any confidential information):

I'm performing this API call:

https://xxxxx-test.fa.ocs.oraclecloud.com/xmlpserver/services/rest/v1/reports/Shared Folders/Custom/Human Capital Management/Integrazioni/Job_Report/run

but this is the result:


Any help on this?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Answers

  • Volodymyr Faranosov
    Volodymyr Faranosov Rank 3 - Community Apprentice

    Hi @Stefano_Mazzocca,

    REST APIs are not available for Fusion BI Publisher Reports.

    Please review the document below for the available BIP web services in the Fusion Environment:

    https://docs.oracle.com/cd/E23943_01/bi.1111/e22259/webservices.htm

    Kind regards,

    Volodymyr

  • Volodymyr Faranosov
    Volodymyr Faranosov Rank 3 - Community Apprentice

    Check my blog for details:

    https://erpwebtutor.com/practical-introduction-otbi-bi-publisher-web-services/

  • Stefano_Mazzocca
    Stefano_Mazzocca Rank 6 - Analytics Lead

    Hi @Volodymyr Faranosov , your documents are very interesting but I'm not very familiar with this kind of topic and I didn't recognised where should I enter the path of my report (in my example

    Shared%20Folders/Custom/Human%20Capital%20Management/Integrazioni/Job_Report)

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    Hello @Stefano_Mazzocca

    Thank you for posting about BI Publisher APIs

    Lets start with the right documentation first.
    Here is a great KM article explaining what APIs are supported and available in Fusion SAAS :
    Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)

    There is a whitepaper attached in this document that will show you how you need to use there and where you need to provide the report path.

    Additionally here is a sample for scheduling a report job thati can provide you.

    BI API Name :
    ============
    ScheduleReportWSSService

    BI API WSDL :
    ============
    https://<HostName>/xmlpserver/services/ScheduleReportWSSService?WSDL

    Request to BI Server :
    ==================
    <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:sch="http://xmlns.oracle.com/oxp/service/ScheduleReportService">
    soap:Header/
    soap:Body
    sch:scheduleReport
    <scheduleRequest>
    <reportRequest>
    <reportAbsolutePath>/Custom/Test/TestReport.xdo</reportAbsolutePath>
    </reportRequest></scheduleRequest>
    </sch:scheduleReport>
    </soap:Body>
    </soap:Envelope>

    Response from BI Server:
    =====================
    <env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
    env:Header/
    env:Body
    <ns0:scheduleReportResponse xmlns:ns0="http://xmlns.oracle.com/oxp/service/ScheduleReportService">
    ns0:scheduleReport>95209</ns0:scheduleReport>
    </ns0:scheduleReportResponse>
    </env:Body>
    </env:Envelope>

    If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

    Regards,

    Gaurav