A script that will import data from a remote JSON source to local MySQL table - Python or PHP
1) The script should create a respective data table in MySql if it does not exist
2) The script should import data from a remote JSON source to the earlier created MySql tables
2.1) During import a proper data conversion should be made (e.g. from Unix timestamp to date)
2.2) There will be a couple (4) different JSON calls required to gather and combine all the data
3) The script will run once a day (as a cron job)
3.1) The data should be imported to the local database only if the new ones are available in the JSON source - full data should not be imported every time the script runs
*) In the first step of the project, the MySql table structure should be confirmed.
*) Errors should be written to a log file
*) no 3rd party commercial (paid) libraries should be used
31 freelancers are bidding on average $158 for this job
Hi there! I have more than 7 years of experience in php web development. Please do not ignore me as a new profile. I can give you more quality work on time. Regards Ranit Majumder
Hello. I'm a python developer with a lot of experience in databases and JSON. I have done many similar projects. Please contact me over chat to discuss more. Best regards.
Hello. This is my favorite skill. I can read json from remote source and import to your local db using anything you want. You will get the perfect result. Best regards.