Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Consume external REST API in Fusion BIP

Received Response
144
Views
4
Comments
VijayAD
VijayAD Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

Is there a solution to consume external REST API in BIP Report and use the response as data source?

Answers

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics & AI Lead

    Hi Vijay

    Please review the given documentation about available BIP Webservices

    Doc ID 2086077.1 Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications

    NOTE: REST webservices of BI Publisher are currently not available for consumption in Fusion Application. There are no plans to include REST APIs in Fusion Applications.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics & AI Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/26031/consume-external-rest-api-in-fusion-bip

    Hi Vijay,

    This is not supported currently. In case you want to merge data between external API and fusion, then you need to have a middleware and a DB where you can push the data from both the systems and merge it.

    Thanks.

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics & AI Lead

    REST webservices of BI Publisher are currently not available for consumption in Fusion Application. There are no plans to include REST APIs in Fusion Applications.

  • Dnys Ch
    Dnys Ch Rank 1 - Community Starter

    Currently it is not possible via REST API but you could for example run a BI Publisher report via SOAP having Oracle Apex with the PL/SQL procedure using the apex_web_service.make_rest_request process and saving the response in a database table.