Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

How to pass parameters in RunReport on OBIP using REST API or SOAP

Accepted answer
43
Views
3
Comments
Eugene_A_O
Eugene_A_O Rank 3 - Community Apprentice
edited October 12 in Oracle Analytics Publisher

I am able to get a valid output on both rest and soap when I dont add the parameters to the request

On the SOAP, I get the

image.png

On the REST API, I get error code 400 when I try to add the parameters to the curl

image.png

Can anyone assist with how the sample payload with parameters

Best Answer

Answers

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    Which product are you using (oac/oas/standalone bip)? Please share details of the actual command you are using (curl command for rest call) .

    The following KM doc has example of a REST call to create a job for a report which has one parameter. Please review the same.

    BI Publisher Is Failing When Running Reports Using SOAP Webservices (Doc ID 2751276.1)

    Other comments welcomed.

  • Eugene_A_O
    Eugene_A_O Rank 3 - Community Apprentice

    I am using OAS 2024

    curl -X POST -u username:password -o sample_report.pdf -H "Content-Type:multipart/form-data" -v -F "ReportRequest={'parameterNameValues': {'listOfParamNameValues': {'item': [{'name': 'startDt','values': {'item': ['10-01-2024']}},{'name': 'endDt','values': {'item': ['10-02-2024']}},{'name': 'ACC','values': {'item': ['sample']}}]}}}; type=application/json" http://ipaddress:9502/xmlpserver/services/rest/v1/reports/SAMPLE_REPORT.xdo/run