Adjust python script: Get data from online MYSQL database and import into Sharepoint list.
Budget: $10 – $50 USD
I have a curreny python script that needs some small adjustments:
This is what the script does:
1) Get data from my web MYSQL database (not on-premise)
2) Import into Sharepoint list(s) on my Sharepoint site
Needs to get a working connector for SP, or create an API or similar to get the data automaticly.
Setup a cronjob to run the script every hour on my linux webserver..
There is not much data to be transferred, one database and 3-4 tables in use, approx 10-100 rows should be transferred each day.
This is what the script does:
1) Get data from my web MYSQL database (not on-premise)
2) Import into Sharepoint list(s) on my Sharepoint site
Needs to get a working connector for SP, or create an API or similar to get the data automaticly.
Setup a cronjob to run the script every hour on my linux webserver..
There is not much data to be transferred, one database and 3-4 tables in use, approx 10-100 rows should be transferred each day.