Automating backups

We are working on behalf of our client to extend an app they have developed for multi-organisation use. Aside from the functional changes we will need to make, we are also looking at things like backup. We are looking to automate backups of objects so that we can extend the record retention of 7 days offered by Knack. Has anyone automated backups of their objects?

This is possible using the Knack API (docs). I recommend you write a script to make a series of calls to the API which will return you JSON representations of whatever records you choose. Once you have all the data, you can write it to disk, convert it into csv, send it somewhere, etc. Depending on the platform you use, running the script can be automated with a scheduler such as cron.