Forum Discussion
DavidPais
Oct 09, 2023Copper Contributor
Query web API and return JSON data
curl -X GET "https://api.server.com/v1/markets/quotes?symbols=AAPL,VXX190517P00016000&greeks=false" \
-H 'Authorization: Bearer <TOKEN>' \
-H 'Accept: application/json' How do i run this R...
olafhelper
Oct 10, 2023Bronze Contributor
DavidPais , yes, sp_OACreate and the other system procedures is a possible way to go, see
OLE Automation stored procedures (Transact-SQL) - SQL Server | Microsoft Learn
But believe, you don't want that, it's more the painfull programming.
Better use scripts like PowerShell or a simple C# application.