Run a query through webservice?

[dolm]

 Is it possible to suppply a query to jasper and retrieve an answer set via the webservice? If so is there any examples of this? I have a sharepoint that has no DSN to the data warehouse available, only SOAP/XML. We need to query for data from forms in real-time and the Jasperserver jdbc connection would be a fantastic solution. Is this possible?

[elizam]

To the best of my knowledge, the SOAP interface does not query the database directly; however, you can set up a report and get the report results via SOAP.  Here is some information from the documentation (JRS Web Services Guide):

The repository web service is comprised of seven methods: list, get, put, move, copy, delete, and runReport.

You can retrieve the WSDL (Web Services Description Language) document that describes the repository service by invoking the URL of the service and appending the string ?wsdl. For example:
http://localhost:8080/jasperserver-pro/services/runReport?wsdl

Here's the description of runReport:

This operation executes a report on the server then returns the report’s results in the specified format. The client application is responsible for prompting users for values to pass to any input controls referenced by the report

There are examples in the documentation. The 4.5 web services guide is online here

http://jasperforge.org/espdocs/docsbrowse.php?id=87&type=docs&group_id=112&fid=366

 

[lisacbeaton]

I'm also trying to do this - were you successful? I've got the Web Services Guide, but where do I save the XML? How do you execute runReport? Is the user clicking a link? Any insight here would really be appreciated.