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
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.

       

       

      • 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