查询数据

1 请求地址

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

2 请求体参数

{
  "header": {
      "authId":"用户凭证",
      "targetVolume":"所属应用",
      "privilege_type":"认证类型",
      "validateVariants":"认证参数",
      "v":"加密传参"
   },
  "requestBody": {
      "fileNames":["表单名称"],
      "fileName": "string",
      "orders": [
        {
          "fieldName": "string", //字段名称
          "order": "string" //排序方式(ASC或者DESC)
        }
      ],
      "wheres": [
        {
          "fieldName": "string",
          "op": "string",
          "vals": [
            "string"
          ]
        }
      ]
   }
}

必选参数

3 请求体

请求体格式如下:

{
  "fieldNames": [
    "string"
  ],
  "fileName": "string",
  "orders": [
    {
      "fieldName": "string",
      "order": "string"
    }
  ],
  "volumeName": "string",
  "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": {
    "datas": [{
      "${fieldName1}": "",
      "${fieldName2}": 0,
      "${tableName1}": [{
        "${fieldName3}": "",
        "${fieldName4}": 0
      }],
      "${tableName2}": [{
        "${fieldName5}": "",
        "${fieldName6}": 0
      }]
    }]
  },
  "success": true
}

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

失败响应体格式如下:

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