title: How to import json data form web api into SQL Server
body: <p>I want to insert data from Web API (strava web api) into SQL Server.</p>
  
  <p>I found function <code>openjson</code> but it's for raw data but if use url instead of raw data, which function can i use it.</p>
  
  <p>Example:</p>
  
  <pre><code>DECLARE @json NVARCHAR(MAX)
  SET @json = "https://www.strava.com/api/v3/activities?access_token=xxxxxxxxxxxxxxx"
  
  SELECT * FROM  
   OPENJSON ( @json )  
  WITH (   
                Number   varchar(200) '$.Order.Number' ,  
                Date     datetime     '$.Order.Date',  
                Customer varchar(200) '$.AccountNumber',  
                Quantity int          '$.Item.Quantity'  
  ) 
  </code></pre>