topic SAS Bi Web Services XML <axis2ns... in Developers

SAS Bi Web Services XML
Filipvdr — Wed, 17 Aug 2011 11:58:35 GMT

I have a stored process deployed as web service.
When I use soap to retrieve the Wsdl and to use the webservice i retrieve an XML file which looks like this:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <m:orSalesResponse xmlns:m="http://tempuri.org/orWS">
         <m:orSalesResult>
            <axis2ns128:Streams xmlns:axis2ns128="http://tempuri.org/orWS">
               <axis2ns129:_WEBOUT contentType="text/xml;charset=windows-1252" xmlns:axis2ns129="http://tempuri.org/orWS">
                  <axis2ns130:Value xmlns:axis2ns130="http://tempuri.org/orWS">
                     <TABLE>
                        <ORSALES>
                           <Product_Category>Assorted Sports Articles</Product_Category>
                           <Profit>9994898.76</Profit>
                        </ORSALES>
                        <ORSALES>
                           <Product_Category>Children Sports</Product_Category>
                           <Profit>2417119.78</Profit>
                        </ORSALES>
                        <ORSALES>
                           <Product_Category>Clothes</Product_Category>
                           <Profit>9208375.41</Profit>
                        </ORSALES>
                        <ORSALES>
next time i run it
            <axis2ns128:Streams xmlns:axis2ns128="http://tempuri.org/orWS">
               <axis2ns129:_WEBOUT contentType="text/xml;charset=windows-1252" xmlns:axis2ns129="http://tempuri.org/orWS">
                  <axis2ns130:Value xmlns:axis2ns130="http://tempuri.org/orWS">
but actually i want these axis2ns rules to be gone. any ideas?

SAS Bi Web Services XML
Filipvdr — Tue, 23 Aug 2011 06:52:56 GMT

no one??

SAS Bi Web Services XML
BrunoMueller — Fri, 09 Sep 2011 14:44:00 GMT

Hi Filipvdr
Check out the follwoing code below it uses Proc XSL (preproduction) to remove the names space information.
*
* remove name space stuff from XML response
*
* taken from http://wiki.tei-c.org/index.php/Remove-Namespaces.xsl
;
filename rmns temp;
data _null_;
infile cards;
input;
file rmns;
put _infile_;
cards4;
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output
method="xml"
indent="no"/>

<xsl:template
match="/|comment()|processing-instruction()">
<xsl:copy>
    <xsl:apply-templates/>
</xsl:copy>
</xsl:template>

<xsl:template match="">
<xsl:element
    name="{local-name()}">
    <xsl:apply-templates
      select="@|node()"/>
</xsl:element>
</xsl:template>

<xsl:template match="@">
<xsl:attribute
    name="{local-name()}">
    <xsl:value-of
      select="."/>
</xsl:attribute>
</xsl:template>
</xsl:stylesheet>
;;;;

*
* use XSL to remove namespace information
*;
filename xslout temp;
proc xsl
in=soapout
out=xslout
xsl=rmns
;
run;
Bruno