Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 247 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to connect BI Publisher using REST services
Hello everyone, I'm developing a project where I need to consume a couple of reports from BI Publisher using OIC. The idea was to consume them via URL. I see there are certain connection services for this, but I'm getting a 500 error. The report URL is: https://domain/xmlpserver/Custom/PruebaBI.xdo. I'm trying to consume it this way: https://domain/xmlpserver/services/rest/v1/reports/L0BDYXRhbG9nL3NoYXJlZC9DdXN0b20vUHJ1ZWJhQkkueGRv, and I've also tried this: https://domain/xmlpserver/services/rest/v1/reports/
json request: {
"reportRequest": {
"reportAbsolutePath": "/Custom/PruebaBI.xdo",
"outputFormat": "csv",
"sizeOfDataChunkDownload": -1
},
"parameterNameValues": {
"item": []
}
}
In all attempts, it returns this:
<!DOCTYPE html><html lang="en-US"><head><meta charset="UTF-8"/><title>HTTP Status 500</title></head><body><h2>Error information</h2>Servlet Name: BIPublisher RESTful Services</br></br>Request URI: /xmlpserver/services/rest/v1/reports/L0BDYXRhbG9nL3NoYXJlZC9DdXN0b20vUHJ1ZWJhQkkueGRv<br><br>Inspect the log file for complete details of this incident.</body></html>
header:
Can you help me by explaining how to consume data from OIC BI Publisher? My user account has the necessary permissions. Thank you.
Best Answer
-
Moved this discussion the the Publisher forum
1
Answers
-
Hi @wilberth Canales Romero , Thanks for posting your question.
We recently had a discussion around this topic, please check the following thread, and let us know if this helps:
2 -
500 error happens because the BI Publisher REST API is not invoked correctly.
This error generally means the endpoint is correct but the request structure or authentication is wrong, not that permissions are missing.1 -
Hi, do you happen to have any usage examples? I've tried a thousand ways and I'm still getting error 500.
0 -
Here is an example:
curl -X GET -u user:password -o op.html -H "Content-Type:multipart/form-data" -v -F 'ReportRequest={"attributeFormat":"html"};type=application/json' http://<host>:<port>/xmlpserver/services/rest/v1/reports/Test%252FBalance%20Letter/run
FYI this will not work if you are running against an FA SaaS instance.
Rgds,
Kevin
0
