Apifox使用JSONPath和数据库获取变量

1.使用JSONPath的方法

根据个人需要，点击前置或者后置操作

如返回值是：

{
    "code": 200,
    "success": true,
    "data": [
        {
            "supplierName": "测试厂2",
            "supplierId": "1623230248944226306"
        },
        {
            "supplierName": "测试厂2",
            "supplierId": "1623230248944226306"
        },
        {
            "record": {
                "records": [
                    {
                        "id": "1740337982820651010",
                        "createUser": -1,
                        "createDept": -1,
                        "createTime": "",
                        "updateUser": -1,
                        "updateTime": "",
                        "status": 0,
                        "isDeleted": -1,
                        "plateNumber": "苏F00003",
                        "materialType": "5",
                        "supplierId": "",
                        "deliveryQuantity": -1,
                        "deliveryPic": "",
                        "openId": "",
                        "serialNumber": "",
                        "weighTime": "",
                        "commitTime": "2023-12-28 19:44:44",
                        "isCheck": 0,
                        "isIgnore": -1,
                        "orderType": -1,
                        "whiteInfoId": "",
                        "shippingInfoId": "",
                        "isCancel": -1
                    },

需要取苏F00003这个车牌号且isCheck=0的id

那么JSONPath表达式是：

$.data[2].record.records[?(@.isCheck == 0 && @.plateNumber == '苏F00003')].id

运行结果：

2.使用数据库方法

注意的是，配置数据库地址时，数据库名是指这个地址下的数据库名称，不要写错，写错就访问不了了