3.高级筛选-组合系统条件 - 速融云开放平台

请求参数

Header 参数

Body 参数application/json

示例

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

请求示例代码

Shell

JavaScript

Java

Swift

Go

PHP

Python

HTTP

C

C#

Objective-C

Ruby

OCaml

Dart

R

curl --location --request POST 'https://api.pro.surongyun.cn/apaas/openapi/v2/app/form/advance/data_filter' \
--header 'Authorization: {{auth}}' \
--header 'x-apaas-accessToken;' \
--header 'Content-Type: application/json' \
--data-raw '{
   
     "appId": "620b446ee4b0dbc2f97d8210",
    "formId": "620b4b41e4b0dbc2f97d85f2",
    "currentPage": 1,
    "pageSize": 20,
    "sortList": [
        {
            "fieldId": "applyTime",
            "direction": "desc"
        }
    ],
    "filterInfoList": [
        {
            "conditionList": [
               
                {
                    "method": "like",
                    "value": [
                        "仓库"
                    ],
                    "field": "cangkuming",
                    "fixedValue": "fixed_value"
                }
            ]
        },
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "20220215"
                    ],
                    "field": "chanpinpici",
                    "fixedValue": "fixed_value"
                }
            ]
        },
        {
            "conditionList": [
                {
                    "method": "eq",
                    "value": [
                        "RUNNING"
                    ],
                    "field": "formRunStatus",
                    "fixedValue": "fixed_value"
                }
            ]
        }
    ]
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "code": 0,
    "msg": "success",
    "result": {
        "currentPage": 1,
        "pageSize": 20,
        "totalPage": 1,
        "totalCount": 2,
        "timestamp": 0,
        "dataList": [
            {
                "recordId": "620de72ce4b0089e2a3febe4",
                "cangkuming": "仓库A",
                "zongjia": 0,
                "zongrukush": 0,
                "chanpinpici": "20220215",
                "yijian": "",
                "qianming": null,
                "rukzibiao": [
                    {
                        "pinming": "产品1",
                        "xiaoji": 1200,
                        "dizhi": {
                            "province": "陕西省",
                            "city": "西安市",
                            "county": "未央区",
                            "detailAddress": "谭家街道首府尚苑",
                            "longitude": 0,
                            "latitude": 0,
                            "location": {
                                "type": "Point",
                                "coordinates": [
                                    0,
                                    0
                                ]
                            }
                        },
                        "fujian": [
                            {
                                "fileName": "Xnip2020-07-23_16-41-05.png",
                                "fileSize": 173.76,
                                "fileUrl": "https://api.dev.161.54188.online/fs/file/download/341591079797129216",
                                "fileType": "image/png",
                                "id": "FILE_kd9uyulyLw0mZrR9"
                            }
                        ],
                        "tupian_link": [
                            "https://api.dev.161.54188.online/fs/file/download/341591100814786560"
                        ],
                        "tupian": [
                            {
                                "imgName": "Xnip2020-07-23_16-41-05.png",
                                "imgSize": 173.76,
                                "imgUrl": "https://api.dev.161.54188.online/fs/file/download/341591100814786560",
                                "id": "IMAGE_kd9uyyo7HIOzyKVS"
                            }
                        ],
                        "bianhao": "cp-0003",
                        "lianxiren": [
                            {
                                "userId": "61201",
                                "telephone": "18810358220",
                                "username": "闫红丽",
                                "headImg": "https://wework.qpic.cn/wwhead/duc2TvpEgSQgUKEe0Fda8oNDyiaNQtP5HNqFIrMmP7knicicKsAueBEJdPRhQjicv6EgicJIymqekGgs/0"
                            }
                        ],
                        "bumen": [
                            {
                                "depId": "1917",
                                "depName": "测试部"
                            }
                        ],
                        "rukushuliang": 6,
                        "beizhu": "产品1",
                        "xinghao": "xinghao",
                        "danjia": 200,
                        "fujian_link": [
                            "https://api.dev.161.54188.online/fs/file/download/341591079797129216"
                        ]
                    }
                ],
                "userId": 1002,
                "appId": "620b446ee4b0dbc2f97d8210",
                "formId": "620b4b41e4b0dbc2f97d85f2",
                "applyTime": 1645078316733,
                "updateTime": 1645078316733,
                "ipRelationAddress": {
                    "province": "陕西省",
                    "city": "西安市",
                    "county": "未央区",
                    "detailAddress": ""
                },
                "ipAddr": "1.83.33.180",
                "systemType": "Other",
                "deviceType": "Unknown",
                "browserType": "Other",
                "browserVersion": "",
                "isMobile": 0,
                "engineType": "Unknown",
                "engineVersion": "",
                "openId": "",
                "title": "入库表",
                "archiveStatus": "NO",
                "formRunStatus": "FINISH"
            },
            {
                "recordId": "620ccf6ce4b00334387e0345",
                "cangkuming": "仓库B",
                "zongjia": 1200,
                "zongrukush": 6,
                "chanpinpici": "20220215",
                "yijian": "",
                "qianming": "",
                "rukzibiao": [
                    {
                        "pinming": "产品2",
                        "xiaoji": 1200,
                        "dizhi": {
                            "province": "陕西省",
                            "city": "西安市",
                            "county": "未央区",
                            "detailAddress": "谭家街道首府尚苑",
                            "longitude": 0,
                            "latitude": 0,
                            "location": {
                                "type": "Point",
                                "coordinates": [
                                    0,
                                    0
                                ]
                            }
                        },
                        "fujian": [
                            {
                                "fileName": "Xnip2020-07-23_16-41-05.png",
                                "fileSize": 173.76,
                                "fileUrl": "https://api.dev.161.54188.online/fs/file/download/341591079797129216",
                                "fileType": "image/png",
                                "id": "FILE_kd9uyulyLw0mZrR9"
                            }
                        ],
                        "tupian_link": [
                            "https://api.dev.161.54188.online/fs/file/download/341591100814786560"
                        ],
                        "tupian": [
                            {
                                "imgName": "Xnip2020-07-23_16-41-05.png",
                                "imgSize": 173.76,
                                "imgUrl": "https://api.dev.161.54188.online/fs/file/download/341591100814786560",
                                "id": "IMAGE_kd9uyyo7HIOzyKVS"
                            }
                        ],
                        "bianhao": "cp-0003",
                        "lianxiren": [
                            {
                                "userId": "61201",
                                "telephone": "18810358220",
                                "username": "闫红丽",
                                "headImg": "https://wework.qpic.cn/wwhead/duc2TvpEgSQgUKEe0Fda8oNDyiaNQtP5HNqFIrMmP7knicicKsAueBEJdPRhQjicv6EgicJIymqekGgs/0"
                            }
                        ],
                        "bumen": [
                            {
                                "depId": "1917",
                                "depName": "测试部"
                            }
                        ],
                        "rukushuliang": 6,
                        "beizhu": "产品1",
                        "xinghao": "xinghao",
                        "danjia": 200,
                        "fujian_link": [
                            "https://api.dev.161.54188.online/fs/file/download/341591079797129216"
                        ]
                    },
                    {
                        "pinming": "产品3",
                        "xiaoji": 0,
                        "dizhi": {
                            "province": "",
                            "city": "",
                            "county": "",
                            "detailAddress": "",
                            "longitude": 0,
                            "latitude": 0,
                            "location": {
                                "type": "Point",
                                "coordinates": [
                                    0,
                                    0
                                ]
                            }
                        },
                        "fujian": [],
                        "tupian_link": [],
                        "tupian": [],
                        "bianhao": "CP-00001",
                        "lianxiren": [
                            {
                                "userId": "61201",
                                "telephone": "18810358220",
                                "username": "闫红丽",
                                "headImg": "https://wework.qpic.cn/wwhead/duc2TvpEgSQgUKEe0Fda8oNDyiaNQtP5HNqFIrMmP7knicicKsAueBEJdPRhQjicv6EgicJIymqekGgs/0"
                            }
                        ],
                        "bumen": [],
                        "rukushuliang": 0,
                        "beizhu": "产品2",
                        "xinghao": "xinghao2",
                        "danjia": 300,
                        "fujian_link": []
                    },
                    {
                        "pinming": "产品3",
                        "xiaoji": 0,
                        "dizhi": {
                            "province": "",
                            "city": "",
                            "county": "",
                            "detailAddress": "",
                            "longitude": 0,
                            "latitude": 0,
                            "location": {
                                "type": "Point",
                                "coordinates": [
                                    0,
                                    0
                                ]
                            }
                        },
                        "fujian": [],
                        "tupian_link": [],
                        "tupian": [],
                        "bianhao": "CP-00002",
                        "lianxiren": [],
                        "bumen": [],
                        "rukushuliang": 0,
                        "beizhu": "",
                        "xinghao": "xinghao3",
                        "danjia": 0,
                        "fujian_link": []
                    }
                ],
                "userId": 1002,
                "appId": "620b446ee4b0dbc2f97d8210",
                "formId": "620b4b41e4b0dbc2f97d85f2",
                "applyTime": 1645006700649,
                "updateTime": 1645070285981,
                "ipRelationAddress": {
                    "province": "陕西省",
                    "city": "西安市",
                    "county": "未央区",
                    "detailAddress": ""
                },
                "ipAddr": "1.83.33.180",
                "systemType": "Mac OS X",
                "deviceType": "Mac",
                "browserType": "Chrome",
                "browserVersion": "96.0.4664",
                "isMobile": 0,
                "engineType": "Webkit",
                "engineVersion": "537.36",
                "openId": "",
                "title": "入库表",
                "archiveStatus": "NO",
                "formRunStatus": "FINISH"
            }
        ]
    },
    "resultInfo": null
}