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 Rest Json API in sql server directly ? I believe its a combination of using he below, but i could not figure out the last syntax. sp_OACreate, sp_OAMethod sp_OAGetProperty Python version is here : # Version 3.6.1 import requests response = requests.get('https://api.server.com/v1/markets/quotes', params={'symbols': 'AAPL,VXX190517P00016000', 'greeks': 'false'}, headers={'Authorization': 'Bearer <TOKEN>', 'Accept': 'application/json'} ) json_response = response.json() print(response.status_code) print(json_response)
Handling HRESULT 0xC020402D from BufferManager.FindColumnByLineageID
First published on MSDN on Jun 04, 2010 While developing some custom transforms for my talks at the BI Conference next week, I hit a problem where I was getting an a failed HRESULT (COM Exception) in my PreExecute() method on a call to BufferManager.Looking up SSIS HResult / COMException ErrorCode
First published on MSDN on Aug 04, 2009 The method I describe in my post about handling COMExceptions during package generation works if you have control over the package generation code, but sometimes you’ll be using third party libraries, or debugging after the fact.
