RE: [xsl] Xml file in an Xml file

You need to extract the embedded XML document as text and parse it. With
Saxon you can do this using saxon:parse(). With other processors you may be
able to call an extension function.

Michael Kay
http://www.saxonica.com/

-----Original Message-----
From: Danny Leblanc [mailto:leblancd(_at_)ca(_dot_)objectiflune(_dot_)com] 
Sent: 04 April 2007 17:07
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Xml file in an Xml file

Hello everyone.

  Using web services I am getting the following XML file 
returned to me.

<S:Envelope
      xmlns:S="http://schemas.xmlsoap.org/soap/envelope/";
      xmlns:XS="http://www.w3.org/2001/XMLSchema";
      xmlns:XI="http://www.w3.org/2001/XMLSchema-instance";

xmlns:a="http://www.webserviceX.NET";><S:Body><a:GetWeatherResp
onse><a:GetWeatherResult XI:type="XS:string">&lt;?xml 
version=&quot;1.0&quot; encoding=&quot;utf-16&quot;?&gt; 
&lt;CurrentWeather&gt;
  &lt;Location&gt;Montreal / Pierre Elliot Trudeau 
International Airport, Que, Canada (CYUL) 45-28N 073-45W 
36M&lt;/Location&gt;
  &lt;Time&gt;Apr 04, 2007 - 11:00 AM EDT / 2007.04.04 1500 
UTC&lt;/Time&gt;
  &lt;Wind&gt; from the ESE (120 degrees) at 15 MPH (13 KT) 
gusting to 28 MPH (24 KT):0&lt;/Wind&gt;
  &lt;Visibility&gt; 6 mile(s):0&lt;/Visibility&gt;
  &lt;SkyConditions&gt; overcast&lt;/SkyConditions&gt;
  &lt;Temperature&gt; 37 F (3 C)&lt;/Temperature&gt;
  &lt;DewPoint&gt; 33 F (1 C)&lt;/DewPoint&gt;
  &lt;RelativeHumidity&gt; 86%&lt;/RelativeHumidity&gt;
  &lt;Pressure&gt; 29.79 in. Hg (1008 hPa)&lt;/Pressure&gt;
  &lt;Status&gt;Success&lt;/Status&gt;
&lt;/CurrentWeather&gt;</a:GetWeatherResult></a:GetWeatherResp
onse></S:Body></S:Envelope>

  What I would like to do is "yank out" the second Xml file 
that is contained at 
S:Envelope/S:body/a:GetWeatherResponse/a:GetWeatherResult. 

  I tried the following Xslt code using the latest Altova engine

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; 
xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:XS="http://www.w3.org/2001/XMLSchema"; 
xmlns:XI="http://www.w3.org/2001/XMLSchema-instance"; 
xmlns:a="http://www.webserviceX.NET";>
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

  <xsl:template match="/">
    <NewRoot>
      <xsl:value-of 
select="/S:Envelope/S:Body/a:GetWeatherResponse/a:GetWeatherResult"/>
    </NewRoot>
  </xsl:template>

  <xsl:template match="@*|node()">
    <xsl:copy>
      <xsl:apply-templates select="@*|node()"/>
    </xsl:copy>
  </xsl:template>

</xsl:stylesheet>

  What I get back is 

<?xml version="1.0" encoding="UTF-8"?>
<NewRoot xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:XI="http://www.w3.org/2001/XMLSchema-instance"; 
xmlns:XS="http://www.w3.org/2001/XMLSchema"; 
xmlns:a="http://www.webserviceX.NET";>&lt;?xml version="1.0" 
encoding="utf-16"?&gt; &lt;CurrentWeather&gt;
  &lt;Location&gt;Montreal / Pierre Elliot Trudeau 
International Airport, Que, Canada (CYUL) 45-28N 073-45W 
36M&lt;/Location&gt;
  &lt;Time&gt;Apr 04, 2007 - 11:00 AM EDT / 2007.04.04 1500 
UTC&lt;/Time&gt;
  &lt;Wind&gt; from the ESE (120 degrees) at 15 MPH (13 KT) 
gusting to 28 MPH (24 KT):0&lt;/Wind&gt;
  &lt;Visibility&gt; 6 mile(s):0&lt;/Visibility&gt;
  &lt;SkyConditions&gt; overcast&lt;/SkyConditions&gt;
  &lt;Temperature&gt; 37 F (3 C)&lt;/Temperature&gt;
  &lt;DewPoint&gt; 33 F (1 C)&lt;/DewPoint&gt;
  &lt;RelativeHumidity&gt; 86%&lt;/RelativeHumidity&gt;
  &lt;Pressure&gt; 29.79 in. Hg (1008 hPa)&lt;/Pressure&gt;
  &lt;Status&gt;Success&lt;/Status&gt;
&lt;/CurrentWeather&gt;</NewRoot>

  What I would actually like to be returned is a true XML 
file where I could access all the nodes using Xpath, not a 
"parsed out" version of the file. 

  For example

  <?xml version="1.0" encoding="utf-8" ?>
  <NewRoot>
  <CurrentWeather>
  <Location>Montreal / Pierre Elliot Trudeau International 
Airport, Que, Canada (CYUL) 45-28N 073-45W 36M</Location>
  <Time>Apr 04, 2007 - 11:00 AM EDT / 2007.04.04 1500 UTC</Time>
  <Wind>from the ESE (120 degrees) at 15 MPH (13 KT) gusting 
to 28 MPH (24 KT):0</Wind>
  <Visibility>6 mile(s):0</Visibility>
  <SkyConditions>overcast</SkyConditions>
  <Temperature>37 F (3 C)</Temperature>
  <DewPoint>33 F (1 C)</DewPoint>
  <RelativeHumidity>86%</RelativeHumidity>
  <Pressure>29.79 in. Hg (1008 hPa)</Pressure>
  <Status>Success</Status>
  </CurrentWeather>
  </NewRoot>

  There are a few differences that I would also like, I don't 
need the namespace declarations. Is there anyway to do this 
using xslt or am I dreaming?

Thanks in advance.

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--