Discussions

Expand all | Collapse all

API_GenResultsTable Summary Report Missing Fields

  • 1.  API_GenResultsTable Summary Report Missing Fields

    Posted 11-29-2017 14:56
    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.


  • 2.  RE: API_GenResultsTable Summary Report Missing Fields

    Top
    Contributor
    Posted 11-29-2017 15:24
    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


  • 3.  RE: API_GenResultsTable Summary Report Missing Fields

    Posted 11-29-2017 15:28
    Would using API_DoQuery work? I have a lot of tables to preform this on so I am trying to automate the process.


  • 4.  RE: API_GenResultsTable Summary Report Missing Fields

    Top
    Contributor
    Posted 11-29-2017 15:48
    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/