WSO2 REST API：如何在 GET 请求中返回多行

Question

您能否建议如何获得多行？ 我的 API 源：

<inSequence xmlns="http://ws.apache.org/ns/synapse">
<property expression="json-eval($.vendorId)" name="vendorId" scope="default" type="STRING"/>
  <dblookup>
        <connection>
            <pool>
                <dsName>MyDS</dsName>
            </pool>
        </connection>
        <statement>
            <sql><![CDATA[select * from db_view v where v.vendorId = nvl(?, v.vendorId)]]></sql>
            <parameter expression="$ctx:vendorId" type="VARCHAR"/>
            <result column="vendorId" name="vendorId"/>
            <result column="vendorName" name="vendorName"/>
        </statement>
    </dblookup>
    <filter xpath="boolean($ctx:vendorId)">
        <then>
            <payloadFactory media-type="json">
                <format>{"result":     { "vendorId" : "$1","vendorName" : "$2"}}</format>
                <args>
                    <arg evaluator="xml" expression="$ctx:vendorId" literal="false"/>
                    <arg evaluator="xml" expression="$ctx:vendorName" literal="false"/>
                </args>
            </payloadFactory>
        </then>
        <else>
            <payloadFactory media-type="json">
                <format>{"response" : { "code" : "01","message" : "fail"}}</format>
            </payloadFactory>
        </else>
    </filter>
</inSequence>

我的数据库视图返回 5 行，但我只从 GET 请求中获取第一行：

{"result": { "vendorId" : "123",        "vendorName" : "My Vendor N1"    }}

此外，如果我传递参数vendorId = 321，则 api 应返回 0 行。目前，它始终返回视图中的第一行。为什么以及如何让它发挥作用？ 预先感谢

CALLOUT 调解员：

<resource methods="GET" uri-template="/get/supplier/{filterQuery}">
      <inSequence>
         <property name="operation" value="view" scope="default" type="STRING"/>
         <log level="full" separator="|">
            <property name="operation" expression="get-property('operation')"/>
            <property name="step" value="request"/>
         </log>
         <property name="filterQuery" expression="get-property('uri.var.filterQuery')" scope="default" type="STRING"/>
         <log level="full" separator="|">
            <property name="filterQuery" expression="$ctx:filterQuery"/>
         </log>
         <callout serviceURL="http://...:8280/services/serviceName" action="/vendors/$ctx:filterQuery">
            <source type="envelope"/>
            <target key="response"/>
         </callout>
         <log level="custom" separator="|">
            <property name="MESSAGE" expression="$ctx:response"/>
         </log>
         <property name="res" expression="$ctx:response" scope="default" type="OM"/>
         <property name="NO_ENTITY_BODY" scope="axis2" action="remove"/>
         <property name="RESPONSE" value="true" scope="default" type="STRING"/>
         <property name="messageType" value="application/json" scope="axis2" type="STRING"/>
         <property name="contentType" value="application/json" scope="transport" type="STRING"/>
         <payloadFactory media-type="json">
            <format>{"vendorId": "$1","vendorName": "$2"}</format>
            <args/>
         </payloadFactory>
         <log level="full" separator="|">
            <property name="operation" expression="$ctx:operation"/>
            <property name="step" value="response"/>
         </log>
         <respond/>
      </inSequence>
      <faultSequence>
         <payloadFactory media-type="json">
            <format>{"response" : {"code" : "01", "message" : "fail"}}</format>
            <args/>
         </payloadFactory>
      </faultSequence>
   </resource>

Answer 1

您不能如上所述使用 dblookup madiator，但可以使用 数据源。
Get 方法数据服务的简要数据源示例；

<data name="RDBMSDataService" serviceStatus="active" transports="http https local">
   <config enableOData="false" id="Datasource">
      <property name="driverClassName">com.mysql.jdbc.Driver</property>
      <property name="url">jdbc:mysql://localhost:3306/Employees</property>
      <property name="username">root</property>
      <property name="password">password</property>
   </config>
   <resource method="GET" path="Employee/{EmployeeNumber}">
      <call-query href="GetEmployeeDetails">
         <with-param name="EmployeeNumber" query-param="EmployeeNumber"/>
      </call-query>
   </resource>
   <query id="GetEmployeeDetails" useConfig="Datasource">
      <sql>select EmployeeNumber, FirstName, LastName, Email, Salary from Employees where EmployeeNumber=:EmployeeNumber</sql>
      <result outputType="json">{
   "Employees":{
      "Employee":[
         {
            "EmployeeNumber":"$EmployeeNumber",
            "FirstName":"$FirstName",
            "LastName":"$LastName",
            "Email":"$Email",
            "Salary":"$Salary"
         }
      ]
   }
}</result>
      <param name="EmployeeNumber" sqlType="STRING"/>
   </query>
</data>

您可以创建此 .dbs 文件并部署它。然后您可以使用特定参数调用此组件，例如 http://localhost:8290/services/RDBMSDataService/Employee/{EmployeeNumber} ，然后它将返回 json ：

{
    "Employees": {
        "Employee": [
            {
                "EmployeeNumber": "5012",
                "FirstName": "Will",
                "LastName": "Smith",
                "Email": "[email protected]",
                "Salary": "13500.0"
            },
            {
                "EmployeeNumber": "5013",
                "FirstName": "Parker",
                "LastName": "Peter",
                "Email": "[email protected]",
                "Salary": "15500.0"
            }
        ]
    }
}

您可以从上下文中获取值，例如：

<property expression="json-eval($.Employees)" name="EmployeeList" scope="default" type="STRING"/>

Answer 2

这是正常行为。您可以在 DBLookup Mediator 文档 中阅读：

DBLookup 中介器可以设置结果集中一行的属性。 它不能返回多行。如果您需要获取多条记录，或者您有一个包含多个参数（例如 URL）的表，您可以使用 WSO2 数据服务服务器来创建数据服务并使用 Callout 中介器从 ESB 调用该服务。