[RESOLVED] Can one import JSON from Amazon directly in SQL Server?

I can retrieve a JSON table as an HTML Response body from CloudFront.net by sending a JSON query as POST data in an HTML request. I believe CloudFront.net is Amazon AWS. I have read on the MSDN that one can import JSON data from things like Azure directly from the SQL Server. It surprised me to see a URI in a SQL query. I was imagining a scheduled stored procedure. Can one do the same thing to CloudFront?

I forgot to include the article. Click here.