Groovy or XSLT to remove XML Tag(not values) in sap cpi payload

[nidhi_srivastava22]

Hi Experts,

I have a XML payload from which I need to remove only the XML tag and the values should pass to the parent tag. Sample payload mentioned below -

I tried few groovy functions mentioned on the community but that is replacing the entire <AdditionalComments/> tag to blank which is not expected.

Please help me if we can take this with groovy or I need to go with XSLT?

Thanks.

Best Regards,

Nidhi Srivastava

[Ryan-Crosby]

Very simple with XSLT...

[nageshrao]

Hi Nidhi, 

Below XSLT will achieve the result you want

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
    
    <!-- Identity transform using xsl:mode -->
    <xsl:mode on-no-match="shallow-copy"/>
    
    <!-- Special handling for AdditionalComments -->
    <xsl:template match="AdditionalComments">
        <xsl:copy>
            <xsl:value-of select="div"/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>

[nidhi_srivastava22]

Hi Nagesh,

Thanks for your help. This code works fine, but it fails when there is assigned to field sent.

<AssignedTo>ABC XYZ <ABC.XYZ@gmail.com></AssignedTo>

Error Details

net.sf.saxon.trans.XPathException: Error reported by XML parser: Unexpected character '@' (code 64) expected space, or '>' or "/>" at [row,col {unknown-source}]: [6,49}

Can we format the XSLT like to check only in AdditionalComments field if that is present or ignore the AssignedTo field for the check?

Thanks,

Nidhi Srivastava

[nageshrao]

Hello Nidhi,
The error occurs because the email address in the AssignedTo field contains the '@' character, which is not valid in XML content outside of attributes.
Assuming you will get this '@' only in the field - "AssignedTo" we can update the XSLT to ignore that as below 

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
    
    <!-- Identity transform using xsl:mode -->
    <xsl:mode on-no-match="shallow-copy"/>
    
    <!-- Special handling for AdditionalComments -->
    <xsl:template match="AdditionalComments">
        <xsl:copy>
            <xsl:value-of select="div"/>
        </xsl:copy>
    </xsl:template>

    <!-- Explicitly copy AssignedTo without changes -->
    <xsl:template match="AssignedTo">
        <xsl:copy-of select="."/>
    </xsl:template>

</xsl:stylesheet>

[nidhi_srivastava22]

Hi Nagesh,

I tried this but still it is not working. I also tried to keep the explicit copy in order but still it is showing the same error.

Thanks for your advise.

Best Regards,

Nidhi Srivastava

[nageshrao]

Hi Nidhi,Can you please paste the complete sample source XML ?

[nidhi_srivastava22]

Hi Nagesh,

PFB the source sample payload.

<?xml version='1.0' encoding='UTF-8'?>

<Root1>

    <Root2>

        <ADONumber>12345</ADONumber>

        <State></State>

        <AssignedTo>SRIVASTAVA Nidhi (External) <nidhi.srivastava.ext@XXXXX.eu> </AssignedTo>

            <Priority></Priority>

            <AdditionalComments></AdditionalComments>

        </Root2>

    </Root1>

Just discussed on the issue & was suggested with a workaround that instead of sending the full details I can only send the email id. 

<AssignedTo>nidhi.srivastava.ext@XXXXX.eu</AssignedTo> this can be added in the XSLT or can i add a groovy step before to remove the same.

Thanks a lot for your advice.

Regards,

Nidhi

[Ryan-Crosby]

@nidhi_srivastava22 That is not valid XML.