DEV Community

Cover image for How to call external API from SQL server trigger

How to call external API from SQL server trigger

Zulfiqar Ali on March 08, 2023

Enabling Advanced Options and xp_cmdshell in SQL Server SQL Server is a relational database management system that supports various a...
Collapse
 
yet_anotherdev profile image
Lucas Barret

Really Cool ! I did not know it was possible to make API call in SQL , I'm gonna see if it work in PostgreSQL too.

Collapse
 
zulfiqarqureshi profile image
Zulfiqar Ali

Yea i also found this out recently when i had to work on a project and needed a way to trigger my backend whenever a row was inserted, my first call was to go towards CDC with debezium but the project was really simple and i ended up with this solution.