Skip to main content
Question

Export data from a table or multiple tables in an xml format on a schedule.

  • Feb 28, 2019 2:39 AM UTC
  • 0 replies
  • 105 views

Hello, I have a use case where I need to export data from a table in an application to an access database. Can this be done directly? 

If not, is there a way to export data in an XML file format to a location on a server or shared drive or a sharepoint site in XML format so that access will be able to read it or store it? Thanks
This topic has been closed for replies.

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