Help with web service data set

ajenkins

Hi,

I have had no problems with 2.2 release in web services. In 2.3, it is not reading my web service correctly.

My web service response is below

<prot:OnLineResponse dt="08/12/2008 16:39:34:293 PM PDT" xmlns:prot="protocol.core.status.mwvis.com"><prot:status>true</prot:status></prot:OnLineResponse>

The wizard that walks you through the setting up the data set does not see the namespace "prot". When you are done with wizard, it puts in the text in the report xml as below. This is 2.3.

<value>table0#-TNAME-#table0#:#[/SOAP-ENV:Envelope/SOAP-ENV:Body/OnLineResponse]#:#{status;STRING;/status}#:#<"SOAP-ENV","http:%%schemas.xmlsoap.org%soap%envelope%";"xsd","http:%%www.w3.org%2001%XMLSchema";"SOAP-ENC","http:%%schemas.xmlsoap.org%soap%encoding%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance"></value>

In 2.2, it recognized that the "prot" was in front of the elements and properties, and you saw that in the wizard. It generated a much shorter xml snippet below.

table0#-TNAME-#table0#:#[/soapenv:Envelope/soapenv:Body/prot:OnLineResponse]#:#{prot:status;STRING;/prot:status}


When I cut and paste the 2.2 snippet in the 2.3 xml report, it works of course, but I can't use the wizard or data set ui screens. It is also interesting that there is a ">" at the end of the 2.3 snippet, and there is a < in the front. It appears to be a bug. Fixing this doesn't help.

2.3 obviously got more complicated as seen by the xml it generates, but it does it incorrectly.

How do I setup web services datasources in 2.3 and get around the problem with the namespace?

ajenkins

in 2.3, I was able to go farther by not using the "query web services at soap end point", but by using the "use external sample data file" option.

This way, I put my exact xml response in a file, and that made the wizard get smarter with the namespace, "prot". It generated the following below.

<value>table0#-TNAME-#table0#:#[//prot:GetCompResponse]#:#{prot:cName;STRING;prot:cName},{dt;STRING;@dt},{prot:cLocation;STRING;prot:cLocation},{prot:cAppName;STRING;prot:cAppName}#:#<"prot","protocol.core.status.mwvis.com">


The problem is that it still does not work, because of the <"prot","protocol.core.status.mwvis.com">

When I remove the ending from the xml, the report works. This has to be a bug in the designer in 2.3. Well, several bugs.

I tried the xml snippet with > instead of the ">", but that didn't solve it.

I would be grateful with any info someone could provide.

Thanks