Issue while creating Data Model with HTTP POST Method in OTBI

User_X5A01

When attempting to run a data model in Oracle Transactional Business Intelligence (OTBI) that utilizes an HTTP dataset, an error occurs indicating that no response is returned from the HTTP request. This issue prevents the data model from executing successfully and triggering the necessary data. This is POST method HTTP request but not getting any response.

1. I have setted up the data source connection as follows:

server - https://xxxx.xxx.ocp.oraclecloud.com
port - 443
server protocol - https
realm - ic/api/integration/v1/flows/rest/reports/1.0/
Username - XXXX
password - XXXX

2. At Data model level -
URL suffix - /ic/api/integration/v1/flows/rest/reports/1.0/
Data source - from list
Method - POST
Parameter - As per POST method

I am getting error like this while running the data model - HTTP Process error, no response returned

can you please help me to figure it out.
Note: I have checked endpoints with POSTMAN, working as expected.

Thanks,
Vaibhav

Gaurav Bharadwaj-Oracle

Hi @User_X5A01 ,
I understand you are asking a question regarding HTTP DataSource.

The reason you are getting the error is because REST API are not supported in Fusion for the HTTP DataSource.
Please review : How to use REST API as a data source in BIP? (Doc ID 2642375.1)

If it is a critical functionality, i would recommend that you log an Idea in Idea Labs so our Product Management can review the same and if feasible implement it in one of the upcoming releases.

Idea Labs can be found Here : https://cloudcustomerconnect.oracle.com/pages/home
Before creating an Idea, it is recommended to go through the Guidelines : https://cloudcustomerconnect.oracle.com/pages/35fcc3b659

After logging in to the customer connect portal, please click on Idea menu and select the appropriate product.
On the following page you should be able to see a button "Submit Your Idea" please use that to request an Enhancement.

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

User_X5A01

My complete endpoint URL is

'https://xxxx.xxx.ocp.oraclecloud.com:443/ic/api/integration/v1/flows/rest/reports/1.0/'

Thanks,
Vaibhav

Bhaskar Konar

Thank you very much @Gaurav Bharadwaj-Oracle!

Very useful information.

Cheers,