Python Forum
API with parameters exported to sql database
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
API with parameters exported to sql database
#1
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)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  convert strings of date to datetime exported from CSV GiorgosPap31 1 3,948 Oct-31-2019, 02:37 PM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020