I have an operation which calls an external web service, returning a long XML string.
Passing the string into Excel creates a table like this:
Each row above relates to a document on a server. In Ensemble, I need to parse the XML similarly to Excel, where I can loop over each document and take various actions depending on the different values.
I created a BPL to call the operation and return the XML string, which I've converted it to an %XML.TextReader object, and I'm using a While loop to loop through each element.
I put in traces for Name, NodeType, Path and Value and examined the results through every loop: