Salesforce: Retrieve Report Metadata (2)

In a previous blog, we discussed how to use package.xml in Workbench to retrieve report metadata. However, if we simply need to retrieve the report metadata, e.g., to understand the object of a field added to the report, we can simply use REST Explorer in Workbench.

Use GET method /services/data/v62.0/analytics/reports/00OGB00000Dt9Qv2AJ

Change the highlighted ID above to the report ID you want to analyze.

A few items to note from the above data:

• factMap > T|T > aggregates - number of rows of the report
• factMap > T|T > rows - the cell value of each row
• reportMetadata > detailColumns - API field name for each column in the report, including the object name and whether it is a lookup field in the report type
• reportMetadata > reportType - the report type used for the report

The same result (in XML format) you can get using REST Explore from Salesforce Inspector Reloaded.