如何在XSLT中根据字段值跳过指定的CampaignTargetGroupMembers节点
XSLT XML映射修改方案
需求说明
仅当CampaignTargetGroupMembers节点下,AttributeId取值为DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-SMTP_ADDR的TargetGroupMemberAttributeData节点对应的Value不为空时,才复制该CampaignTargetGroupMembers节点及其子节点,并按照规则替换字段名。
输入XML内容
<?xml version='1.0' encoding='UTF-8'?> <root> <d> <Campaign> <CampaignId>0000000112</CampaignId> <Name>Connected Water DMI Fail Test</Name> <MarketingAreaId>CXXGLOBAL</MarketingAreaId> <SegmentationObject>SAP_CONTACT_ENGAGEMENT_SIN</SegmentationObject> <ImplementationId>ZOC_EXPORT_ACOUSTIC</ImplementationId> </Campaign> <PackageId>47</PackageId> <ExecutionStartDateTime>2021-06-30T15:28:49Z</ExecutionStartDateTime> <ExecutionRunKey>42010A0350331EDBB6B6EDEF969FD623</ExecutionRunKey> <CampaignTargetGroupMembers> <OutboundId>A071C1B1F437B581DC597E5116B38BED039CA864</OutboundId> <PackageId>47</PackageId> <ExecutionRunKey>42010A0350331EDBB6B6EDEF969FD623</ExecutionRunKey> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-SMTP_ADDR</AttributeId> <Value></Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>A071C1B1F437B581DC597E5116B38BED039CA864</OutboundId> </TargetGroupMemberAttributeData> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_LAST</AttributeId> <Value>Bailey</Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>A071C1B1F437B581DC597E5116B38BED039CA864</OutboundId> </TargetGroupMemberAttributeData> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_FIRST</AttributeId> <Value>Chandler</Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>A071C1B1F437B581DC597E5116B38BED039CA864</OutboundId> </TargetGroupMemberAttributeData> </CampaignTargetGroupMembers> <CampaignTargetGroupMembers> <OutboundId>E6713D258EAC1ADACE6AC905BB3ECF5E1CEF4776</OutboundId> <PackageId>47</PackageId> <ExecutionRunKey>42010A0350331EDBB6B6EDEF969FD623</ExecutionRunKey> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-SMTP_ADDR</AttributeId> <Value>rcgrymm@gmail.com</Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>E6713D258EAC1ADACE6AC905BB3ECF5E1CEF4776</OutboundId> </TargetGroupMemberAttributeData> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_LAST</AttributeId> <Value>Carmona</Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>E6713D258EAC1ADACE6AC905BB3ECF5E1CEF4776</OutboundId> </TargetGroupMemberAttributeData> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_FIRST</AttributeId> <Value>Ruben</Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>E6713D258EAC1ADACE6AC905BB3ECF5E1CEF4776</OutboundId> </TargetGroupMemberAttributeData> </CampaignTargetGroupMembers> </d> </root>
现有待修改的XSLT代码
<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template> <xsl:variable name="campaign" select="root/d/Campaign/CampaignId/text()" /> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_FIRST']"> <FIRST_NAME><xsl:value-of select="Value"/></FIRST_NAME> </xsl:template> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_LAST']"> <LAST_NAME><xsl:value-of select="Value" /></LAST_NAME> <xsl:template match="CampaignTargetGroupMembers/ExecutionRunKey"> <CAMPAIGN_ID><xsl:copy-of select="$campaign"/></CAMPAIGN_ID> </xsl:template> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='OUTBOUND_INTERACTION']"> <UUID><xsl:value-of select="Value" /></UUID> </xsl:template> </xsl:stylesheet>
预期输出XML结构
<?xml version="1.0" encoding="UTF-8"?><root> <d> <Campaign> <CampaignId>0000000112</CampaignId> <Name>Connected Water DMI Fail Test</Name> <MarketingAreaId>CXXGLOBAL</MarketingAreaId> <SegmentationObject>SAP_CONTACT_ENGAGEMENT_SIN</SegmentationObject> <ImplementationId>ZOC_EXPORT_ACOUSTIC</ImplementationId> </Campaign> <PackageId>47</PackageId> <ExecutionStartDateTime>2021-06-30T15:28:49Z</ExecutionStartDateTime> <ExecutionRunKey>42010A0350331EDBB6B6EDEF969FD623</ExecutionRunKey> <CampaignTargetGroupMembers> <OutboundId>E6713D258EAC1ADACE6AC905BB3ECF5E1CEF4776</OutboundId> <PackageId>47</PackageId> <CAMPAIGN_ID>0000000112</CAMPAIGN_ID> <Email>rcgrymm@gmail.com</Email> <LAST_NAME>Carmona</LAST_NAME> <FIRST_NAME>Ruben</FIRST_NAME> <TargetGroupMemberAttributeData> <AttributeId>DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-INITIATIVE_ID</AttributeId> <Value>0000000105,0000000092,0000000041,,0000000054,0000000076</Value> <EdmTypeId>Edm.String</EdmTypeId> <OutboundId>E6713D258EAC1ADACE6AC905BB3ECF5E1CEF4776</OutboundId> </TargetGroupMemberAttributeData> </CampaignTargetGroupMembers> </d> </root>
最终修正后的XSLT代码
主要修改点:
- 新增
CampaignTargetGroupMembers过滤规则,仅保留SMTP地址不为空的节点 - 补充SMTP地址字段的转换模板,转换为
<Email>标签 - 修复原有XSLT中遗漏的标签闭合问题
- 保留原有其余字段转换规则
<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template> <!-- 过滤掉SMTP地址为空的CampaignTargetGroupMembers节点 --> <xsl:template match="CampaignTargetGroupMembers[not(TargetGroupMemberAttributeData[AttributeId='DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-SMTP_ADDR']/Value/text())]" /> <xsl:variable name="campaign" select="root/d/Campaign/CampaignId/text()" /> <!-- 转换SMTP地址为Email标签 --> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-SMTP_ADDR']"> <Email><xsl:value-of select="Value"/></Email> </xsl:template> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_FIRST']"> <FIRST_NAME><xsl:value-of select="Value"/></FIRST_NAME> </xsl:template> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='DA-_SAP_CF_CE_CONTACT_IA_ERP_CUST-NAME_LAST']"> <LAST_NAME><xsl:value-of select="Value" /></LAST_NAME> </xsl:template> <xsl:template match="CampaignTargetGroupMembers/ExecutionRunKey"> <CAMPAIGN_ID><xsl:copy-of select="$campaign"/></CAMPAIGN_ID> </xsl:template> <xsl:template match="TargetGroupMemberAttributeData[AttributeId='OUTBOUND_INTERACTION']"> <UUID><xsl:value-of select="Value" /></UUID> </xsl:template> </xsl:stylesheet>
内容的提问来源于stack exchange,提问作者shibu
相关产品推荐
相关产品推荐

