pipeline – Can I use Azure Data Factory Copy Item to map nested XML to nested JSON
I’m trying to use a Blob source containing nested (1 level) XML documents and convert them to nested JSON (1 level)… similar to the following:
Input XML Document
rootchild
rootrepeatingelementchild1
rootrepeatingelementchild2
Output JSON Document
{
"RootChild": "rootchild",
"RootRepeatingElement": [
{
"RootRepeatingElementChild": "rootrepeatingelementchild1"
},
{
"RootRepeatingElementChild": "rootrepeatingelementchild2"
}
]
}
I’ve tried using the Copy Item mapping, but can’t seem to figure out how to do the nested elements.
Is this possible, if so is there a walk through link you can provide or explain how to map the repeating XML elements to a repeating JSON array. If not, is there an alternative?
Thank you.
Read more here: Source link