API_GenResultsTable Summary Report Missing Fields

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • In Progress
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.
Photo of Mitch

Mitch

  • 80 Points 75 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
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
Photo of Mitch

Mitch

  • 80 Points 75 badge 2x thumb
Would using API_DoQuery work? I have a lot of tables to preform this on so I am trying to automate the process.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
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/