JSON 结构对比可运行案例
仓库库存:解释 balances 首部插入导致的多处差异
数组按下标逐项比较。在 balances 开头插入记录后,后续元素位置移动,会产生多处修改和一个尾部新增;这不等于多条业务记录都发生了真实字段变更。需要按 ID 配对时应先在自己的业务逻辑中处理。
试一试
在完整工具中打开 ↗示例工作台
JSON 结构对比修改下方数据后重新运行
运行结果
[
{
"op": "replace",
"path": "/data/balances/0/itemCode",
"oldValue": "demo-inventory-1",
"value": "demo-inserted"
},
{
"op": "replace",
"path": "/data/balances/0/itemName",
"oldValue": "演示物料甲",
"value": "新增演示记录"
},
{
"op": "replace",
"path": "/data/balances/1/itemCode",
"oldValue": "demo-inventory-2",
"value": "demo-inventory-1"
},
{
"op": "replace",
"path": "/data/balances/1/itemName",
"oldValue": "演示物料乙",
"value": "演示物料甲"
},
{
"op": "replace",
"path": "/data/balances/1/available",
"oldValue": 6,
"value": 120
},
{
"op": "replace",
"path": "/data/balances/1/reserved",
"oldValue": false,
"value": true
},
{
"op": "replace",
"path": "/data/balances/1/warehouse",
"oldValue": "west",
"value": "east"
},
{
"op": "replace",
"path": "/data/balances/1/location/zone",
"oldValue": "B",
"value": "A"
},
{
"op": "replace",
"path": "/data/balances/1/location/bins/0",
"oldValue": "B-03",
"value": "A-01"
},
{
"op": "add",
"path": "/data/balances/1/location/bins/1",
"value": "A-02"
},
{
"op": "add",
"path": "/data/balances/2",
"value": {
"itemCode": "demo-inventory-2",
"itemName": "演示物料乙",
"available": 6,
"reserved": false,
"warehouse": "west",
"location": {
"zone": "B",
"bins": [
"B-03"
]
}
}
}
]原例已核验,可修改输入后重新运行。
⌘ / Ctrl + Enter 运行01
场景与操作说明
库存接口可能同时返回仓库、库位和可用数量。对比数据前先固定仓库口径,不能把不同仓库的同一物料视作一条记录。
available 表示本例可用件数;reserved 是布尔演示标记,不是预占数量。
- 核对 仓库库存 的字段层级,保留 itemCode 的字符串类型。
- 修改一项输入并运行,观察结果中的值或路径如何变化。
- 载入对照样本,复现下面的变化;恢复原例会替换当前输入。
02
对照样本
对照样本交换 A 与 B。观察新增与删除的方向、修改前后值如何反转;没有差异时交换仍无差异。
查看对照输入
{
"ok": true,
"data": {
"balances": [
{
"itemCode": "demo-inserted",
"itemName": "新增演示记录",
"available": 120,
"reserved": true,
"warehouse": "east",
"location": {
"zone": "A",
"bins": [
"A-01",
"A-02"
]
}
},
{
"itemCode": "demo-inventory-1",
"itemName": "演示物料甲",
"available": 120,
"reserved": true,
"warehouse": "east",
"location": {
"zone": "A",
"bins": [
"A-01",
"A-02"
]
}
},
{
"itemCode": "demo-inventory-2",
"itemName": "演示物料乙",
"available": 6,
"reserved": false,
"warehouse": "west",
"location": {
"zone": "B",
"bins": [
"B-03"
]
}
}
],
"summary": {
"total": 2,
"note": null
}
}
}{
"ok": true,
"data": {
"balances": [
{
"itemCode": "demo-inventory-1",
"itemName": "演示物料甲",
"available": 120,
"reserved": true,
"warehouse": "east",
"location": {
"zone": "A",
"bins": [
"A-01",
"A-02"
]
}
},
{
"itemCode": "demo-inventory-2",
"itemName": "演示物料乙",
"available": 6,
"reserved": false,
"warehouse": "west",
"location": {
"zone": "B",
"bins": [
"B-03"
]
}
}
],
"summary": {
"total": 2,
"note": null
}
}
}对照样本的实际结果
[
{
"op": "replace",
"path": "/data/balances/0/itemCode",
"oldValue": "demo-inserted",
"value": "demo-inventory-1"
},
{
"op": "replace",
"path": "/data/balances/0/itemName",
"oldValue": "新增演示记录",
"value": "演示物料甲"
},
{
"op": "replace",
"path": "/data/balances/1/itemCode",
"oldValue": "demo-inventory-1",
"value": "demo-inventory-2"
},
{
"op": "replace",
"path": "/data/balances/1/itemName",
"oldValue": "演示物料甲",
"value": "演示物料乙"
},
{
"op": "replace",
"path": "/data/balances/1/available",
"oldValue": 120,
"value": 6
},
{
"op": "replace",
"path": "/data/balances/1/reserved",
"oldValue": true,
"value": false
},
{
"op": "replace",
"path": "/data/balances/1/warehouse",
"oldValue": "east",
"value": "west"
},
{
"op": "replace",
"path": "/data/balances/1/location/zone",
"oldValue": "A",
"value": "B"
},
{
"op": "replace",
"path": "/data/balances/1/location/bins/0",
"oldValue": "A-01",
"value": "B-03"
},
{
"op": "remove",
"path": "/data/balances/1/location/bins/1",
"oldValue": "A-02"
},
{
"op": "remove",
"path": "/data/balances/2",
"oldValue": {
"itemCode": "demo-inventory-2",
"itemName": "演示物料乙",
"available": 6,
"reserved": false,
"warehouse": "west",
"location": {
"zone": "B",
"bins": [
"B-03"
]
}
}
}
]