title: Request data from JSON API and store in SQL Server using SSIS
body: <p>I'm trying to request data from a <strong>JSON API</strong> from Vemcount - a footfall-sensor system. I want to retrieve all my company's data and store it in a SQL Server db using SSIS. During my research I've realized that JSON is not natively integrated with SSIS, so solutions are either hardcoding the import or using a 3rd party - I've chose to go with the latter, so currently I'm trying to do the request using <strong>Kingswaysoft</strong> and their JSON Source component in VS. </p>
  
  <p>The URL looks something like this (example from their documentation, which can be found <a href="https://vemcount.zendesk.com/hc/en-us/article_attachments/115011635008/api.pdf" rel="nofollow noreferrer">here</a>): </p>
  
  <pre><code>https://login.vemcount.com/api/fetch_data/?data={"api_key":"xxxxxxx","type":"shop_id","id":[10,14,24],"date_from":
  "2014-01-01 00:00","interval":"15min"}
  </code></pre>
  
  <p>So, the keys <code>api_key</code>, <code>type</code>, and <code>id</code> are mandatory. The key/value pairs <code>"type":"shop_id"</code> and <code>"id":[10,14,24]</code> are the type of ID I want to search on and the ID itself. In the above example I've entered 3 different shop_id's. However, we have more than 250 id's, and more are being added continuously. </p>
  
  <p>How do I request <strong>ALL</strong> the different id's without adding all the id's in the array? I've pasted my HTTP CM and JSON Source Editor below. </p>
  
  <p>As you've probably guessed by now, this is somewhat unexplored territory for me, so I'm aware I might have chosen to proceed in a completely wrong way. If you have any better solutions for my case, please let me know. </p>
  
  <p><strong>UPDATE:</strong> So I've stored all Shop ID's in a variable, which I wanna pass as a value. </p>
  
  <p><a href="https://i.stack.imgur.com/khH4T.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/khH4T.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/YmRzJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YmRzJ.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/rJfJQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rJfJQ.png" alt="enter image description here"></a></p>