XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Krishna MalyalaSubject: WSCall doesn't work from xquery
Author: Krishna Malyala
Date: 14 Nov 2011 01:30 PM
Downloaded trial version(14)and trying to test recursive web service call. Web Service call works fine in test mode but doesn't seem to work from xquery!
Initially tried on our internal WS but when it didn't work, I tried the stock quote one from the demo video: "http://examples.xquery.com/stock-quotes/wsdl". Attached is a screen-shot but here is the problem:
when I click "preview result", it thinks for some time,there are NO errors but the output doesn't contain anything from the WS! This is the same behavior from my internal service as well.
I have 5 rows in a SQL server table with ticker symbols for input to the WS.
Please help me figure out what's going on so I can try and get actual WS to work...

<k>


Documentstock_Test_xquery.docx
screenshot of xquery

Postnext
Ivan PedruzziSubject: WSCall doesn't work from xquery
Author: Ivan Pedruzzi
Date: 14 Nov 2011 03:38 PM
Hi Krishna,

It seems to work as designed, I just did a quick test, screenshot attached.


Ivan Pedruzzi
Stylus Studio Team

Postnext
Krishna MalyalaSubject: WSCall doesn't work from xquery
Author: Krishna Malyala
Date: 14 Nov 2011 05:07 PM
Thanks Ivan, I was able to get it to work after editing code to match your screenshot. This is good and helps me rule out any other issues, thanks.
However, I need to understand why auto-generated code didn't work... I think the main point of this tool (at least for me) is to minimize coding ;o) Any insights? I thought I followed the concept of online demo video.

<k>

declare namespace dd = "http://www.datadirect.com";
declare namespace y = "http://finance.yahoo.com";

<quotes>
{
for $tickers in collection("IWA.dbo.STOCKS")/STOCKS/TICKER
return
ddtek:wscall(<ddtek:location xmlns:ddtek="http://www.datadirect.com/xquery" soapaction="getQuotes.xquery" address="http://examples.xquery.com/stock-quotes/wsdl"/>,<dd:getQuotes><dd:tickers>
{$tickers/text()}
</dd:tickers></dd:getQuotes>)/quotes/stock/last-value
}

</quotes>

Posttop
Ivan PedruzziSubject: WSCall doesn't work from xquery
Author: Ivan Pedruzzi
Date: 14 Nov 2011 06:00 PM

We have a nice tutorial that shows how to integrate relational data and web services, using the XQuery mapping tool without typing a single instruction.
http://www.stylusstudio.com/videos/XQueryWS/XQuery_WS.html

Additional tutorials here
http://www.stylusstudio.com/xml_video_list.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.