+ Start a Discussion
VFVF 

Api call supporting Report data in salesforce

Is there any way to retrieve the Report data? I didnt find the any API call for salesforce which supports this.

Your response is appreciated. 

 

Thanks

shaan 

Best Answer chosen by Admin (Salesforce Developers) 
Ron HessRon Hess

No, there is no API that allows access to the data found in custom reports.

 

you must use SOQL and the webservices API to access data directly, reports is not one of the tables that you can access.

All Answers

Ron HessRon Hess

No, there is no API that allows access to the data found in custom reports.

 

you must use SOQL and the webservices API to access data directly, reports is not one of the tables that you can access.

This was selected as the best answer
arytenaryten

Hi,

 

I read that Salesforce expose some fields about Report in the Metadata API. How can i access those fields in an Apex class?

 

Example: i have created a Report (called "Rep01") and i want to retrieve its fields or filters. I supposed to do like that:

 

List<Report> reps = [SELECT Id,Name FROM Report WHERE Name =: 'Rep01' ];
Report r = reps.get(0);

String repField = r.columns[0].field; // ** ERROR ** : Invalid field columns for SObject Report

 

 

Since i get the error.. what is the correct way to access those fields listed in the API here ?

 

Thanx in advance for the answer...

SaqibMBASaqibMBA

Hi Everyone,

 

i was just wondering if this is possible now in 2011/2012, ie calling reports via the api?