-
Can report data be accessed programatically?
Hii All,
Is there any way to access existing reports and their data to be used in apex? Sure, I could write the SOQL manually but if I want it to mirror a specific report I would have to make code changes anytime the report was updated. -
1 Reply
-
Hi Tanu,
Yes, you can accessed reports in apex.
Firstly, you can get a list of reports in XML from: https://instance.salesforce.com/servlet/servlet.ReportList (replacing instance with the actual server instance, such as na1)
Once you have extracted the required report Id (00O key prefix) you can then request the report data in either CSV or HTML.
CSV https://instance.salesforce.com/00Ox0000000xxxx?export=1&enc=UTF-8&xf=csv
HTML https://instance.salesforce.com/00Ox0000000xxxx?export=1&enc=UTF-8&xf=xls (Last time I checked this was HTML rather than a native Excel file format. Excel does the conversion when it is opened).As for working with the CSV output, I found Parse a CSV with APEX but I haven't tested it yet.
If you want to get fancy, you can set filters for the report too. See BUILDING SALESFORCE CUSTOM LINKS - Linking to Reports for the pv0, pv1... query string parameters.
Reference:
Progmatic Access to Salesforce.com Reports This post was from 2006, but shows that the approach has been working for a several years now. That still doesn't mean it might not work tomorrow.
Log In to reply.
Popular Salesforce Blogs
Optimize Field Service Routes With Salesforce: Scenarios of Use
Route optimization is the process of figuring out the quickest and most economical route for your mobile field service agents to travel between appointments. Why…
APEX Rest Callout in Salesforce Integration
The Salesforce REST API allows you to integrate with Salesforce applications by using standard HTTP methods such as GET, POST, PUT, PATCH, DELETE, and HEAD.…
Why Digital Transformation is Essential for Business Growth? | Salesforce Guide
With reports suggesting that worldwide spending on the technologies enabling digital transformation is forecast to reach $2.3 trillion (£1.8 trillion) in 2023, more and more…
Popular Salesforce Videos
The History of Salesforce
Well, it's about time to talk about the history of the company that became a $10 Billion Dollar Industry from an efficient CRM. Watch this…
Is The Salesforce Job Market Saturated? | The Facts
You may have heard that the Salesforce job market is saturated, however there is no evidence to indicate this, in fact it’s the exact opposite!…
14 Questions Asked in 95% Salesforce Interviews
In this video, Dan Croitor provides a list of 14 questions that are typically asked in Salesforce interviews. He goes over each question in detail,…
