Solved

XQuery and integration with Web Service method that returns XML

Posted on 2011-03-15
6
352 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 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
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…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now