title: Azure Data Factory complex JSON source (nested arrays) to Azure Sql Database?
body: <p>I have a JSON source document that will be uploaded to Azure blob storage regularly. The customer wants to have this input written to Azure Sql Database using Azure Data Factory. The JSON is however complex with many nested arrays and so  far I have not be able to find a way to flatten the document. Perhaps this is not supported/possible?</p>
  
  <pre><code>[
  {
  "ActivityId": 1,
      "Header": {},
      "Body": [{
          "1stSubArray": [{
              "Id": 456,
              "2ndSubArray": [{
                  "Id": "abc",
                  "Descript": "text",
                  "3rdSubArray": [{
                      "Id": "def",
                      "morefields": "text"
                  },
                  {
                      "Id": "ghi",
                      "morefields": "sample"
                  }]
              }]
          }]
      }]
  }
  ]
  </code></pre>
  
  <p>I need to flatten it:</p>
  
  <pre><code>ActivityId, Id, Id, Descript, Id, morefields
  1, 456, abc, text1, def, text
  1, 456, abc, text2, ghi, sample
  1, 456, xyz, text3, jkl, textother
  1, 456, xyz, text4, mno, moretext 
  </code></pre>
  
  <p>There could be 8+ flat records per ActivityId. Anyone out there that has seen this and found a way to resolve using Azure Data Factory Copy Data?</p>