I got a WSDL file to start to develop a way to communicate and extract data from a vendor web service. First time I face this kind of files. I loaded into Excel 2016, and I got a "DATABASE" with one record with these headings: "Attribute: name" and "Attribute: targetNamespace". I have no idea what to do with this file. Please, point out any ideas about how or where to start deciphering the puzzle for me. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
WSDL XML to Excel Connections and Extract Data
Kyle123
Well-known Member
- Joined
- Jan 24, 2012
- Messages
- 2,771
Re: HELP!!!: WSDL XML to Excel Connections and Extract Data
It may be or it may not be, it likely depends on the complexity of the webservice. Some SOAP services support getting data via GET and POST which is more straightforward than having to form XML, some don't though.
You'll probably end up either needing to write VBA to do this, or, if simple enough using Power Query.
It may be or it may not be, it likely depends on the complexity of the webservice. Some SOAP services support getting data via GET and POST which is more straightforward than having to form XML, some don't though.
You'll probably end up either needing to write VBA to do this, or, if simple enough using Power Query.
Upvote
0
