populating a Table from webservice

[Former Member]

Hi all,

I am new to interactive form. I am listing down what i have did,

1. Created a data connection (wsdl)

2. Used a free online wsdl in, http://footballpool.dataaccess.eu/data/info.wso?wsdl

3. I used validWSDL.com to check the valdity of the above wsdl - works fine.

4. I used a particular method while creating the dataconnectin "GroupCount" - which doesnt take any input but returns an int.

5. I tried running the webdynpro application,- it worked fine.

6. Later i used another dataconnection which uses a method called "AllCards" - which doesnt take any input , but return many records

7. When i execute the wsdl using execute button, the table is not populated.

My observations are,

-> WSDL is invked correctly and its giving the response.

-> Only Table datas are not displayed in interactive forms binded with wsdl response.

Please share your ideas and help me on this.

[Former Member]

I have tried all the possible ways, but i am not able to see multiple records coming from a webservice response object that is binded to a table in interactive form.

Please provide your inputs .

[former_member198445]

Hi Swaminathan.

For this case, the regular binding does not work..

As a solution, you have to use a 'post-execute' event by modifying the XML source of the form.

Take a look at this blog to see how to incorporate this additional event..

[http://forms.stefcameron.com/2009/03/23/pre-process-web-service-responses/]

Well, I had to fill a drop down with the web service response table.. You could loop thorugh the response and fill your table in the form,,

The following script may be helpful..

function processResponse(rootXml, soapFault)
{
DD.clearItems(); //Drop Down field

var c1 = rootXml.ZOperationName.EtReturn.nodes.length;
for (var i = 0; i < c1; i++)
{
   var returnNode = rootXml.ZOperationName.EtReturn.nodes.item(i); 
   DD.addItem(returnNode.Charg.value);    
}
}

Regards, Amith

[former_member203117]

Hi,

Were you able to complete this task?

Regards,

Tushar.