• Extract XML File to Dataset(s)

    Automate 11
    Anyone have experience/luck with extracting a multi-level, complex XML file into multiple datasets for use in database functions?
    I have a file that has multiple levels and at varying levels could have one or more nodes with children. Super basic sample below. I have some ability to pull out data, especially if I explicitly call out nodes, but since the schema of the file could allow multiple nodes in certain sections, I need the ability to iterate through various sections and pull the data associated with it to send to a database. Super basic xml below just to show the logic. For example, i need to populate a dataset for Site A with its address and a sub dataset with its employees. The same with Site B, and so-on... I didn't find a lot of great documentation on the XML
    Pretend the below is actual XML format, couldn't figure out how to format it with the right bracket style and have it actually show up in this view, it kept hiding the node names.
        [root]
        [sites]
        [site]
        [sitename]Site A[/sitename]
        [addr]xyz[/addr]
        [city]Las Vegas[/city]
        [state]NV[/state]
        [employees]
        [staff]
        [name]Joe Bob[/name]
        [/staff]
        [staff]
        [name]Jim Bob[/name]
        [/staff]
        [/employees]
        [/site]
        [site]
        [sitename]Site B[/sitename]
        [/site]
        [/sites]
        [/root]