title: How to Map JSON data from a REST API to Azure SQL using Data Factory
body: <p>I have a new pipeline in azure data factory.
  I created the dataset, one from the rest api (a public one):
  <a href="https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&amp;symbol=MSFT&amp;apikey=demo" rel="noreferrer">https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&amp;symbol=MSFT&amp;apikey=demo</a></p>
  
  <p>and then I created an azure sql table with columns shown in the screenshot</p>
  
  <p><a href="https://i.stack.imgur.com/mkcub.png" rel="noreferrer"><img src="https://i.stack.imgur.com/mkcub.png" alt="enter image description here"></a></p>
  
  <p>The problem, is that I dont know how to do the mapping, as this is a complex JSON object, I am limited with the Mapping Designer:</p>
  
  <p>How do I map the date?</p>
  
  <p><a href="https://i.stack.imgur.com/lan7J.png" rel="noreferrer"><img src="https://i.stack.imgur.com/lan7J.png" alt="f"></a></p>