Running Reports with databasedotcom gem

[mezza]

Thanks for the great work with the gem. Makes it extremely easy to run
SOQL queries and do general CRUD to data.

However, I find that Salesforce reports are faster when it comes to
exporting large amounts of data in CSV, rather than iterating through
paged results from a query, and wondered whether it's possible to
execute a report and fetch the results directly using the gem.

I can find a given Report by materialising the class and then
searching for a particular Id, but it doesn't seen to have any public
methods that would allow me to run the report and/or export the
results.

Is this possible?

Regards,

Merul

[Danny Burkes]

The ability to execute reports and fetch results is not a part of the Salesforce REST API, as far as I know.

- D

--
You received this message because you are subscribed to the Google Groups "ActiveSalesforce" group.
To post to this group, send email to activesa...@googlegroups.com.
To unsubscribe from this group, send email to activesalesfor...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/activesalesforce?hl=en.

[Alex Sutherland]

Hi Merul,

Thanks for your feedback on the gem, great to hear that people are finding useful!

Unfortunately Salesforce does not offer any (public) API for executing reports. Your only officially supported option is to run SOQL queries to get the data that you need and then build the presentation yourself. 

That said, there must be some kind of private API for it, because you can use the Salesforce Connect for Office plugin to download reports into Excel spreadsheets and keep them updated there:

https://login.salesforce.com/help/doc/en/importing_reports.htm

I would LOVE to see someone reverse-engineer that feature and figure out how to pull the report data out programatically. If I had a wealth of time on my hands I would do it, but alas I don't. Please let us know if you figure it out! :-)

Cheers,

Alex