title: 'GET MetaData' Activity output to SQL table using ADF v2
body: <p>I'm using 'GetMetadata' activity in my pipelines to get all the folders and child items and item types. But this activity is giving output in the JSON format which i'm unable to store the values to a variable so that i can iterate thru them. I need to store the Folders metadata in a sql table</p>
  
  <p>Get Metadata activity sample output is like below. </p>
  
  <pre><code>{
      "itemName": "ParentFolder",
      "itemType": "Folder",
      "childItems": [
          {
              "name": "ChildFolder1",
              "type": "Folder"
          },
          {
              "name": "ChildFolder2",
              "type": "Folder"
          },
          {
              "name": "ChildFolder3",
              "type": "Folder"
          }
      ],
      "effectiveIntegrationRuntime": "DefaultIntegrationRuntime (North Europe)",
      "executionDuration": 187
  }
  </code></pre>
  
  <p>Can some help me to store the above json output of 'Get MetaData' Activity into a sql table like below.</p>
  
  <p><a href="https://i.stack.imgur.com/ncwG7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ncwG7.png" alt="enter image description here"></a></p>