API_GenResultsTable Summary Report Missing Fields

Question

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.

_anomdiebolt_ · Answer

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

mitchmitch · Answer

Would using API_DoQuery work? I have a lot of tables to preform this on so I am trying to automate the process.

_anomdiebolt_ · Answer

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/

Forum Discussion

API_GenResultsTable Summary Report Missing Fields

Related Content

Table is missing

Missing Records/Data Issue

Summary Reports

Reporting to identify blank or missing data

Missing an option in Kanban Card Groups