时间戳

首页 > 解决方案 > 使用适用于 wso2 esb 的任何脚本更改 wso2 esb 中 xml 的内部标记值或节点值

xml - 使用适用于 wso2 esb 的任何脚本更改 wso2 esb 中 xml 的内部标记值或节点值

问题描述

这是我的源 XML

<request>
<applicationVersion>agidmp-5.0.0.0</applicationVersion>
<serviceName>changeRequestService</serviceName>
<changes>
  <change>
    <entityName>ChangeRequest</entityName>
    <path>ChangeRequest--4</path>
    <operation>a</operation>
    <values>
      <changeRequestName>ChangeRequest-CR-007</changeRequestName>
      <changeRequestNumber>ChangeRequest-CR-007</changeRequestNumber>
      <changeRequestUID>ChangeRequest-CR-007</changeRequestUID>
      <productCategory>20984</productCategory>
      <requestCategory.recordId>20032</requestCategory.recordId>
      <sourceSystem.recordId>20048</sourceSystem.recordId>
      <scopeDescription> Minimum age limit:15Years</scopeDescription>
    </values>
  </change>
  <change>
    <entityName>ChangeRequestScopeCountry</entityName>
    <path>ChangeRequest--4.changeRequestCountryList--7</path>
    <operation>a</operation>
    <values>
      <country.recordId>IND</country.recordId>
    </values>
  </change>
  <change>
    <entityName>ChangeRequestScopeCountry</entityName>
    <path>ChangeRequest--4.changeRequestCountryList--8</path>
    <operation>a</operation>
    <values>
      <country.recordId>AFG</country.recordId>
    </values>
  </change>
  <change>
    <entityName>ChangeRequestScopeCountry</entityName>
    <path>ChangeRequest--4.changeRequestCountryList--9</path>
    <operation>a</operation>
    <values>
      <country.recordId>AUT</country.recordId>
    </values>
  </change>
  <change>
    <path>ChangeRequest--4.submissionRequestScopeStudyProgramList--5</path>
    <operation>a</operation>
    <entityName>SubmissionRequestScopeStudyAndProgram</entityName>
    <values>
      <invStudy.recordId>40037</invStudy.recordId>
    </values>
  </change>
</changes>

我想替换以下路径中的标签值：/soapenv:Body/request/changes/change/values/country.recordId

我尝试做丰富的调解员替换财产。但它不会更改我的源 XML 中的任何标记值。请建议任何方法来实现这个我的目标 xml 应该是 Like

<soapenv:Body xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope">
  <request>
    <applicationVersion>agidmp-5.0.0.0</applicationVersion>
    <serviceName>changeRequestService</serviceName>
    <changes>
      <change>
        <entityName>ChangeRequest</entityName>
        <path>ChangeRequest--4</path>
        <operation>a</operation>
        <values>
          <changeRequestName>ChangeRequest-CR-007</changeRequestName>
          <changeRequestNumber>ChangeRequest-CR-007</changeRequestNumber>
          <changeRequestUID>ChangeRequest-CR-007</changeRequestUID>
          <productCategory>20984</productCategory>
          <requestCategory.recordId>20032</requestCategory.recordId>
          <sourceSystem.recordId>20048</sourceSystem.recordId>
          <scopeDescription> Minimum age limit:15Years</scopeDescription>
        </values>
      </change>
      <change>
        <entityName>ChangeRequestScopeCountry</entityName>
        <path>ChangeRequest--4.changeRequestCountryList--7</path>
        <operation>a</operation>
        <values>
          <country.recordId>1234</country.recordId>
        </values>
      </change>
      <change>
        <entityName>ChangeRequestScopeCountry</entityName>
        <path>ChangeRequest--4.changeRequestCountryList--8</path>
        <operation>a</operation>
        <values>
          <country.recordId>1235</country.recordId>
        </values>
      </change>
      <change>
        <entityName>ChangeRequestScopeCountry</entityName>
        <path>ChangeRequest--4.changeRequestCountryList--9</path>
        <operation>a</operation>
        <values>
          <country.recordId>1236</country.recordId>
        </values>
      </change>
      <change>
        <path>ChangeRequest--4.submissionRequestScopeStudyProgramList--5</path>
        <operation>a</operation>
        <entityName>SubmissionRequestScopeStudyAndProgram</entityName>
        <values>
          <invStudy.recordId>40037</invStudy.recordId>
        </values>
      </change>
    </changes>
  </request>
</soapenv:Body>

是否可以通过添加一些 javascript 代码或在 wso2 调解器中使用 xQuery 来做到这一点。提前致谢。

标签： xmlxsltintegrationwso2esb

解决方案

正如您所指出的，上述解决方案不适用于您的特定用例，我使用 foreach 提出了不同的解决方案。

<proxy xmlns="http://ws.apache.org/ns/synapse" name="translate_landcodes" startOnLoad="true" statistics="disable" trace="disable" transports="http,https">
    <target>
        <inSequence>
            <foreach expression="//change">
                <sequence>
                    <filter xpath="//country.recordId">
                        <then>
                            <property expression="//country.recordId" name="landcode" scope="default" type="STRING"/>
                            <sequence key="get_landnumber"/>
                            <enrich>
                                <source clone="true" property="landnumber" type="property"/>
                                <target xpath="//country.recordId"/>
                            </enrich>
                        </then>
                    </filter>
                </sequence>
            </foreach>
            <respond/>
        </inSequence>
    </target>
    <description/>
</proxy>

我遇到了以下错误https://wso2.org/jira/browse/ESBJAVA-5227。这在 IE 6.20 及更高版本中已修复，但我通过将数据库调用移动到单独的序列来解决它：

<sequence name="get_landnumber" xmlns="http://ws.apache.org/ns/synapse">
    <dblookup>
        <connection>
            <pool>
                <dsName>jdbc/landcodes_db</dsName>
            </pool>
        </connection>
        <statement>
            <sql><![CDATA[select numbercode from translate where lettercode=?]]></sql>
            <parameter expression="get-property('landcode')"
                type="VARCHAR" xmlns:ns="http://org.apache.synapse/xsd"/>
            <result column="numbercode" name="landnumber"/>
        </statement>
    </dblookup>
</sequence>

请注意，您必须在配置/数据源中定义数据库连接。

推荐阅读