Automatic export from QuickBase into Excel
Hello! There are a few parts to this project I'm trying to complete. First, I have specific filtered table reports I've created in QuickBase in multiple different tables. I'd like to automatically ...
Forum Discussion
Read this article:
http://www.kimgentes.com/worshiptech-web-tools-page/2010/8/19/web-connecting-csv-files-as-external-data-to-excel-spreadshe.html
The URL you would use would be a CSV report using either a report with this setting:
Options | Format = Comma-Separated Values
Or a URL that calls API_GenResultsTable
https://YOURSUBDOMAIN.quickbase.com/db/YOURDBID?act=API_GenResultsTable&qid=1&options=csv
http://www.kimgentes.com/worshiptech-web-tools-page/2010/8/19/web-connecting-csv-files-as-external-data-to-excel-spreadshe.html
The URL you would use would be a CSV report using either a report with this setting:
Options | Format = Comma-Separated Values
Or a URL that calls API_GenResultsTable
https://YOURSUBDOMAIN.quickbase.com/db/YOURDBID?act=API_GenResultsTable&qid=1&options=csv
The link given in this post above is slightly incorrect. It should be http://www.kimgentes.com/worshiptech-web-tools-page/2010/8/18/web-connecting-csv-files-as-external-d...