Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
7 years ago

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

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
APIs and custom code
App builders
App home pages

1 Reply

  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    7 years ago
    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