Apex Code Development You need to sign in to do that
Don't have an account?
Manza Help getting reports api column names
Hi I am trying to follow this link (https://www.salesforce.com/docs/developer/pages/Content/pages_compref_analytics_reportChart.htm) in order to get the reports api column names, in order to use some filters however I keep getting the following error
INVALID_SESSION_IDSession expired or invalid
when i try to open the following URL
https://cs6.salesforce.com/services/data/v29.0/analytics/reports/{!myreport}/describe
Is there anyhting that I am missing from the documentations?
Thanks
INVALID_SESSION_IDSession expired or invalid
when i try to open the following URL
https://cs6.salesforce.com/services/data/v29.0/analytics/reports/{!myreport}/describe
Is there anyhting that I am missing from the documentations?
Thanks
Hi Karanraj
Yes I have user my report ID instead of /{!myreport}
I end up running in the developer console the following code:
List <Report> reportList = [SELECT Id,DeveloperName FROM Report where DeveloperName = 'MyReportName'];
String reportId = (String)reportList.get(0).get('Id');
Reports.ReportResults results = Reports.ReportManager.runReport(reportId);
Reports.ReportMetadata rm = results.getReportMetadata();
System.debug('Detail columns: ' + rm.getDetailColumns());
All Answers
You can also check the details in https://workbench.developerforce.com/login.php login into the tool and then go to utilities -> REST Explorer
Thanks,
http://karanrajs.com
Hi Karanraj
Yes I have user my report ID instead of /{!myreport}
I end up running in the developer console the following code:
List <Report> reportList = [SELECT Id,DeveloperName FROM Report where DeveloperName = 'MyReportName'];
String reportId = (String)reportList.get(0).get('Id');
Reports.ReportResults results = Reports.ReportManager.runReport(reportId);
Reports.ReportMetadata rm = results.getReportMetadata();
System.debug('Detail columns: ' + rm.getDetailColumns());