Loading

Calling api in Stored Procedure without using front_end

Amit Kumar Singh

8y1.5k

Hello,

I have one scenario in which i have to call api in stored procedure without using front_end.Thanks in Advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mangesh G8y ago
sql clr is option amit make sure to check performance not affected !!!
Manav Pandya8y ago
Hello

There is option called Sql CLR

For calling web api without using front end, there is best and short article :

https://blogs.msdn.microsoft.com/spike/2010/11/25/how-to-consume-a-web-service-from-within-sql-server-using-sql-clr/

https://www.c-sharpcorner.com/blogs/calling-web-service-from-sql-server-using-sql-clr

Other article you can refer :

http://techxposer.com/2017/08/21/calling-rest-api-service-from-sql-server-using-c-sql-clr/

Thanks