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.