查询多条数据接口

简介

通过查询多条数据接口，可以一次查询表单中的多条数据。参数中字段既可以使用原名也可以使用别名。

开发前，请仔细阅读 开发指南。

接口调用

请求地址：POST /Customized/Form/{FormId}/Data/List

请求参数：

参数	类型	必需	说明
FormId	Guid	是	表单Id
Conditions	JSON	否	数据过滤条件
OrderBy	String	否	按指定字段名称排序
Include	String	否	指定为total可返回全部记录数
Skip	Number	否	跳过记录数
Take	Number	否	指定获取记录数
ReturnFieldAlias	boolean	否	返回值使用字段别名

请求示例：

POST /Customized/Form/07f16f04-df95-4e96-8f06-875d1fd378ae/Data/List
Headers:
{
  "conditions": "[{\"field\":\"input_1709522214384\",\"type\":\"input\",\"label\":\"单行文本\",\"opt\":\"Equal\",\"val\":\"11\"}]",
  "include": "total",
  "orderby": "-createdTime",
  "skip": 0,
  "take": 20,
  "returnFieldAlias": false
}

返回内容：

参数	类型	说明
offset	Number	从第0条结果的偏移量
total	Number	符合条件的数据条数
results	JSON Array	表单数据集合

返回示例（字段原名）：

{
  "offset": 0,
  "total": 1,
  "results": [
    {
      "CreatedByName": "Lily Wang",
      "ModifiedByName": "Lily Wang",
      "SubmittedByName": "Lily Wang",
      "Id": "21881484-8483-45c2-96b8-6fddf2eb06f3",
      "FormId": "07f16f04-df95-4e96-8f06-875d1fd378ae",
      "CreatedBy": "264fcf80-970c-4001-adac-0bf65d7d1954",
      "CreatedTime": "1688544927",
      "ModifiedBy": "264fcf80-970c-4001-adac-0bf65d7d1954",
      "ModifiedTime": "1688544967",
      "SerialNo": "H0150172023070500001",
      "Status": 2,
      "SubmitedBy": "264FCF80-970C-4001-ADAC-0BF65D7D1954",
      "SubmitedTime": "1688544967",
      "select_1680165983154": {
        "value": "91e66e40-ea05-4905-a472-09cc5f497082",
        "label": "已审批"
      },
      "input_1679974929547": "西南_SE",
      "input_1679975307546": "5017",
      "select_1680588945496": {
        "value": "key 1",
        "label": "是",
        "color": {
          "backgroundColor": "#577eff",
          "foreColor": "#ffffff"
        }
      },
      "input_1679975610080": "买赠",
      "input_1679975626936": "01",
      "input_1686031866467": "营销费",
      "input_1679971432166": "E3活动",
      "employeeSelect_1679973163935": {
        "value": "11018838",
        "label": "Lily Wang",
        "code": "11018838",
        "type": "userName"
      }
    }
  ]
}

返回示例（字段别名）：

{
  "offset": 0,
  "total": 1,
  "results": [
    {
      "CreatedByName": "Lily Wang",
      "ModifiedByName": "Lily Wang",
      "SubmittedByName": "Lily Wang",
      "Id": "21881484-8483-45c2-96b8-6fddf2eb06f3",
      "FormId": "07f16f04-df95-4e96-8f06-875d1fd378ae",
      "CreatedBy": "264fcf80-970c-4001-adac-0bf65d7d1954",
      "CreatedTime": "1688544927",
      "ModifiedBy": "264fcf80-970c-4001-adac-0bf65d7d1954",
      "ModifiedTime": "1688544967",
      "SerialNo": "H0150172023070500001",
      "Status": 2,
      "SubmitedBy": "264FCF80-970C-4001-ADAC-0BF65D7D1954",
      "SubmitedTime": "1688544967",
      "审批状态": {
        "value": "91e66e40-ea05-4905-a472-09cc5f497082",
        "label": "已审批"
      },
      "区域": "西南_SE",
      "区域编码": "5017",
      "是否发起": {
        "value": "key 1",
        "label": "是",
        "color": {
          "backgroundColor": "#577eff",
          "foreColor": "#ffffff"
        }
      },
      "类型": "买赠",
      "input_1679975626936": "01",
      "费用类型": "营销费",
      "活动类型": "E3活动",
      "employeeSelect_1679973163935": {
        "value": "11018838",
        "label": "Lily Wang",
        "code": "11018838",
        "type": "userName"
      }
    }
  ]
}