Calling a web service from within MS SQL
Budget: $30 – $250 USD
In my project I must use a SQL statement to call a REST API.
Any way of doing this would be appreciated.
I have been trying to use sp_OAMethod as Microsoft recommends,
but I need to put "x-ag-access-token: [ACCESS.KEY]" into
a header and I don't see where sp_OAMethod supports headers.
Anyone think they've got an answer?
Or a better way of doing this? Happy to pay for something that works.
I can send the SQL procedure for testing.
Any way of doing this would be appreciated.
I have been trying to use sp_OAMethod as Microsoft recommends,
but I need to put "x-ag-access-token: [ACCESS.KEY]" into
a header and I don't see where sp_OAMethod supports headers.
Anyone think they've got an answer?
Or a better way of doing this? Happy to pay for something that works.
I can send the SQL procedure for testing.