Query web API and return JSON data

• xclaim.david

  SSC Veteran

  Points: 267

  More actions

  October 9, 2023 at 6:45 pm

  #4304594

  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)

  • This topic was modified 1 year, 7 months ago by  xclaim.david. Reason: API, JSON, REST, sp_OACreate

• October 10, 2023 at 12:17 pm

  This was removed by the editor as SPAM

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 10, 2023 at 7:10 pm

  #4305315

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.