title: Copy JSON datas in a SQL Server table with Data Factory
body: <p>I'm starting on Data Factory.</p>
  <p>I'm looking to copy data from a JSON file into a SQL server table using a data copy activity.
  I get my JSON data via a REST API by calling a HTTP request :
  <a href="https://i.stack.imgur.com/RKnWy.png" rel="nofollow noreferrer">extract of JSON 1</a>
  <a href="https://i.stack.imgur.com/aDVwj.png" rel="nofollow noreferrer">extract of JSON 2</a></p>
  <p>And I want to put the data in the following table:
  <a href="https://i.stack.imgur.com/jPsGy.png" rel="nofollow noreferrer">SQL Server Table</a></p>
  <p>I would like to create a new instance in the SQL table for each country with all its data (download, updates, etc.)</p>
  <p>My problem is with the mapping, as it is not a simple JSON structure I can't map the data dynamically.</p>
  <p>Could you please guide me on how to proceed to get the desired result?</p>
  <p>Thank you in advance for your help</p>