i trying retrieve results of salesforce report programmatically.
often referenced blog scraping results web side, method unsupported: http://sfdc-heretic.warped-minds.com/2006/04/10/progmatic-access-to-salesforcecom-reports/.
i can list of reports via rest api:
require 'restforce' restforce_client = restforce.new( :refresh_token => <refresh token>, :client_id => <client id>, :client_secret => <client secret> ) reports = restforce.query("select id,developername report") reports.last.developername => "rob_test_report"
i've tried retrieving via metadata soap api reportfolder object:
require 'metaforce' metaforce = metaforce.new( :username => <username>, :password => <password>, :security_token => <security token> ) report_folders = metaforce.list_metadata('reportfolder') report_folders.last.full_name => "robtestreportfolder"
i can see folder. haven't retrieved contents yet when seems getting metadata around report (i.e. filter criteria), not results of report. metadata api discussed here: https://success.salesforce.com/questiondetail?qid=a1x30000000iq8peag. correct?
i saw similar question couple years ago did not know if correct or had changed in api: how access reports programmatically in salesforce using apex
is possible export or pull results of report through supported salesforce api?
you cannot retrieve results of report without using analytics api, of summer '13 release available pilot. if want participate in pilot, let me know , submit request.
once in pilot, use rest endpoint passing in id of report. have 2 endpoints-- describereport endpoint , runreport enndpoint. returned describereport json representation of metadata report (describes dimensions , facts , such) , runreport json representation of data.
once have data can will. report data available @ summary level , pilot summary , matrix reports supported.
Comments
Post a Comment