2 Replies Latest reply on Dec 6, 2018 6:39 AM by Shawn Ryan

    How can I use the API to generate a crosstab?

    Shawn Ryan

      My business case requires us to be able to export to excel.

       

      We've been able to export to excel using some community resources, but now that we're able to export the data, it only comes in as 'raw' data, not as the crosstab that our report displays.

       

      When using the built in download functionality to csv, we can get the raw data OR the crosstab.


      Any advice on any API calls that will return our crosstab instead of the raw data would be great.

       

       

      So far we've tried:
      getSummaryDataAsync

      getUnderlyingDataAsync

       

      But, one just returns the data that we're displaying in raw form, and the other is all the data from our data sources, in raw form.  (Which makes sense, because that's how they're documented)