Retrieves report, report type, and related metadata for a tabular, summary, or matrix report.

sf_describe_report(report_id, verbose = FALSE)



character; the Salesforce Id assigned to a created analytics report. It will start with "00O".


logical; an indicator of whether to print additional detail for each API call, which is useful for debugging. More specifically, when set to TRUE the URL, header, and body will be printed for each request, along with additional diagnostic information where available.


list containing up to 4 properties that describe the report:


Report type along with the URL to retrieve common objects and joined metadata.


Unique identifiers for groupings and summaries.


Fields in each section of a report type plus filter information for those fields.


Additional information about summaries and groupings.


  • Report metadata gives information about the report as a whole. Tells you such things as, the report type, format, the fields that are summaries, row or column groupings, filters saved to the report, and so on.

  • Report type metadata tells you about all the fields available in the report type, those you can filter, and by what filter criteria.

  • Report extended metadata tells you about the fields that are summaries, groupings, and contain record details in the report.

Salesforce Documentation


if (FALSE) {
# pull a list of up to 200 recent reports
# (for a full list you must use sf_query on the Report object)
reports <- sf_list_reports()

# id for the first report

# describe that report type
described_report <- sf_describe_report_type(unique_report_types[[1,"id"]])