分页查询数据

1 请求地址

Request Method：POST
Request URL：{http}://{ip}:{port}/{lczServer}/oapi/lczCloudForm/dataQuery/pageQuery

2 请求体参数

{
  "header": {
      "authId":"用户凭证，用于接口权限认证",
      "targetVolume":"所属应用",
      "privilege_type":"认证类型",
      "validateVariants":"认证参数",
      "v":"加密传参"
   },
  "requestBody": {
      "currentPage": 0, //当前页码
      "fieldNames": [
        "string"
      ],
      "fileName": "string",
      "orders": [
        {
          "fieldName": "string",
          "order": "string"
        }
      ],
      "pageSize":0, //分页行数
      "wheres": [
        {
          "fieldName": "string",
          "op": "string",
          "vals": [
            "string"
          ]
        }
      ]
   }
}

op

IN
fieldName  in （参数值，参数值 ....）
NIN
fieldName  not in （参数值，参数值 ....）
LIKE
fieldName  like  （%参数值%）
NLIKE
fieldName  not like （%参数值%）
NULL
fieldName  is null
NNULL
fieldName  not null
BETWEEN
fieldName  between 参数值1 and 参数值2
EQ
fieldName  = 参数值
GT
fieldName  > 参数值
LT
fieldName  < 参数值
NEQ
fieldName  != 参数值
LEQ
fieldName  <= 参数值
GEQ
fieldName  >= 参数值

4 响应体

成功响应体格式如下:

{
  "content": {
    "currentPage": 0, //当前页
    "pageSize": 0,  //总页数
    "total": 0, //总条数
    "datas": [{
      "${fieldName1}": "",
      "${fieldName2}": 0,
      "${tableName1}": [{
        "${fieldName3}": "",
        "${fieldName4}": 0
      }],
      "${tableName2}": [{
        "${fieldName5}": "",
        "${fieldName6}": 0
      }]
    }]
  },
  "success": true
}

${fieldName}: 用户要查询的字段名称
${tableName}: 子表名称

失败响应体格式如下:

{
  "code": "string", //错误码
  "msg": "string",  //错误信息
  "success": false
}