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...
richie's avatar
richie
Community Hero
5 years ago
Hey Praku,

Im responding to this cos no one else has yet, so i'll try and help, but im a bit confused.
You state youre passing filter parameters, but its not filtering and youve included some sort of screenshot including some sort of dropdown "filter number" and "filter gender", but i dont know where this filter functionality is. Im using ReadyAPI, not SoapUI so there are obviously gonna be some differences but i dont understand.
Are you saying theres these dropdowns are in SoapUI that enable you to filter the content once the response has been received or do you mean something else?

I can see you have number amd gender tag values but other than that, im not understanding.

Can you clarif what you mean and then perhaps then we can try and sort you out?

Cheers

Rich
  • Praku's avatar
    Praku
    New Contributor
    5 years ago

    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.