Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

XQuery and integration with Web Service method that returns XML

Posted on 2011-03-15
6
Medium Priority
?
404 Views
Last Modified: 2012-08-14
I am trying to understand how I might be able to call a Web Service method from XQuery and then interpret the results that the service sends back - unfortunately I have little experience in XQuery and even less in Web Services.

Can anyone give me an example of some XQuery code that would
 - call a Web Service method with a couple of parameters
 - the Web Service method would return a chunk of XML
 - the XQuery would then interpret that returned XML and carry out some action on what it finds
 
 
It's the XQuery end of things that I am interested in rather than the Web Service end.


Thanks.
0
Comment
Question by:Letterpart
  • 4
  • 2
6 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 35136482
it all depends on what the type of Web Service you have to deal with
and of the XQuery implementation that is used

XQuery is commonly used with rest interfaces to XML databases
Then the XQuery can be as simple as the below example
(real url obfuscated for this forum)
let $a := doc('http://.../datum/1807-08-12')
return
 <title>
    {$a//title[1]/text()}
 </title>

Open in new window

0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 35136484
rest being REST of course
0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 2000 total points
ID: 35136496
Here is an example on how DataDirect XQuery interface deals with SOAP calls
(which most generally are extensions to the XQuery language)
http://www.xquery.com/architecture/SOAP.html
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 1

Author Comment

by:Letterpart
ID: 35136693
I have seen how I can make requests to the Web Service methods I will need to access using a free Microsoft product - Web Service Studio  (http://archive.msdn.microsoft.com/webservicestudio20 ).

That allowed me to retrieve the WDSL and see the various methods and parameters.

When I use that product to invoke a method I can see that it appears to be using SOAP and there is Request information in XML format, and Response information in XML format.
It looks like your DataDirect example of building a message payload and invoking a SOAP Request will be useful - thanks for that, and your other example.
0
 
LVL 1

Author Closing Comment

by:Letterpart
ID: 35140268
Many thanks for your example code and reference link, and prompt response.
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 35142355
welcome
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month8 days, 17 hours left to enroll

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question