title: Map nested JSON in Azure Data Factory to raw object
body: <p>Since ADF (Azure Data Factory) isn't able to handle complex/nested JSON objects, I'm using OPENJSON in SQL to parse the objects. But, I can't get the 'raw' JSON from the following object:</p>
  
  <pre><code>{
     "rows":[
        {
           "name":"Name1",
           "attribute1":"attribute1",
           "attribute2":"attribute2"
        },
        {
           "name":"Name2",
           "attribute1":"attribute1",
           "attribute2":"attribute2"
        },
        {
           "name":"Name3",
           "attribute1":"attribute1",
           "attribute2":"attribute2"
        }
     ]
  }
  </code></pre>
  
  <p><strong>Config 1</strong></p>
  
  <p>When I use this config: <a href="https://i.stack.imgur.com/zvs4R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zvs4R.png" alt="enter image description here"></a></p>
  
  <p>I get all the names listed</p>
  
  <ol>
  <li>Name1</li>
  <li>Name2</li>
  <li>Name3</li>
  </ol>
  
  <p>Result:</p>
  
  <p><a href="https://i.imgur.com/xx0eLQK.png" rel="nofollow noreferrer"><img src="https://i.imgur.com/xx0eLQK.png" alt="enter image description here"></a></p>
  
  <p><strong>Config 2</strong></p>
  
  <p>When I use this config:</p>
  
  <p><a href="https://i.stack.imgur.com/XgDJX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XgDJX.png" alt="enter image description here"></a></p>
  
  <p>I get the whole JSON in one record:</p>
  
  <ol>
  <li>[ {{full JSON}} ] </li>
  </ol>
  
  <p>Result:</p>
  
  <p><a href="https://i.imgur.com/S5QW88s.png" rel="nofollow noreferrer"><img src="https://i.imgur.com/S5QW88s.png" alt="enter image description here"></a></p>
  
  <p><strong>Needed config</strong></p>
  
  <p>But, what I want, is this result:</p>
  
  <ol>
  <li>{ "name":"Name1", "attribute1":"attribute1", "attribute2":"attribute2  }</li>
  <li>{ "name":"Name2", "attribute1":"attribute1", "attribute2":"attribute2  }</li>
  <li>{ "name":"Name3", "attribute1":"attribute1", "attribute2":"attribute2  }</li>
  </ol>
  
  <p>Result:</p>
  
  <p><a href="https://i.imgur.com/mz88k7D.png" rel="nofollow noreferrer"><img src="https://i.imgur.com/mz88k7D.png" alt="enter image description here"></a></p>
  
  <p>So, I need the iteration of Config 1, with the raw JSON per row. Everytime I use the $['rows'], or $['rows'][0], it seems to 'forget' to iterate.</p>
  
  <p>Anyone?</p>