Code for converting multiple xml files to json file format

Question

I want to convert a folder containing over 3,300 .xml files into a .json file. How would I do this? The format is fixed. I would like to do this in python or java - which ever is easiest. I would like to see a coded example if possible please. If there is an open source industry tool that does this - please point me to it, but all I can find are single file converters which won't work for me. Can I do this in Talend? If so, how? I have a total of 11 zip files and approximately 210 gigabytes of data.

Answer 1

Hey, @AAron,

I would suggest you go through this as you need to follow multiple steps: https://www.girikon.com/blog/etl-xml-and-json-files-processing-with-talend-open-studio/

Comments

Awesome - thank you!

---

I do have another question - if I want to take the .xml and turn it into a specifically formatted file for an RDF graph database - can I specify or correct the JSON schema so that it reflects the new and improved schema....?

---

Is there a "rule of thumb" as to how many files at one time I should iterate through? Or maybe I need to experiment? Just curious how long 3,300 files might take to go through?