title: Flattening dynamic JSON content to SQL Server in ADF
body: <p>I am trying to flatten the dynamic JSON and put the result into a SQL Server table, but I have been unable to do so.
  I have tried the below ways so far.</p>
  <ul>
  <li>Copy Activity. The json data from a db table column is not recognized as Json. Left out.</li>
  <li>Data flow (Flatten). The json doesn't contain an array. Left out.</li>
  <li>Data Flow (Parser). The json data has a flexible structure and it wouldn't fit either.</li>
  </ul>
  <p>The dynamic survey form creates results in JSON shown below.</p>
  <p>Form a:</p>
  <pre><code>{
    &quot;q637481270215&quot;: { //form unique id
      &quot;q16124907150&quot;: &quot;Jonny Smith&quot;,  //name question unique id
      &quot;q16124907408&quot;: &quot;Yes&quot;,
      &quot;q16124907765&quot;: &quot;08/06/2022&quot;,   // form unique id for the form created data time
      &quot;q16124908929&quot;: {
        &quot;q16124909751&quot;: &quot;7&quot;,
        &quot;q16124910746&quot;: &quot;7&quot;,
        &quot;q16124910747&quot;: &quot;I'd love to find an answer.&quot;
      }
    }
  }
  Form n:
  {
    &quot;q637481270216&quot;: {
      &quot;q161249071512&quot;: &quot;Susan Smith&quot;,
      &quot;q161249074092&quot;: &quot;No&quot;,
      &quot;q161249077662&quot;: &quot;18/06/2022&quot;,
      &quot;q161249089302&quot;: {
        &quot;q161249097522&quot;: &quot;7&quot;,
        &quot;q161249107472&quot;: &quot;7&quot;,
        &quot;q161249107482&quot;: &quot;I'd love to find an answer.&quot;
      }
      ,
      &quot;q161249089303&quot;: {
        &quot;q161249097523&quot;: &quot;Yes&quot;,
        &quot;q161249107573&quot;: &quot;7&quot;,
        &quot;q161249107583&quot;: &quot;9&quot;
      }
    }
  }
  </code></pre>
  <p>I'd like to flatten/parse the results into a SQL Server table like this:</p>
  <pre><code>FormId          QuestionPropertyId      Answer
  ---------------------------------------------------------
  q637481270215   q16124907150            Jonny Smith
  q637481270215   q16124907408            Yes
  q637481270215   q16124907765            08/06/2022
  q637481270215   q16124908929            {{object}} or disregard
  q637481270215   q16124909751            7
  q637481270215   q16124910746            7
  q637481270215   q16124910747            I'd love to find an answer.
  
  q637481270216   q161249071512           Susan Smith
  q637481270216   q161249074092           No
  q637481270216   q161249077662           18/06/2022
  q637481270216   q161249089302           {{object}} or disregard
  q637481270216   q161249097522           7
  q637481270216   q161249107472           7
  q637481270215   q161249107482           I'd love to find an answer.
  ......
  q637481270216   q161249089303           {{object}} or disregard
  q637481270216   q161249097523           No
  .........
  </code></pre>
  <p>Is there any way to transform the Json content to the desired output format to a SQL Server table using Azure ADF?</p>