Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle BI Publisher Rest API: Unable to run report, getting 404 error
User_AE1A7
Rank 1 - Community Starter
Hi, I am trying to generate reports using the REST API for Oracle BI Publisher. But, I get a 404 error. Here are the request details from Postman.
GET /xmlpserver/services/rest/v1/reports/shared%2FCampaigns%2FNew%20Contacts/run HTTP/1.1
Accept: multipart/form-data
Content-Type: multipart/form-data
boundary: Boundary_1_1153447573_1465550731355
Authorization: Basic SENQLlVzZXI6SGdwcm9IY3BAMTIz
User-Agent: PostmanRuntime/7.32.3
Postman-Token: cbaa3d32-6e6f-47cd-820a-0a165252f7c0
Host: reporting.p**.eloqua.com <- REDACTED
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Length: 207
--Boundary_1_1153447573_1465550731355
Content-Type: application/json
Content-Disposition: form-data; name="ReportRequest"
{"byPassCache":true,"flattenXML":false}
--Boundary_1_1153447573_1465550731355--
HTTP/1.1 404 Not Found
Date: Tue, 20 Jun 2023 18:26:46 GMT
Server: Oracle-HTTP-Server-11g
Content-Length: 252
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Type: text/html; charset=iso-8859-1
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>404 Not Found</title>
</head><body>
<h1>Not Found</h1>
<p>The requested URL /xmlpserver/services/rest/v1/reports/shared/Campaigns/New Contacts/run was not found.</p>
</body></html>
Screenshot of the report in the UI.
0
Answers
-
Hi, You need to correct your syntax -
Sample Runreport Request:
curl -X POST -v -u username:password -o SampleOAPReport.pdf -H "Content-Type:multipart/form-data" -v -F 'ReportRequest={"attributeFormat":"pdf"};type=application/json' https://<instancename>-<NameSpace>-<region>.analytics.ocp.oraclecloud.com/api/xmlpserver/services/rest/v1/reports/SAND_BOX%252fSample_Publisher_Report/runRefer this blog for example-
Documentation
0 -
Hello Sandeep, is this URL accessible from ERP Cloud ? or only analytics cloud in standalone mode ?
I'm looking for a rest api to call the reports
Thanks
0 -
Sandeep provided the 12.2.1.4. documentation which was probably the latest at the time. Documentation for all Oracle products can be found at the Oracle Help Centre. The most recent as of 25 April 2025 is
0
