Forum Discussion

Praku's avatar
Praku
New Contributor
5 years ago

Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

  Hi,   Could any one advise how to pass parameters for filtering the data through the OTBI Report webService using the SOAPUI. analytics-ws/saw.dll?SoapImpl=xmlViewService Though passing the Pa...
Praku's avatar
Praku
New Contributor

Hi Rich,

 

Thanks for your response.

Apologize for confusion.

 

To make it simpler the requirement is to automate to run the report using the webservice using the filter parameters.

 

The same OTBI report works fine when it runs from application (UI) and it filters the data based on the parameters.

 

I have two parameters "Person Number" and "Person Gender" for filtering the data.

 

Hope I made it clear this time.

 

Thanks

richie's avatar
richie
Community Hero
5 years ago

Hi Praku 

 

ah - ok - now I think understand what you mean.  It all depends on what your endpoint supports and how/if you can alter the parameters.

 

This is not REST - this is SOAP - and SOAP doesnt include parameters to filter/tailor your request's response.

 

Obviously I dont know your endpoint and what is supported and what isnt - but considering what I know about SOAP and my previous experience with SOAP projects - the only way I can see you filtering the content is by altering the payload of your request (within the SOAP envelope) to retrieve the specific data you need on your SOAP POST.

 

This isnt really a SoapUI question.  What your endpoint supports and if/how you can filter the data on the response would be defined in the requirements that describe the functionality of your SOAP endpoint.

 

this might not be available via your SOAP - filtering of your data could be performed by whatever Reporting functionality youre using.

 

Essentially you need to check your requirements and this will tell you what you need to know.

 

Sorry i cant help any more

 

ta

 

rich 

  • Praku's avatar
    Praku
    New Contributor
    5 years ago

    Hi Richie,

     

    Thanks for giving an attempt.

    But for me to further proceed I am looking for sample payload.

    There is no change in the requirement.

     

     

    • richie's avatar
      richie
      Community Hero
      5 years ago

      Praku 

       

      yes, no - i know there's no change in requirement - you misunderstood me  - thats not what i said.

       

      i said to check the requirements to find out how to tailor your payload as this isnt a SoapUI specific question - this relates specifically to your SOAP endpoint.

       

      ta

       

      rich

      • Praku's avatar
        Praku
        New Contributor
        5 years ago

        Hi

         

        I am looking for a solution who can provide fix for my issue.

        I replied so that this question remains unanswered so some other member can provide solution who come across such issues.