SQL Server 2012 make HTTP 'GET' Request from a stored procedure
<p>I was given a web service that returns a JSON object. My task is to make an HTTP 'GET' request to that web service and store the JSON data retrieved to a table every 5 minutes. </p>

<p>I am thinking about creating a stored procedure and then a job that would execute the stored procedure every 5 minutes.</p>

<p>My question is, can you make an HTTP request from a stored procedure?
Is there a better approach to accomplish this goal?</p>