Call Web Api json webservice from SQL Server stored procedure
<p>I am trying to find a way to call a web api web service that returns json from a SQL Server stored procedure. I have found ways to call SOAP web services but not web services that return json.
Also the web service requires authentication with username and passwd.
Any ideas?</p>