Report Fields

The Report Fields resource returns report fields available for specified reports. Use the resource to determine the best fields for use in dashboard filters by seeing which fields different source reports have in common. Available in API version 40.0 and later.

Resource URL

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

Formats

JSON

HTTP Methods

Method	Description
POST	If the request body is empty, returns a list of all possible report fields. Otherwise, returns a list of fields that specified reports share.

POST Request Body

Property	Type	Description
intersectWith	Array of Report IDs	An array of unique report IDs.

POST Response Body

Property	Type	Description
displayGroups	Array of Fields	Fields available when adding a filter.
equivalentFields	Array of Fields	Fields available for each specified report. Each object in this array is a list of common fields categorized by report type.
equivalentFieldIndices	Map of Fields	Map of each field’s API name to the index of the field in the `equivalentFields` array.
mergedGroups	Array of Fields	Merged fields.

Example Request Body

{
   "intersectWith": ["00OR0000000P3RVMA0"]
}

Example Response Body

{
  "displayGroups" : {
    "Opportunity" : [ {
      "columns" : {
        "ACCOUNT_CREATED_DATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Account: Created Date",
          "maxLength" : null
        },
        "ACCOUNT_LAST_ACTIVITY" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Account: Last Activity",
          "maxLength" : null
        },
        "ACCOUNT_LAST_UPDATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Account: Last Modified Date",
          "maxLength" : null
        },
        "ACCOUNT_OWNER" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Account Owner",
          "maxLength" : null
        },
        "ACCOUNT_OWNER_ALIAS" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Account Owner Alias",
          "maxLength" : 8
        }
      },
      "label" : "Account: General",
      "labelSuffix" : "(Opportunities)"
    }, {
      "columns" : {
        "CLOSE_DATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Close Date",
          "maxLength" : null
        },
        "CLOSE_DATE2" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Close Date (2)",
          "maxLength" : null
        },
        "CLOSE_MONTH" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Close Month",
          "maxLength" : null
        },
        "CREATED_ALIAS" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Created Alias",
          "maxLength" : 8
        },
        "CREATED" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Created By",
          "maxLength" : null
        },
        "CREATED_DATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Created Date",
          "maxLength" : null
        },
        "LAST_ACTIVITY" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Activity",
          "maxLength" : null
        },
        "LAST_UPDATE_BY_ALIAS" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Last Modified Alias",
          "maxLength" : 8
        },
        "LAST_UPDATE_BY" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Modified By",
          "maxLength" : null
        },
        "LAST_UPDATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Modified Date",
          "maxLength" : null
        },
        "LAST_STAGE_CHANGE_DATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Stage Change Date",
          "maxLength" : null
        }
      },
      "label" : "Opportunity Information",
      "labelSuffix" : "(Opportunities)"
    }, {
      "columns" : {
        "FULL_NAME" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Opportunity Owner",
          "maxLength" : null
        },
        "OWNER_MANAGER" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Opportunity Owner: Manager",
          "maxLength" : null
        },
        "ALIAS" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Opportunity Owner Alias",
          "maxLength" : 8
        },
        "ROLLUP_DESCRIPTION" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Owner Role",
          "maxLength" : 80
        }
      },
      "label" : "Opportunity Owner Information",
      "labelSuffix" : "(Opportunities)"
    } ],
    "LeadList" : [ {
      "columns" : {
        "EMAIL_BOUNCED_DATE" : {
          "dataType" : "datetime",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Email Bounced Date",
          "maxLength" : null
        }
      },
      "label" : "Lead: Ph/Fax/Email",
      "labelSuffix" : "(Leads)"
    }, {
      "columns" : {
        "CREATED_ALIAS" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Created Alias",
          "maxLength" : 8
        },
        "CREATED_DATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Create Date",
          "maxLength" : null
        },
        "CREATED" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Created By",
          "maxLength" : null
        },
        "CREATED_MONTH" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Created Month",
          "maxLength" : null
        },
        "LAST_ACTIVITY" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Activity",
          "maxLength" : null
        },
        "LAST_UPDATE" : {
          "dataType" : "date",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Modified",
          "maxLength" : null
        },
        "LAST_UPDATE_BY_ALIAS" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Last Modified Alias",
          "maxLength" : 8
        },
        "LAST_UPDATE_BY" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : false,
          "label" : "Last Modified By",
          "maxLength" : null
        },
        "OWNER_ROLE_DISPLAY" : {
          "dataType" : "string",
          "filterValues" : [ ],
          "filterable" : true,
          "isLookup" : true,
          "label" : "Owner Role Display",
          "maxLength" : 80
        }
      },
      "label" : "Lead General",
      "labelSuffix" : "(Leads)"
    } ]
  },
  "equivalentFieldIndices" : {
    "ACCOUNT_CREATED_DATE" : 19,
    "ACCOUNT_LAST_UPDATE" : 19,
    "ACCOUNT_OWNER" : 15,
    "CREATED_ALIAS" : 16,
    "CREATED_DATE" : 19,
    "LAST_UPDATE_BY_ALIAS" : 16,
    "ALIAS" : 16,
    "EMAIL_BOUNCED_DATE" : 19,
    "CLOSE_MONTH" : 17,
    "LAST_UPDATE_BY" : 15,
    "CREATED_MONTH" : 17,
    "LAST_ACTIVITY" : 17,
    "ACCOUNT_LAST_ACTIVITY" : 17,
    "CLOSE_DATE" : 17,
    "CREATED" : 15,
    "LAST_UPDATE" : 19,
    "CLOSE_DATE2" : 17,
    "OWNER_MANAGER" : 15,
    "LAST_STAGE_CHANGE_DATE" : 19,
    "ROLLUP_DESCRIPTION" : 7,
    "FULL_NAME" : 15,
    "ACCOUNT_OWNER_ALIAS" : 16,
    "OWNER_ROLE_DISPLAY" : 7
  },
  "equivalentFields" : [ {
    "LeadList" : [ {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    } ],
    "Opportunity" : [ {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    }, {
      "name" : "FULL_NAME"
    }, {
      "name" : "OWNER_MANAGER"
    }, {
      "name" : "ACCOUNT_OWNER"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "LAST_UPDATE_BY_ALIAS"
    } ],
    "Opportunity" : [ {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "LAST_UPDATE_BY_ALIAS"
    }, {
      "name" : "ALIAS"
    }, {
      "name" : "ACCOUNT_OWNER_ALIAS"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_UPDATE_BY"
    }, {
      "name" : "CREATED"
    } ],
    "Opportunity" : [ {
      "name" : "LAST_UPDATE_BY"
    }, {
      "name" : "CREATED"
    }, {
      "name" : "FULL_NAME"
    }, {
      "name" : "OWNER_MANAGER"
    }, {
      "name" : "ACCOUNT_OWNER"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_UPDATE_BY_ALIAS"
    }, {
      "name" : "CREATED_ALIAS"
    } ],
    "Opportunity" : [ {
      "name" : "LAST_UPDATE_BY_ALIAS"
    }, {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "ALIAS"
    }, {
      "name" : "ACCOUNT_OWNER_ALIAS"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "EMAIL_BOUNCED_DATE"
    } ],
    "Opportunity" : [ {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_STAGE_CHANGE_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "ACCOUNT_CREATED_DATE"
    }, {
      "name" : "ACCOUNT_LAST_UPDATE"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_MONTH"
    }, {
      "name" : "LAST_ACTIVITY"
    } ],
    "Opportunity" : [ {
      "name" : "CLOSE_DATE"
    }, {
      "name" : "CLOSE_DATE2"
    }, {
      "name" : "CLOSE_MONTH"
    }, {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "ACCOUNT_LAST_ACTIVITY"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "CREATED_DATE"
    }, {
      "name" : "EMAIL_BOUNCED_DATE"
    } ],
    "Opportunity" : [ {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "LAST_STAGE_CHANGE_DATE"
    }, {
      "name" : "CREATED_DATE"
    }, {
      "name" : "ACCOUNT_CREATED_DATE"
    }, {
      "name" : "ACCOUNT_LAST_UPDATE"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "OWNER_ROLE_DISPLAY"
    } ],
    "Opportunity" : [ {
      "name" : "ROLLUP_DESCRIPTION"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "CREATED_MONTH"
    } ],
    "Opportunity" : [ {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "CLOSE_DATE"
    }, {
      "name" : "CLOSE_DATE2"
    }, {
      "name" : "CLOSE_MONTH"
    }, {
      "name" : "ACCOUNT_LAST_ACTIVITY"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "EMAIL_BOUNCED_DATE"
    }, {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    } ],
    "Opportunity" : [ {
      "name" : "LAST_STAGE_CHANGE_DATE"
    }, {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "ACCOUNT_CREATED_DATE"
    }, {
      "name" : "ACCOUNT_LAST_UPDATE"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "CREATED_MONTH"
    } ],
    "Opportunity" : [ {
      "name" : "CLOSE_DATE2"
    }, {
      "name" : "CLOSE_DATE"
    }, {
      "name" : "CLOSE_MONTH"
    }, {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "ACCOUNT_LAST_ACTIVITY"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "CREATED_MONTH"
    } ],
    "Opportunity" : [ {
      "name" : "CLOSE_MONTH"
    }, {
      "name" : "CLOSE_DATE"
    }, {
      "name" : "CLOSE_DATE2"
    }, {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "ACCOUNT_LAST_ACTIVITY"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    } ],
    "Opportunity" : [ {
      "name" : "FULL_NAME"
    }, {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    }, {
      "name" : "OWNER_MANAGER"
    }, {
      "name" : "ACCOUNT_OWNER"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "LAST_UPDATE_BY_ALIAS"
    } ],
    "Opportunity" : [ {
      "name" : "ALIAS"
    }, {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "LAST_UPDATE_BY_ALIAS"
    }, {
      "name" : "ACCOUNT_OWNER_ALIAS"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    } ],
    "Opportunity" : [ {
      "name" : "OWNER_MANAGER"
    }, {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    }, {
      "name" : "FULL_NAME"
    }, {
      "name" : "ACCOUNT_OWNER"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    } ],
    "Opportunity" : [ {
      "name" : "ACCOUNT_OWNER"
    }, {
      "name" : "CREATED"
    }, {
      "name" : "LAST_UPDATE_BY"
    }, {
      "name" : "FULL_NAME"
    }, {
      "name" : "OWNER_MANAGER"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "LAST_UPDATE_BY_ALIAS"
    } ],
    "Opportunity" : [ {
      "name" : "ACCOUNT_OWNER_ALIAS"
    }, {
      "name" : "CREATED_ALIAS"
    }, {
      "name" : "LAST_UPDATE_BY_ALIAS"
    }, {
      "name" : "ALIAS"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "LAST_ACTIVITY"
    }, {
      "name" : "CREATED_MONTH"
    } ],
    "Opportunity" : [ {
      "name" : "ACCOUNT_LAST_ACTIVITY"
    }, {
      "name" : "CLOSE_DATE"
    }, {
      "name" : "CLOSE_DATE2"
    }, {
      "name" : "CLOSE_MONTH"
    }, {
      "name" : "LAST_ACTIVITY"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "EMAIL_BOUNCED_DATE"
    } ],
    "Opportunity" : [ {
      "name" : "ACCOUNT_CREATED_DATE"
    }, {
      "name" : "LAST_STAGE_CHANGE_DATE"
    }, {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "ACCOUNT_LAST_UPDATE"
    } ]
  }, {
    "LeadList" : [ {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "EMAIL_BOUNCED_DATE"
    } ],
    "Opportunity" : [ {
      "name" : "ACCOUNT_LAST_UPDATE"
    }, {
      "name" : "LAST_STAGE_CHANGE_DATE"
    }, {
      "name" : "CREATED_DATE"
    }, {
      "name" : "LAST_UPDATE"
    }, {
      "name" : "ACCOUNT_CREATED_DATE"
    } ]
  } ],
  "mergedGroups" : { }
}

