Here’s another fun trick I learned this week: sending HTTP requests with SQL Server. It turns out, we have access to a whole host of OLE automation classes from within SQL Server. The first thing we need to do is enable OLE automation. This is done with the sp_configure command.

Once OLE automation is enabled, you will be able to create OLE classes from within your scripts and stored procedures.

This example uses RequestBin.com for the HTTP target.

You can inspect the request at https://pipedream.com/r/en43ylz3txlaz.

Happy coding!