Hello, We want a python script that will fetch data from our user manager with the help of well defined in API.
API will fetch data in JSON format as attached. you need to parse some defined fields and need to store the data in DB. That Scrip will run every 30 minutes and will insert any new entry in DB and if any update in-store data, it will be updated also, in other terms it will sync DB with our User Manager server every 30 minutes.
the script will have Variable list for "API Token" and "API Key" So we can define as many "API Token" and "API Key"
in respect of every "API Token" there will be a separate table in the database. if we add new API Token so in DB it should crate a table and required field.
I have attached dammy data for your refrence.