Jovan Popovic shows how to use cURL from within SQL Server with the CLR:
This code will add one function and one procedure in SQL Server that implements the following CURL functions:
-
CURL.XGET – function that calls API on some http endpoint using get method and fetches the response. It has two parameters:
- @H representing the header information that should be sent to remote endpoint (null for none).
- @url representing the endpoint where the Http request should be sent.
-
CURL.XPOST – procedure that sends text to some http endpoint using post method and prints response. It has three parameters:
-
@H representing the header information that should be sent to the remote endpoint (null for none).
-
@d representing the data that should be sent to remote endpoint in the request body.
-
@url representing the endpoint where the Http request should be sent.
-
Click through for the process. I’ve never been afraid of CLR and it is a rather useful tool, but pushing for CLR is definitely like swimming upstream.