updating data base automatically

[dmbakker59]

I’m updating a CSV file automatically from Excel, but how do I go about it so that it is automatically uploaded in the data base for a website. The dynamic page would probably do the job, but I can’t find the connection between the data base and the file other than manually importing from the file.
The URL of the dynamic page would probably work, but how can I copy new information into the URL location.
Thanks for your time.

[aleksf]

Hi,
If you file is hosted somewhere online. You can try using the fetch API to get the data from it, and then update() the database.
For it to be done automatically, you can use Wix Jobs.
Please see the relevant articles below:

• https://support.wix.com/en/article/corvid-accessing-third-party-services-with-the-fetch-api
• https://www.wix.com/corvid/reference/wix-data.html#update
• https://support.wix.com/en/article/corvid-scheduling-recurring-jobs