You need to sign in to do that
Don't have an account?
jverd
End-to-end example: List reports, retrieve report metadata, execute report, retrieve results
I'm beating my head against the wall here trying to achieve the following, using the metadata API:
Thanks,
Jeff
Message Edited by jverd on 12-01-2008 01:50 PM
- List reports. I'm able to list reports I created in folders I created, but that's all.
- Retrieve a report's metadata. I tried with
new RetrieveRequest (14.0, null, true, new String[] {"MyFolder/MyReport"}, null);
But got INVALID_CROSS_REFERENCE_KEY: No packages or unpackaged specified. I'm really not clear on what the sepcificFiles an unpackaged parameters should be. - Run the report. I haven't seen anything that suggests I can even do this, but I'm assuming it must be possible.
- Retrieve the results of running the report in some standard format such as CSV or XML. I haven't seen anything that suggests I can even do this, but I'm assuming it must be possible.
Thanks,
Jeff
Message Edited by jverd on 12-01-2008 01:50 PM
If a report has been run--through the website or by a scheduled job or whatever--is it possible through the metadata API or some other API to retrieve the results of the report, say in CSV or XML?
Does the report object in the metadata API correspond to the report definition or to the data that resulted from running the report? It's the latter that I'm ultimately looking for.
Is this something that can be queried through SOQL? If so, can you point me to a starting point for whatever API I need for that?
Thanks,
Jeff
Message Edited by jverd on 12-01-2008 04:28 PM