Discussions

Expand all | Collapse all

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

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

    Bronze
    Contributor
    Posted 02-27-2019 21:39
    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


  • 2.  RE: Export data from a table or multiple tables in an xml format on a schedule.

    Bronze
    Contributor
    Posted 03-12-2019 17:55
    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