Is anyone aware of any attempts to convert IATI data in its original XML format into JSON format?
I am experimenting with importing IATI into a mongoDB as a side project, but thought to check if there was any existing tools before I have a go at building something from scratch.
Thanks for this extra detail on OIPA Vincent van 't Westende - I was more looking to convert the XML from the source publisher datasets (will likely use xmltodict for this), and primarily as a back-end only in the first instance.
Nonetheless, it’s good to know of some of the considerations and design approaches that were needed. I don’t work too much in json these days so hadn’t yet noticed some of the nuances of the notation when applied to IATI (use of underscores and plurals) so it was particularly good to highlight those.
Will post results here when I’ve had a chance to work something up!