title: Create JSON file from a query with FOR JSON clause result in ADF
body: <p>I need to create a JSON file from azure SQL database and store the file in Azure blob storage.
  In ADF, I created a simple pipeline with one Copy Data activity to achieve this.
  I used t-sql query with FOR JSON clause to get data from the database.</p>
  <pre><code>SELECT * FROM stage.Employee FOR JSON AUTO, ROOT ('main_root')
  </code></pre>
  <p>Here is my source:
  <a href="https://i.stack.imgur.com/3NaN5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3NaN5.png" alt="enter image description here" /></a></p>
  <p>And this is a sink:
  <a href="https://i.stack.imgur.com/F235b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F235b.png" alt="enter image description here" /></a></p>
  <p>After execute pipeline, the created file looks like this
  <a href="https://i.stack.imgur.com/8fd6U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8fd6U.png" alt="enter image description here" /></a></p>
  <p>I want to get a normal JSON file with the structure</p>
  <pre><code>{
  &quot;main_root&quot;: [
      {
          &quot;Employee_No&quot;: &quot;1000&quot;,
          &quot;Status&quot;: &quot;Employee&quot;,
          &quot;...&quot; &quot;...&quot;,
          &quot;...&quot;
      },
      {
          &quot;Employee_No&quot;: &quot;1000&quot;,
          &quot;Status&quot;: &quot;Employee&quot;,
          &quot;...&quot; &quot;...&quot;,
          &quot;...&quot;
      },
      {
          &quot;Employee_No&quot;: &quot;1000&quot;,
          &quot;Status&quot;: &quot;Employee&quot;,
          &quot;...&quot; 
        &quot;...&quot;,
          &quot;...&quot;
  </code></pre>
  <p>Any help I will appreciate.</p>