You need to enable JavaScript to run this app. 如何在XSLT中根据字段值跳过指定的CampaignTargetGroupMembers节点
优惠活动
大模型
产品
解决方案
定价
更多

如何在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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.13 18:36:01