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