Solved

XQuery and integration with Web Service method that returns XML

Posted on 2011-03-15
6
394 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

The Problem How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side?  I give a bit more background at the end. The situation expressed as relational data Let’s work through this.  I’ve …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

737 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