title: Simplest way to call REST api and insert resulting json data into SQL Server
body: <p>I have a bunch of REST API calls that return flat-ish json data that I want to call periodically and dump into a SQL Server database. What's a simple way to do this without writing lots of code? I'm on a windows platform and happy using C#, Powershell, T-SQL, SSIS, or something else 'normal' for windows platforms.</p>
  <p>I'd prefer not to have to hand-code anything based on the json fields, i.e. it'd be great if it can automatically look at the json and create destination tables in SQL Server or at least do the mapping mostly for me.</p>
  <p>Generally my API results are an array of similar-looking json objects with no nested objects. Different API calls have json objects with different fields, but results of any one call all have the same fields, e.g.</p>
  <pre><code>[ 
      {
        &quot;id&quot;: &quot;abc&quot;,
        &quot;quantity&quot;: 1234,
        &quot;price&quot;: 3456.03,
        &quot;entityId&quot;: 99,
        &quot;anotherField&quot;: &quot;cows&quot;
      },
  ...
  ]
  </code></pre>