Skip to main content
Question

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

  • February 28, 2019
  • 0 replies
  • 99 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

    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
    Terms & ConditionsAccessibility statement