Search code examples
xsltxslt-1.0renamejsonx

Renaming duplicate array names in XSLT 1.0


I have below list with arrays having same name(json:array name="member"). I am trying to rename them something meaningful (json:array name="member1") so they remain unique values. I am trying to use identity template.

Input:

<json:object xmlns:json="http://www.ibm.com/xmlns/prod/2009/jsonx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <json:array xmlns:dpfunc="http://www.datapower.com/extensions/functions" xmlns:str="http://exslt.org/strings" name="benefits">
      <json:object>
         <json:string name="ArrayCode">A</json:string>
         <json:array name="member">
            <json:object>
               <json:string name="memberID">A-001</json:string>
            </json:object>
         </json:array>
         <json:array name="member">
            <json:object>
               <json:string name="memberID">A-002</json:string>
            </json:object>
         </json:array>
         <json:array name="member">
            <json:object>
               <json:string name="memberID">A-003</json:string>
            </json:object>
         </json:array>
      </json:object>
      <json:object>
         <json:string name="ArrayCode">B</json:string>
         <json:array name="member">
            <json:object>
               <json:string name="memberID">B-001</json:string>
            </json:object>
         </json:array>
         <json:array name="member">
            <json:object>
               <json:string name="memberID">B-002</json:string>
            </json:object>
         </json:array>
         <json:array name="member">
            <json:object>
               <json:string name="memberID">B-003</json:string>
            </json:object>
         </json:array>
      </json:object>
   </json:array>
</json:object>

Expected Output:

   <json:object xmlns:json="http://www.ibm.com/xmlns/prod/2009/jsonx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <json:array xmlns:dpfunc="http://www.datapower.com/extensions/functions" xmlns:str="http://exslt.org/strings" name="benefits">
      <json:object>
         <json:string name="ArrayCode">A</json:string>
         <json:array name="member1">
            <json:object>
               <json:string name="memberID">A-001</json:string>
            </json:object>
         </json:array>
         <json:array name="member2">
            <json:object>
               <json:string name="memberID">A-002</json:string>
            </json:object>
         </json:array>
         <json:array name="member3">
            <json:object>
               <json:string name="memberID">A-003</json:string>
            </json:object>
         </json:array>
      </json:object>
      <json:object>
         <json:string name="ArrayCode">B</json:string>
         <json:array name="member1">
            <json:object>
               <json:string name="memberID">B-001</json:string>
            </json:object>
         </json:array>
         <json:array name="member2">
            <json:object>
               <json:string name="memberID">B-002</json:string>
            </json:object>
         </json:array>
         <json:array name="member3">
            <json:object>
               <json:string name="memberID">B-003</json:string>
            </json:object>
         </json:array>
      </json:object>
   </json:array>
</json:object>

XSLT I tried with Identity template and for-each to loop through array list.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:date="http://exslt.org/dates-and-times" xmlns:dp="http://www.datapower.com/extensions" xmlns:dpfunc="http://www.datapower.com/extensions/functions" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:json="http://www.ibm.com/xmlns/prod/2009/jsonx" xmlns:str="http://exslt.org/strings" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0" xsi:schemaLocation="http://www.datapower.com/schemas/json jsonx.xsd" extension-element-prefixes="dp" exclude-result-prefixes="xsl fo xs fn dp date">
   
   <xsl:template match="@* | node()">
      <xsl:copy>
         <xsl:apply-templates select="@* | node()"/>
      </xsl:copy>
   </xsl:template>
   
   
   <xsl:template match="json:array/@name">
      <xsl:for-each select="json:object/json:array">
         <xsl:attribute name="@name{position()}">
            <xsl:value-of select="@name"/>
         </xsl:attribute>
      </xsl:for-each>  
   </xsl:template>
   
</xsl:stylesheet>

No change is happening to input with above code. I guess using for-each is wrong here. But how can I reach array names nested inside.


Solution

  • Perhaps

    <xsl:template match="json:array[@name = 'member']">
        <xsl:copy>
            <xsl:attribute name="name">
                <xsl:value-of select="@name"/>
                <xsl:number/>
            </xsl:attribute>
            <xsl:apply-templates/>
        </xsl:copy>
    </xsl:template>
    

    helps if you know the name of the array.