Login

Products

Experiences

Agentforce

CRM Products

Industries

Small Business

Data

Salesforce Platform

Customer Success

Partner Apps & Experts

Discover the #1 AI CRM

Discover the #1 AI CRM

Automotive

Communications

Engineering, Construction & Real Estate

Consumer Goods

Education

Energy & Utilities

Financial Services

Healthcare & Life Sciences

Manufacturing

Media

Nonprofit

Professional Services

Public Sector

Retail

Technology

Travel, Transportation & Hospitality

Explore Salesforce for industries.

Explore Salesforce for industries.

Customer Stories

Salesforce on Salesforce Stories

Trailblazer Stories

Explore success stories.

Explore success stories.

Learning on Trailhead

Events

Resources

Blogs

Become a Trailblazer.

Become a Trailblazer.

Help & Documentation

Communities

Services & Plans

Account Management

Questions? We can help.

Questions? We can help.

About Salesforce

Our Values

Our Impact

Careers

Newsroom

Legal

More Salesforce Brands

Hear our story.

Hear our story.

Events

Original Series

My List

Explore Salesforce+.

Explore Salesforce+.

Login

Products

Experiences

Contact Us

By phone

Online

Products

Experiences

Developer Centers

Salesforce Platform

Industries

Resources

Developer Tools

Build Skills

Extend Salesforce

Stay Up To Date

Community

Salesforce Reports and Dashboards REST API Developer Guide