Skip to main content
Question

API_GenResultsTable Summary Report Missing Fields

  • November 29, 2017
  • 0 replies
  • 26 views

I have a saved summary report that I need to return in a CSV format. I am able to return the file, but, when I do so the fields used to summarize the data are not included. Has anyone else ran into this issue before? I have tried changing the clist but it hasn't helped.
This topic has been closed for replies.

  • Quickbase Alumni
  • November 29, 2017
API_GenResultsTable does not work on Summary reports.

Try using a browser extension for this task. Maybe:

https://chrome.google.com/webstore/detail/table-to-csvjson/lcmljkenflafolafllblkbchomcnaefi?hl=en-US

  • Author
  • Quickbase Alumni
  • November 29, 2017
Would using API_DoQuery work? I have a lot of tables to preform this on so I am trying to automate the process.

  • Quickbase Alumni
  • November 29, 2017
I would write a script to load a summary report and a library such as tableexport to parse the csv and download it:

https://tableexport.v4.travismclarke.com

Simple demo here:

https://jsfiddle.net/natterstefan/0duaejg6/