actionsequence as webservice client

[begunrom]

I have data, that can be extracted from the application only by using webservices. Can i create a actionsequence that acts as a webservices client and retrieve the information for the report?
If yes, how should this be done? Any documentation available?

[mbatchelor]

Have you looked at any of the XQuery example action sequences? Instead of a local file, the resource can be specified as a URL.

[begunrom]

I modified the XQ_Datasource.xaction example. I changed the source type to url and have set the location to "http://m030:8080/pentaho/ServiceActi...itles.xaction"

The CurrentPositionTitles.xaction is the one used in the webservices example and returns an XML message.
As soon as i run it i get the following message : "Error: File not found: http://m030:8080/pentaho/ServiceActi...Titles.xaction (org.pentaho.plugin.xquery.XQueryLookupRule)" It looks to me that the program is still expecting a file.

Even if the above would be returning the result expected, i still have a problem specifying the correct URL. The webservices i need to access are not accessible by a url like the one used here(as far as i know). These webservices are built using the axis framework and, as far as i know, need some clientsoftware based on the wsdl file. http://forums.pentaho.org/archived_a...source.xaction

[mbatchelor]

Try something like this in the resource definition:

<document>
 <url>
   <location>http://someserver.something.com/some...jsp</location>
   <mime-type>text/xml</mime-type>
 </url>
</document>

[begunrom]

I tried with this :

location= http://www.belgium.be/eportal/index.jsp

but the error is still the same.

Error: File not found: http://www.belgium.be/eportal/index.jsp (org.pentaho.plugin.xquery.XQueryLookupRule)

When creating tri message i wanted to include some xml. I did put it in a code block, but all my tags disappeared. What is the trick to make it work line in your previous mail?

Post edited by: begunrom, at: 05/31/2006 04:18

[spmva]

I had the same problem. Had to use html entities instead of less than and greater than signs.

< = less than
&gt = greater than

I just cut and paste the xml to notepad and did a find replace.

steve

[mbatchelor]

A couple of things:

1- Your above example returned an HTML document, not an HTML page. That won't fly.

2- I looked at your action sequence example, and you have the following URL:

http://m030:8080/pentaho/ServiceActi...Titles.xaction

You will need to double-escape the ampersand because it's being specified in XML and will be stripped out otherwise:

It will look something like this:

http://m030:8080/pentaho/ServiceActi...Titles.xaction

If this doesn't work, please re-attach the action sequence you're working on as well as the server error log. To do this, build a .zip file and attach it.

I hope this helps,

Marc

[begunrom]

It is still not working. As requested, i have included the boot.log, server.log and the xaction in a zip file. http://forums.pentaho.org/archived_a...webservice.zip

[mbatchelor]

It seems the forum post stripped off the sample I was trying to provide. I'll see if I can get it right here. There may be multiple edits until I get it looking right on review. ;-)

<location>http://m030:8080/pentaho/ServiceActi...ion</location>

OK - This one looks correct. What you should notice is that the result of the XML parser will find the first & and replace it with an ampersand (&). That will leave the other amp; behind it which ends up looking like &

I hope this helps,

Marc

Post edited by: mbatchelor, at: 06/01/2006 10:14

[begunrom]

The & problem has gone, but the file not found error is still there. In the server.log, i do not see any difference in URL anymore.
For your reference i included again the server.log and the action in server1.zip http://forums.pentaho.org/archived_a...es/server1.zip

Post edited by: begunrom, at: 06/01/2006 11:52