May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...xmlQuery single node valuesxmlQuery single node values
Previous Previous
 
Next Next
New Post
 8/11/2010 9:08 PM
 

Hi there,

I am just trying to get data from a web service like this one

http://www.webservicex.net/ConvertTem...

the xml result is something short like this:

<?xml version="1.0" encoding="utf-8" ?>
<double xmlns="http://www.webserviceX.NET/">91</double>

However when I try the xmlQuery element to get that data...I get an error = "Cannot find table 0"

I know it must be related to the face that there is only one node value... I have tried several ways to specify an elemenPath for that... but I was unsuccessful... am I missing something?

Thanks for you help!

L

New Post
 8/12/2010 5:03 PM
 

Hi,

Web services are not supported in this version. The statement will retrieve XML data returned by some URL in the response stream.

As workaround, you can write some web page (whatever the technology) that will call your web service and will then return the resulting XML (i.e.: Response.Write(yourXmlData). You will then have your XmlQuery statement points to this web page.

This KB article provides an example for returning data from SQL. Of course this approach is not necessary anymore for retrieving SQL data but you can apply the same principles for retrieving data from your Web Service.

Regards,


Frederic LATOUR
ENESYS
New Post
 8/13/2010 2:51 PM
 

Thanks Frederic,

I was able to call other web services that return a more robust response though. But I see what you mean, it's all about how the xmI response is structured. Thanks, I will try the workaround.

Regards,

L

New Post
 8/13/2010 4:56 PM
 

Hi Luciano,

It looks like I had overlooked your post.

In fact XmlQuery is not able to compose a soap header to deal with a SOAP web service but until you can call a simple URL that return XML data, that sould be fine.

Let me have some more look into this and I'll come back to you.

Regards,


Frederic LATOUR
ENESYS
New Post
 8/16/2010 4:06 PM
 

Hi Luciano,

As you had guessed, the problem comes from the single node result. A fix is in development. A minor release that includes this fix will be released this week.

Regards,


Frederic LATOUR
ENESYS
New Post
 8/16/2010 8:10 PM
 

Great! Thanks a lot,

L

New Post
 8/24/2010 5:36 PM
 

For information, this bug has been fixed in version 3.4.7.


Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...xmlQuery single node valuesxmlQuery single node values

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement