Making XML Parsing Quick and Simple

So I have an XML file that I am try to parse with a structure like that shown in the xml_structure.png.  I then am creating flows that look like sublows.png to unpack the data, with a bunch of specific xpath references to get each and every data item.

Is there an easier / better way.

  • Should I be converting to json
  • Should I try to figure out a way to get the data from xml into a sql server
  • Are their wild cards that I can use in an xpath node.

I'm just sort of frustrated by the tedium of how I am doing this at this time.  Help.

 

It's hard to tell if you don't tell us what the expected output should be...