Use Reports API to get report results as CSV

Asked Mar 14 '17 at 23:28

Active Mar 14 '17 at 23:28

Viewed 2,543 times

Using the Reports and Dashboards API is there a way to convert report results to CSV?

Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true);
Map<String, Reports.ReportFact> fmap = results.getFactMap(); // how to convert to csv?

I am looking for an output that looks similar to the file that's generated when a report is exported as CSV. What I don't want is to manually parse the Fact Map as differentiating between summary-only and summary-detailed reports could be nasty.

asked Mar 14 '17 at 23:28

Mossi

3,956
3
34
61

Possible duplicate of export to csv using analytics api – Santanu Halder Mar 15 '17 at 07:24
@SantanuHalder the post you're referring to is about the Analytics REST API whereas I am asking about the native Apex version of it -aka Reports and Dashboards API. – Mossi Mar 15 '17 at 19:12
1

Does this answer your question? Tabular report data via analytics API – Paul N Aug 26 '22 at 18:10

Use Reports API to get report results as CSV

0 Answers0