主页 / coding / 问题 / 76922512
Accepted
Rajat Kumar
Asked: 2023-08-17 22:31:45 +0800 CST

如何使用XSLT 3.0关键功能

  • 772

我有一个包含国家/地区名称的源 XML 数据，我想将其替换为国家/地区代码。该国家可以是世界上的任何国家。我尝试使用 key 函数执行此操作，但它始终在最终 json 输出中给出 null 值。

=== 我的 Soap XML 数据 ===

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns="urn:enter.soap.force.com"
  xmlns:sf="urn:sobject.enter.soap.force.com"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <soapenv:Body>
    <queryMoreResponse>
      <result>
        <records xsi:type="sf:CaseData">
          <sf:Id>6896ADSD888</sf:Id>
          <sf:Number>123456666</sf:Number>
          <sf:ConsumerCountry>Australia</sf:ConsumerCountry>
        </records>
                <records xsi:type="sf:CaseData">
          <sf:Id>6896SDRGGG666</sf:Id>
          <sf:Number>123456666</sf:Number>
          <sf:ConsumerCountry>United States</sf:ConsumerCountry>
        </records>
      </result>
    </queryMoreResponse>
  </soapenv:Body>
</soapenv:Envelope>

我尝试过 3 个国家，可以扩展到 50 或 100 多个

=== 我的 XSLT 3.0 样式表 ====

<xsl:stylesheet version="3.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:sf="urn:sobject.enter.soap.force.com" xpath-default-namespace="urn:enter.soap.force.com"
  xmlns:mf="http://example.com/mf" exclude-result-prefixes="#all">
    
    
    <!-- starts: What I tried -->
  <xsl:key name="countryCodes" match="sf:country" use="sf:name" />
 
  <sf:country name="United States">US</sf:country>
  <sf:country name="Australia">AU</sf:country>
  <sf:country name="Germany">DE</sf:country>
    <!-- ends: What I tried -->
    
    <xsl:function name="mf:process-records" as="item()*">
        <xsl:param name="elements" as="element()*"/>
        <xsl:apply-templates select="$elements"/>
  </xsl:function>

  <xsl:output method="json" indent="yes"/>

  <xsl:template match="/soapenv:Envelope">
    <xsl:map>
      <xsl:map-entry key="'caserecords'" select="array { mf:process-records(soapenv:Body/queryMoreResponse/result/records) }"/>
    </xsl:map>
  </xsl:template>
    <xsl:template match="records">
        <xsl:map-entry key="'case'">
            <xsl:map>
                <xsl:map-entry key="'report'">
                        <xsl:map>
                            <xsl:map-entry key="'reportid'" select="string(sf:Id)"/>
                            <xsl:map-entry key="'reportnumber'" select="string(sf:Number)"/>
                            <!-- starts: What I tried -->
                            <xsl:variable name="countryName" select="string(sf:ConsumerCountry)" />
                            <xsl:variable name="countryCode" select="key('countryCodes', $countryName)" />
                            <xsl:map-entry key="'sourcecountry'" select="$countryCode"/>
                            <!-- ends: What I tried -->
                        </xsl:map>
                </xsl:map-entry>
            </xsl:map>
        </xsl:map-entry>
    </xsl:template>
</xsl:stylesheet>

预期输出

{
   "records": [
      {
         "case": {
            "safetyreport": {               
               "reportid": "6896ADSD888",
               "reportnumber": "123456666",
               "sourcecountry": "AU",
               
            }
         }
      },
            {
         "case": {
            "safetyreport": {               
               "reportid": "6896SDRGGG666",
               "reportnumber": "123456666",
               "sourcecountry": "US",
               
            }
         }
      },
   ]
}
json

2 个回答

  1. 考虑以下简化示例：

    <xsl:stylesheet version="3.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sf="urn:sobject.enter.soap.force.com"
xpath-default-namespace="urn:enter.soap.force.com"
xmlns:my="http://example.cpm/my"
exclude-result-prefixes="#all">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:key name="countryCode" match="my:country" use="@name" />

<xsl:variable name="countryCodes">
    <my:country name="United States">US</my:country>
    <my:country name="Australia">AU</my:country>
    <my:country name="Germany">DE</my:country>
</xsl:variable>

<xsl:template match="/soapenv:Envelope">
    <root>
        <xsl:apply-templates select="soapenv:Body/queryMoreResponse/result/records"/>
    </root>
</xsl:template>

<xsl:template match="records">
    <record>
        <country>
            <xsl:value-of select="sf:ConsumerCountry"/>
        </country>
        <countryCode>
            <xsl:value-of select="key('countryCode', sf:ConsumerCountry, $countryCodes)"/>
        </countryCode>
    </record>
</xsl:template>

</xsl:stylesheet>

    应用于您的输入示例，这将返回：

    <?xml version="1.0" encoding="UTF-8"?>
<root>
   <record>
      <country>Australia</country>
      <countryCode>AU</countryCode>
   </record>
   <record>
      <country>United States</country>
      <countryCode>US</countryCode>
   </record>
</root>
    • 1
  2. Best Answer

    我建议（假设您使用 XSLT 3 并且似乎想要定义国家/地区名称到内联代码的映射）声明一个全局映射参数，例如

    <xsl:param name="countryCodes" as="map(xs:string,xs:string)"
  select="map {
           'United States' : 'US',
           'Australia' : 'AU',
           'Germany' : 'DE'
         }"/>

    （在您的 XSLT 示例中，您需要声明前缀 xmlns:xs="http://www.w3.org/2001/XMLSchema"），然后使用例如

    <xsl:map-entry key="'sourcecountry'" select="$countryCodes(sf:ConsumerCountry)"/>
    • 0

相关问题