See if XmlAdapter will work for you
Using XmlAdapter to Create and Load Nested XML>Thanks, I should have thought of that. I use it all the time for processing web urls like authorize.net.
>
>I hate to admit being so out of date, but I rarely work with XML files. If I do a ohttp.responsetext, I get a string which I can convert to XML using xmltocursor. Problem is that the XML really contains the schema for 3 tables, which means the table schema is 1 level lower than a single table schema, and xmltocursor does not seem to be able to split the xml into tables.
>
>If I use ohttp.responsexml I get a nice xml object , but I have to parse it.
>
>I would be fine with taking all 3 tables fields into one dbf/table, that would be great. But how do I drill down a level to get those field names/values?
>
>Can you point me in the best direction?
>
>Thanks.
--sb--