Easiest way to get the data is API_DoQuery to return the XML output. You could set up a quick base code page to run your query and parse the response as needed or export wherever you'd like. That method as described wouldn't necessarily be on a schedule. Your shortest step is to have someone click a button to invoke the call - and just set up a reminder to go in Quick Base and click it.
If you really need to have it run on a schedule, the options range on your technical background. You could set up a server process in Ruby or Node as examples and run on a schedule. Integration tools like Workato are much easier to work with and can do a lot more as well both in and beyond Quick Base. I haven't used it, but Google Scripts is out that to be able simple examples like this.
Chayce Duncan | Technical Lead
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base