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)
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)