json - 在 json 数组上迭代 Mediator

Question

我想迭代 json 消息的结果数组

{ 
   "results":[ 
      { 
         "category":"mdl", 
         "subcategory":"ip", 
         "ip":"103.14.120.121", 
         "subtype":"IP-MDL", 
         "date":"1405074556", 
         "longitude":"75.3333", 
         "latitude":"19.8833", 
         "country":"India", 
         "city":"Aurangabad", 
         "organization":"Good Domain Registry Private Limited", 
         "isp":"Good Domain Registry Private Limited" 
      }, 
      { 
         "category":"mdl", 
         "subcategory":"ip", 
         "ip":"108.162.198.96", 
         "subtype":"IP-MDL", 
         "date":"1405074556", 
         "longitude":"-122.3933", 
         "latitude":"37.7697", 
         "country":"United States", 
         "city":"San Francisco", 
         "organization":"CloudFlare", 
         "isp":"CloudFlare" 
      } 
   ] 
} 

不幸的是，迭代中介似乎不接受非 xpath 表达式任何人都知道如何像我在 xml 中那样迭代以前的消息 json 结果？我想使用 ESB json-native 支持，但似乎无法像使用 XML 那样分解 json 消息(我尝试过迭代中介、json 有效负载工厂和脚本中介，但没有成功)

            <iterate expression="json-eval(results)"> 
               <target> 
                  <sequence> 
                     <property name="messageType" value="application/json" scope="axis2"/> 
                     <payloadFactory media-type="json"> 
<format> 
{ 
"event":{ 
"providerName":"$1", 
"providerSource":"$2", 
"providerClassification":"$3", 
"providerVersion":"$4", 
"body":{ 
"results":{$5} 
} 
} 
} 
</format> 
<args> 
                                <arg value="bdigital"/> 
                                <arg evaluator="json" expression="$.results.category"/> 
<arg evaluator="json" expression="$.results.subcategory"/> 
                                <arg value="1.0"/> 
                                <arg evaluator="json" expression="$.results"/> 
</args> 
</payloadFactory> 
                     <call> 
                        <endpoint> 
                           <http method="post" 
                                 uri-template="http://BD-VM-PP-CIC01:8280/services/CICQueue"/> 
                        </endpoint> 
                     </call> 
                  </sequence> 
               </target> 
            </iterate>

提前致谢

Answer 1

您可以执行以下操作吗？

<property name="messageType" value="application/xml" scope="axis2" type="STRING"></property>
      <iterate xmlns:ns="http://org.apache.synapse/xsd" continueParent="true" expression="//jsonObject/results" id="MyIterator">
         <target>
            <sequence>
               <property name="cat" expression="json-eval($.results.category)" type="STRING"></property>

等等