title: Calling an API from SQL Server stored procedure
body: <p>Calling an API from ASP.NET Web Form is very easy.</p>
  
  <pre><code>WebClient wc = new WebClient();
  string urlData = wc.DownloadString("http://xxx.xxx.xx.xx/sssss/getResponse.do?ID=testing");
  </code></pre>
  
  <p>But can we call an API from SQL Server stored procedure.</p>
  
  <p>If yes then how can we call an API from a SQL Server stored procedure and how can we get API response?</p>