How do you know the label of a column in the report?

Question

I use getReportMetadata() and after I use getDetailColumns(), but this is list of API Name of columns in the report. I want discover name this columns. Can you help me ?

Answer 1

// Get the report ID
List <Report> reportList = [SELECT Id,DeveloperName FROM Report where 
DeveloperName = 'abc_Report'];
String reportId = (String)reportList.get(0).get('Id');

// Run a report
Reports.ReportResults results = Reports.ReportManager.runReport(reportId);
// Get the report extended metadata
Reports.ReportExtendedMetadata rmd =   results.getReportExtendedMetadata();

// Get detail columns from extended metadata
Map<String,Reports.DetailColumn> colMap = rmd.getDetailColumnInfo();

for(String key : colMap.KeySet()){
System.debug('Key=' + Key + ' label=' + colMap.get(key).getLabel());
}  

For more information Refer ReportExtendedMetadata Class

Answer 2

You can describe the report using workbench as described in the Salesforce Reports and Dashboards REST API Developer Guide. The endpoint is simply:

/services/data/<latest API version>/analytics/reports/<report ID>/describe

The data you seek is under reportMetadata > detailColumns:

• reportExtendedMetadata
  • ...
• reportMetadata
  • detailColumns
  • ...
• reportTypeMetadata
  • ...

Here is a screenshot of a basic Report I set up on Opportunity to demonstrate:

And here is the describe information, showing the report labels for these fields: