I've got a project where I have to deal with metadata files describing all sorts of things (i.e, rating, running time, cast, etc). Currently the files are in XML using a schema I can not change. Multiple namespaces are used. As an example, here is a small subset from a file that uses ~ 450 lines of XML to describe 1 single movie:
<manifest:Inventory>
<manifest:Video VideoTrackID="md:vidtrackid:eidr-s:10.5240/82DD-86B7-876E-14A1-734F-M">
<md:Picture/>
<manifest:ContainerReference>
<manifest:ContainerLocation>http://ia700508.us.archive.org/20/items/Sita_Sings_the_Blues/Sita_Sings_the_Blues_720p.mp4</manifest:ContainerLocation>
</manifest:ContainerReference>
</manifest:Video>
While I can not change the XML, I do have the option of converting it to JSON. To-date I have not used the XML capabilities in either Brightscript or the roXMLElement. To be honest, the available documentation looks virtually non-existent and I didn't see much on the forum beyond the basics. I would need to deal with xPath queries against multiple namespaces. Then there is the question of relative performance The question in my mind, therefore, is what would more experienced members of the community suggest: go with JSON or XML?
Inquiring minds want to know :?