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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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
Photo of Raj Helaiya

Raj Helaiya

  • 1,450 Points 1k badge 2x thumb

Posted 4 months ago

  • 0
  • 1
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