Passing data to webservice ?

[Former Member]

hello,

There is a webservice which takes particulars of customer details and validates now I need pass the customer details from an excel sheet to the input fields in the webservice.

can any one help on this

thanks in advance.

[rosenberg_eitan]

Hi,

Assuming you set up a web service consumer in SAP if not

http://wiki.scn.sap.com/wiki/display/ABAPConn/How+to+configure+a+Service+Consumer

Upload excel into internal table

http://wiki.scn.sap.com/wiki/display/ABAP/ABAP+code+snippet+to+upload+Excel+file+into+an+internal+ta...

loop on the table

for each line call the web service

add to the final table the result from the web service

regards.      

[Former Member]

Hi,

can you tell how to call  the web service

[PeterJonker]

Eltan already gave you the answer tot hat in the link:

http://wiki.scn.sap.com/wiki/display/ABAPConn/How+to+configure+a+Service+Consumer

Did you check that, because that describes everything you need to know ?

It tells you how to create a service consumer in ABAP and that is what you need to do.

[former_member628395]

Hi,

The steps involved(on a high level) are as follows

1. Create a Consumer or  Client Proxy in SE80 using the WSDL URL provided. This will generate a class with the methods and attributes based on the WSDL.

2. Create a logical port for the client proxy created in step 1 using the transaction SOAMANAGER with the same WSDL(Provide User ID and Password, if any). Please note that this step will open a webpage. Also you may need to edit the host file if needed.

3. Use the method(s) of the class generated in the Step 1 with the valid parameters in your program.

Hope this helps.

Regards,

Sagar

[rosenberg_eitan]

Hi,

May I add a very nice tool for testing of web services:

http://www.soapui.org/

Also: http://en.wikipedia.org/wiki/Web_service

regards.