I'm using SAP CPI platform and I want to remove the parent node (payload) based on its grandchild nodes (localeId and translation). The input XML provided is like this:
<?xml version="1.0" encoding="UTF-8"?>
<root>
<payload>
<title>Doc1</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
<payload>
<title>Doc3</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 3</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 3</translation>
</localizedTitle>
</payload>
<payload>
<title>Doc4</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
</root>
I want to remove the payload nodes that its localeId != "es" and translation!= "Type 1" using Groovy.
The result will be like this (only Doc1 and Doc4 are correct):
<?xml version="1.0" encoding="UTF-8"?>
<root>
<payload>
<title>Doc1</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
<payload>
<title>Doc4</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
</root>
CodePudding user response:
Please try the following XSLT.
It is using a so called Identity Transform pattern.
Input XML
<?xml version="1.0" encoding="UTF-8"?>
<root>
<payload>
<title>Doc1</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
<payload>
<title>Doc3</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 3</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 3</translation>
</localizedTitle>
</payload>
<payload>
<title>Doc4</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
</root>
XSLT
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" encoding="utf-8" indent="yes" omit-xml-declaration="no"/>
<xsl:strip-space elements="*"/>
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="node()|@*"/>
</xsl:copy>
</xsl:template>
<xsl:template match="payload[localizedTitle/localeID!='es' and localizedTitle/translation!='Type 1']"/>
</xsl:stylesheet>
Output XML
<?xml version='1.0' encoding='utf-8' ?>
<root>
<payload>
<title>Doc1</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
<payload>
<title>Doc4</title>
<localizedTitle>
<localeID>es</localeID>
<translation>Type 1</translation>
</localizedTitle>
<localizedTitle>
<localeID>en</localeID>
<translation>Type 1</translation>
</localizedTitle>
</payload>
</root>