Python Forum

Full Version: API with parameters exported to sql database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i have a URL and and also the api key to get data from an external website
howvever i need to provide 2 parameters to extract the data (Date, EMPLOYEE).
Once i enter the parameter i should get all the data i need in this format (name,account_number,date,employee).
After this i would like to export the results into an already created sql table ( same headers as above)
can someone please assist


this is what i did so far

import json
import requests

api_token = ''
url''

headers {'authorization': 'Bearer {0}.format(api_ken}
r= requests.get(url,headers=headers)

print(r.text)