Apex Code Development You need to sign in to do that
Don't have an account?
Doug Chase Is it possible to use the API to retrieve the results of a given report?
We're unable to programmatically get report data via the API. Is this by design? If so, why? If not, how can we pull the data from the reports we designed within Salesforce for access by other systems?
We can get a list of reports, and the column names for a given report, but not the actual report data. This seems really odd.
Right now we're looking at "Salesforce to SQL" synchronization tools, but that's a very inelegant solution. Is that the way Salesforce wants its users to do this kind of thing?
Thanks!
Hi Doug,
Are you doing Salesforce integration to other systems?
How about using web services to pull the data?
Regards,
Hengky
I actually have the same question. I'm tryiing to get access to report records using either the SOQL or SOSL api. Is this possible? I'm only able to pull data about the report itself but, not the records in contains.
Hengky,
The first use case that we were trying to fulfill was getting report data, so no, we don't have other integrations in place. I'll ask the developer who was working on this whether they tried the web services route - I think that is how he was trying to do the integration.
Doug
Doug,
Maybe you can load the report to an analytic snapshot.
Then you can pull the data from the corresponding custom object.
Regards,
Hengky