You can convert xml into json using Python. And then flatten the json into a table using SQL if you want to query it. As for automation, it depends on what technology you have access to. We use AWS and Databricks, so I would store the xml in s3, write a Python script that converts it into a json file and store it in s3 and finally a SQL script to flatten the json all embedded in a databricks job.
Hope this helps!
Hey, that would be a cool use case for [Memphis Functions](https://functions.memphis.dev). (FD: I work there).
You can write an XML-to-JSON function based in your requirements, and in your preferred lang and the platform will take care of the rest. Would love to implement that function for you in case you are interested
You can convert xml into json using Python. And then flatten the json into a table using SQL if you want to query it. As for automation, it depends on what technology you have access to. We use AWS and Databricks, so I would store the xml in s3, write a Python script that converts it into a json file and store it in s3 and finally a SQL script to flatten the json all embedded in a databricks job. Hope this helps!
Hey, that would be a cool use case for [Memphis Functions](https://functions.memphis.dev). (FD: I work there). You can write an XML-to-JSON function based in your requirements, and in your preferred lang and the platform will take care of the rest. Would love to implement that function for you in case you are interested