removing namespace aliases from xml

Question

I need to remove namespace aliases from an xml. This xml is being received from a backend service (different responses can have different structures) and needs to be converted to Json format finally. Hence i'm looking for a generic XSLT to remove namespace aliases from xml before i convert it to Jsonx and then Json.

XML i currently have:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <ns4:policySnapshotResponse xmlns="http://www.aig.com/ACORD1/xml/" xmlns:ns4="http://www.aig.com/gct/services/PolicyInquiryServiceV1.0" xmlns:ns2="http://www.ACORD.org/standards/PC_Surety/ACORD1/xml/" xmlns:ns3="http://www.aig.com/gct/services/commonHeaderV1.0">
         <ns4:requestHeader>
            <ns3:id>Spoofy</ns3:id>
            <ns3:requestApplicationID/>
            <ns3:requestMessageID/>
            <ns3:echoBack>false</ns3:echoBack>
         </ns4:requestHeader>
         <ns4:applicationContext>
            <ns3:businessSegment>CL</ns3:businessSegment>
            <ns3:region>ALL</ns3:region>
            <ns3:knowledgeDate>2015-05-24</ns3:knowledgeDate>
            <ns3:country>IE</ns3:country>
            <ns3:language>en</ns3:language>
            <ns3:lineOfBusiness>aig:CAUSC</ns3:lineOfBusiness>
            <ns3:subLineOfBusiness>AUTOP</ns3:subLineOfBusiness>
            <ns3:systemDate>2015-06-03</ns3:systemDate>
            <ns3:targetSystemName>GOALD</ns3:targetSystemName>
         </ns4:applicationContext>
         <ns4:PolicyInqRs>
            <ns2:PolInfo>
               <ns2:CommlPropertyPolicy>
                  <ns2:CommlPolicy/>
               </ns2:CommlPropertyPolicy>
            </ns2:PolInfo>
         </ns4:PolicyInqRs>
      </ns4:policySnapshotResponse>
   </soapenv:Body>
</soapenv:Envelope>

Xml i need without namespacesand soap envelope:

<policySnapshotResponse>
       <requestHeader>
          <id>Spoofy</id>
          <requestApplicationID/>
          <requestMessageID/>
          <echoBack>false</echoBack>
       </requestHeader>
       <applicationContext>
          <businessSegment>CL</businessSegment>
          <region>ALL</region>
          <knowledgeDate>2015-05-24</knowledgeDate>
          <country>IE</country>
          <language>en</language>
          <lineOfBusiness>aig:CAUSC</lineOfBusiness>
          <subLineOfBusiness>AUTOP</subLineOfBusiness>
          <systemDate>2015-06-03</systemDate>
          <targetSystemName>GOALD</targetSystemName>
       </applicationContext>
       <PolicyInqRs>
          <PolInfo>
             <CommlPropertyPolicy>
                <CommlPolicy/>
             </CommlPropertyPolicy>
          </PolInfo>
       </PolicyInqRs>
    </policySnapshotResponse>

I am converting ths xml further to jsonx and then to json.

score 0 · Answer 1 · answered Jun 03 '15 at 08:37

Try this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;
using System.Text.RegularExpressions;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            string input = 
                "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
                   "<soapenv:Body>" +
                      "<ns4:policySnapshotResponse xmlns=\"http://www.aig.com/ACORD1/xml/\" xmlns:ns4=\"http://www.aig.com/gct/services/PolicyInquiryServiceV1.0\" xmlns:ns2=\"http://www.ACORD.org/standards/PC_Surety/ACORD1/xml/\" xmlns:ns3=\"http://www.aig.com/gct/services/commonHeaderV1.0\">" +
                         "<ns4:requestHeader>" +
                            "<ns3:id>Spoofy</ns3:id>" +
                            "<ns3:requestApplicationID/>" +
                            "<ns3:requestMessageID/>" +
                            "<ns3:echoBack>false</ns3:echoBack>" +
                         "</ns4:requestHeader>" +
                         "<ns4:applicationContext>" +
                            "<ns3:businessSegment>CL</ns3:businessSegment>" +
                            "<ns3:region>ALL</ns3:region>" +
                            "<ns3:knowledgeDate>2015-05-24</ns3:knowledgeDate>" +
                            "<ns3:country>IE</ns3:country>" +
                            "<ns3:language>en</ns3:language>" +
                            "<ns3:lineOfBusiness>aig:CAUSC</ns3:lineOfBusiness>" +
                            "<ns3:subLineOfBusiness>AUTOP</ns3:subLineOfBusiness>" +
                            "<ns3:systemDate>2015-06-03</ns3:systemDate>" +
                            "<ns3:targetSystemName>GOALD</ns3:targetSystemName>" +
                         "</ns4:applicationContext>" +
                         "<ns4:PolicyInqRs>" +
                            "<ns2:PolInfo>" +
                               "<ns2:CommlPropertyPolicy>" +
                                  "<ns2:CommlPolicy/>" +
                               "</ns2:CommlPropertyPolicy>" +
                            "</ns2:PolInfo>" +
                         "</ns4:PolicyInqRs>" +
                      "</ns4:policySnapshotResponse>" +
                   "</soapenv:Body>" +
                "</soapenv:Envelope>";

            string pattern = "(</?)([^:]*:)";
            Regex expr = new Regex(pattern);
            input = expr.Replace(input, "$1");

            XDocument doc = XDocument.Parse(input);
            XElement element = doc.Descendants().Where(x => x.Name.LocalName == "policySnapshotResponse").FirstOrDefault();
            foreach (XAttribute attribute in element.Attributes().ToList())
            {
                attribute.Remove();
            }
            doc = XDocument.Parse(element.ToString());

        }
    }
}

score 0 · Answer 2 · answered Jun 03 '15 at 09:57

@jdwend

Hi thanks for the reply. i got the desired result by using the following method:

below is the template i am using to convert the xml to jsonx, i changed name to local-name at the appropriate places and got the desired output.

<xsl:output method="xml" indent="yes" encoding="UTF-8" omit-xml-declaration="yes"/>
   <xsl:strip-space elements="*"/>
   <!--Array-->
   <xsl:template match="*[*[2]][local-name(*[1])=local-name(*[2])]">
      <json:object name="{local-name()}">
         <json:array name="{local-name(*[1])}">
            <xsl:apply-templates/>
         </json:array>
      </json:object>
   </xsl:template>
   <!--Array member-->
   <xsl:template match="*[parent::*[ local-name(*[1])=local-name(*[2]) ]] | /">
      <json:object>
         <xsl:apply-templates/>
      </json:object>
   </xsl:template>
   <!--Object-->
   <xsl:template match="*">
      <json:object name="{local-name()}">
         <xsl:apply-templates/>
      </json:object>
   </xsl:template>
   <!--String-->
   <xsl:template match="*[not(*)]">
      <json:string name="{local-name()}">
         <xsl:value-of select="."/>
      </json:string>
   </xsl:template>
</xsl:stylesheet>

removing namespace aliases from xml

2 Answers2

Linked