Calling an API from SQL Server stored procedure We are calling an API from SQL server SP (stored procedure) There are 2 way to call SP. SQL Agent Trigger We first write down SP for calling an API.