nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Oracle AI and Analytics

Child Item

Child Item

Is it possible to create a data set using REST API as a data source in oracle fusion cloud?

Please suggest solutions to set up an REST API as a data source for a data model in Oracle Fusion. instead of sql query as a data set we need to pull data from rest api data.

Find more posts tagged with

BI Publisher

BI Publisher Data Models

Accepted answers

All comments

Sumanth V -Oracle

@Prakash B Roy -

This community is dedicated to OAC/OAS BIP-related queries. From your description, it seems you might be seeking guidance on Oracle Fusion or the OTBI tool. Could you please confirm? Thanks!

Hi @Sumanth V -Oracle ,

Our requirement related to BIP only, we need to make data set using rest API instead of SOAP.

Hi @Prakash B Roy ,

Looks like this is not supported. You can check the end points on below link:

REST API for Oracle BI Publisher - About the REST APIs

Thanks.

Hi @MandeepGupta ,

The link provided is for BIP Report API, but as you stated create data model in BIP report using rest API is not available seems.

Thanks,

Prakash

Yes, it will be a good idea to create an idea in Idea lab in customer connect:

Oracle Transactional Business Intelligence Idea Lab — Oracle Analytics

Thanks.

Hi @MandeepGupta

Sure

Pradeep Moganti

Have you tried configuring Web Service or HTTP Data Source?

https://docs.oracle.com/middleware/1221/bip/BIPAD/data_sources.htm#websvc_ds

Mallikarjuna Kuppauru-Oracle

Hi @Prakash B Roy

Refer below MOS doc -

How to add custom/user defined REST based data sources to BI Publisher in Fusion Cloud ? (Doc ID 2436451.1)

Regards,

Arjun

Hi @Mallikarjuna Kuppauru-Oracle ,

The doc confirms that this is unsupported at the moment. Thanks for sharing the note id for reference.

Thanks.

Also, are you able to check the ER status or any ETA on the ER?

@Mallikarjuna Kuppauru-Oracle

Thanks.

Top Leaders

MandeepGupta 85

Bhaskar Konar 35

user11008583 30

Kevin M-Oracle 20

Top Questions

BI Publisher not supporting xlsx template type
I created a XLSX template in Oracle Analytics Publisher Desktop 26.01.01 and uploaded the template to a BI Publisher report in OTBI. Things worked initially, but this morning when running the report I received an error: The report cannot be rendered because of an error, please contact the administrator. Error Detail:…
Question regarding BI Publisher Outputs
Hi All, I have a question regarding the BI Publisher Outputs. I have configured the rtf template output as Excel but when the XML Report Publisher program completes and I click on View Output, the output opens in a browser and renders as an HTML. Can some one please assist why this is so. The BI Publisher version is…
RTF Layout Upload Freezes with “Uploading, Please Wait” Message When NordPass Browser Extension
The issue is related to the NordPass browser extension installed via our corporate policy. Issue observed: Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely at "Uploading, please…
images in bi publisher report
Keeping track of the last scheduled run for a BIP Scheduled Report
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…