3.批量更新-高级筛选器

POST

/openapi/v2/app/form/advance/data_updateBatch

查询应用中入库表，产品批次等于20220215，仓库名包含仓库的记录将仓库名修改为仓库Y5。
高级筛选：可以对多个查询条件进行分组，每一个条件组之间为or的关系，每个条件组内为and的关系。,高级筛选不进行空值跳过，

请求参数

Header 参数

Body 参数application/json

示例

{
     "appId":"620b446ee4b0dbc2f97d8210",
    "formId":"620b4b41e4b0dbc2f97d85f2",
    "currentPage": 1,
    "pageSize": 20,
    "sortList": [
        {
            "fieldId": "applyTime",
            "direction": "desc"
        }
    ],
    "filterInfoList": [
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "20220215"
                    ],
                    "field": "chanpinpici",
                    "fixedValue": "fixed_value"
                },
                {
                    "method": "like",
                    "value": [
                        "仓库"
                    ],
                    "field": "cangkuming",
                    "fixedValue": "fixed_value"
                }
            ]
        },
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "20220215"
                    ],
                    "field": "chanpinpici",
                    "fixedValue": "fixed_value"
                },
                {
                    "method": "like",
                    "value": [
                        "西安"
                    ],
                    "field": "cangkuming",
                    "fixedValue": "fixed_value"
                }
            ]
        },
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "RUNNING"
                    ],
                    "field": "formRunStatus",
                    "fixedValue": "fixed_value"
                }
            ]
        }
    ],
    "data": {
        "cangkuming": "仓库Y5"
    },
    "mutiHandle": "NO"
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://api.pro.surongyun.cn/apaas/openapi/v2/app/form/advance/data_updateBatch' \
--header 'Authorization: {{auth}}' \
--header 'accept: application/json, text/plain, */*' \
--header 'x-apaas-accessToken;' \
--header 'content-type: application/json;charset=UTF-8' \
--data-raw '{
     "appId":"620b446ee4b0dbc2f97d8210",
    "formId":"620b4b41e4b0dbc2f97d85f2",
    "currentPage": 1,
    "pageSize": 20,
    "sortList": [
        {
            "fieldId": "applyTime",
            "direction": "desc"
        }
    ],
    "filterInfoList": [
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "20220215"
                    ],
                    "field": "chanpinpici",
                    "fixedValue": "fixed_value"
                },
                {
                    "method": "like",
                    "value": [
                        "仓库"
                    ],
                    "field": "cangkuming",
                    "fixedValue": "fixed_value"
                }
            ]
        },
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "20220215"
                    ],
                    "field": "chanpinpici",
                    "fixedValue": "fixed_value"
                },
                {
                    "method": "like",
                    "value": [
                        "西安"
                    ],
                    "field": "cangkuming",
                    "fixedValue": "fixed_value"
                }
            ]
        },
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "RUNNING"
                    ],
                    "field": "formRunStatus",
                    "fixedValue": "fixed_value"
                }
            ]
        }
    ],
    "data": {
        "cangkuming": "仓库Y5"
    },
    "mutiHandle": "NO"
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "code": 0,
    "msg": "success",
    "result": null,
    "resultInfo": null
}

修改于 2023-01-13 10:37:04

2.批量更新-简单筛选器

4.批量更新-条件批量更新数据