Pass prompt values in a Webservice

52 Views

Hi there, my requirement is to get 'Input Values' from a Combo Box(Dropdown) and pass those values into the webservice and get the output.

Here are the steps so far:

1) Created a WebI Report(using WebI Rich Client). The report has a prompt called 'State'

2) Published the report block as a web-service and copied the WSDL URL.

3) Created a Combo-box(Dropdown) in Xcelsius and put 'State' values to output to a cell 'A1'

4) Created a web-service connection in Xcelsius Data Manager, and used my WSDL URL. I am able to see that it has detected a prompt in my webservice in the Inputs area. There are two methods called:

valueofPrompt
  and
  Index

I am mapping the 'ValueofPrompt' to the same cell as the Combo-box output cell 'A1'

5) Clicked preview and when i picked any state say 'Alabama' and hit refresh, i see that i get values for all states, not just Alabama. So looks like my dropdown value is not being passed to the webservice.

Am i missing something? Any ideas where it might go wrong?

Thanks,

Kon