Salesforce.com-Tips and Tricks by Greytrix
Greytrix is one of the oldest Sage Development Partner of two decades for Sage product lines and Reseller of Sage ERP and CRM. Greytrix has been awarded "Sage Partner of the Year" numerous times both as developers and resellers. In these blogs, Greytrix will endeavour to share its knowledge with regards to implementation, training, customisation, components and technology and help users to understand in depth techno – functional aspects of Salesforce.com To leverage the Greytrix advantage write to us at salesforce@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home

Salesforce Tips – Discover the API Metadata for Salesforce Reports

By Greytrix | June 24, 2020
0 Comment

This blog signifies how a user can find the API metadata for a particular report. Before going through this blog make sure you have a keen understanding of reports, workbench and can understand sample apex code.

User will generally use this method to find the API name for the field attribute in <analytics:reportChart>. Using the Analytics API user can access Report Metadata.

Kindly follow the below steps to get the metadata for the report:

  • Open Salesforce workbench (https://workbench.developerforce.com/)
  • Select your Salesforce (Sandbox or Production) Environment and API version to login to your Salesforce credentials.
  • In workbench under the “Utilities” tab click on “REST Explorer”
  • Copy the URL: “/services/data/v29.0/analytics/reports/YourReportID/describe” and paste it in the Execute box.

Note: Paste the Report ID of your Report and replace it with YourReportID from the URL

  • To identify YourReportID, go to the reports tab. Open your report, and copy the text as shown in the below image
Report ID
Report ID
  • Execute the URL and you will see responses for the particular Report and click on the ReportMetadata.
  • In the expanded view of the module, search for ReportFilters. And you will see the number of parameters that have been set for the report.
Report Filters
Report Filters
  • Now we can use pass the filter value of the report dynamically through Apex class as shown in the below apexcode:
<analytics:reportChart reportId="00O3D000000bsojUAA" filter="[{column:'FK_ACC_ID', operator:'equals', value:'DynamicallyAssignedValue'}]" size="medium" cacheResults="false"/>
Where,
Column: The API name of the field that you want to filter on.
Operator: The API name of the condition you want to filter a field by, for example to filter by “not equal to”, we can use API name “notEqual”
Value: The filter criteria.

For more information, you can refer the below link: Use Metadata API to retrieve and deploy using Workbench

We hope you may find this Blog resourceful and helpful. If you still have concerns or need more help, please contact us on salesforce@greytrix.com

About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner, as a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3, Sage 100 and Sage 300. We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, Custom App development and Technical Support to business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow.

Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.

For more information, please contact us at salesforce@greytrix.com. We will be glad to assist you.

Related Posts

  • Change the icon image next to a ERP-SF linked record
  • Details about GUMU™ External UID field
  • How to rename the Field label in Salesforce for managed package
  • Using Roll-Up Summary field formula

Category: Salesforce Services Tags: analytic report chart, Dynamic run a report, fetch report metadata, get API of field used in report, get report API, pass filter value using apex class, Report, Report API, Report URL, run report through apex class, Salesforce Report
Post navigation
← Promote Quote from SF to Sage X3 ERP using GUMU™ Lightning Components GUMU™ Features – Experience Real-time Product Inquiry in SF – Sage 100 Integration →

Greytrix Websites and Blogs

  • Greytrix
  • GUMU™ Cloud
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage 300 – Tips, Tricks and Components
  • Sage CRM – Tips, Tricks and Components
  • Sage Business Cloud – Tips, Tricks and Components
sage enterprise management services

Categories

  • GUMU™ Features
  • GUMU™ Salesforce
  • GUMU™ Tricks & Tips
  • Salesforce Services

Recent Posts

  • Salesforce – How to get row index of lightning table rows
  • How to add Lightning Web Components as Custom Tabs in Salesforce
  • How to set cookies in HTTP Callout (APEX Salesforce)
  • Synching Additional (Order Details) Fields from Salesforce to Sage 300 ERP
  • Promote Quote from Salesforce – Sage 100 Integration using GUMU™ lightning version

Popular blogs

  • Thinking of enhancing your business processes? Get the best ERP – CRM connector on Salesforce AppExchange!
  • GUMU™ for Salesforce – Sage ERP Integration
  • Leverage real-time enterprise data for better insights of your Customers with Salesforce – Sage 300 integration
  • GUMU™ Integration for Salesforce with Sage 300

Archives

Awards

Greytrix Top ISV Partner
Greytrix Revenue Growth Enterprise Business
Greytrix Africa Highest Revenue
Greytrix Prtner of the Year
Greytrix Partner Award
Copyright 2019
Salesforce.com-Tips and Tricks
Iconic One Theme | Powered by Wordpress