Forum Discussion
Connect excel data to SOAP UI
Hi there, I have data in excel which I have concatenated as per XML required in SOAP UI. Is there a way to directly connect this to SOAP rather than moving the data manually to SOAP. Any othe...
It is very likely you'll have to do this using VBA programming. The XML you mention is likely what is called the SOAP Envelope, am I correct?
JKPieterse Yes I have basically concatenated the SOAP payload in excel. Two columns have hard text while the other two have dynamic values. Guess this is the envelope you are referring to.
- You'll have to refer to the documentation of the webservice to find out how to call it properly from VBA. Which service is it (which URL)?
JKPieterse It is the structure service. I am not familiar with VBA so would really appreciate if you could please guide to any relevant document.
