There are several forum posts talking about parsing XML files with namespaces, and others that talk about iterating through child data elements, but I can’t seem to get either to work with our current data set. The attached XML is a SOAP envelope response to an API call that has three headers (Response_Criteria, Request_Filter, and Response_Results), and then has some number of Response_Data blocks (in this case, 2 blocks - but in the live data there will be 999 blocks).
At a minimum, we need to get the File_Content value from each Response_Data block.
Ideally we would also like to be able to retrieve the correlated Employee_ID that goes with that Response_Data block.
In a perfect world, we would be able to get all data elements, so that each iteration of the Response_Data would have the header data included.
This is the XML file with the Response_Data blocks collapsed for brevity:
This is what the Response_Data block looks like, expanded:
This is as far as I’ve gotten but I can’t figure out what combination of namespaces and .NET strings to use to get the data out:
data.xml (3.8 KB)