meterSphere（五）jsonpath提取参数
语法
举个例子
响应报文
点击查看代码
{
"code": "0",
"msg": "Success",
"notify": true,
"data": [
{
"header": {
"id": 34890,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021120100000020",
"refOrderId": 82875,
"refOrderCode": "OFS-PR2021120100000009",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-12-01 17:37:17",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000020",
"refOrderId": 82875,
"refOrderDetailId": 138199,
"refOrderCode": "OFS-PR2021120100000009",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:37:17",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:37:16",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:37:17",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000020",
"refOrderId": 82875,
"refOrderDetailId": 138200,
"refOrderCode": "OFS-PR2021120100000009",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:37:17",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:37:16",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:37:17",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34889,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021120100000019",
"refOrderId": 82874,
"refOrderCode": "OFS-PR2021120100000008",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-12-01 17:31:39",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000019",
"refOrderId": 82874,
"refOrderDetailId": 138197,
"refOrderCode": "OFS-PR2021120100000008",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:31:39",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:31:38",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:31:39",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000019",
"refOrderId": 82874,
"refOrderDetailId": 138198,
"refOrderCode": "OFS-PR2021120100000008",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:31:39",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:31:38",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:31:39",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34888,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021120100000018",
"refOrderId": 82873,
"refOrderCode": "OFS-PR2021120100000007",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-12-01 17:27:23",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000018",
"refOrderId": 82873,
"refOrderDetailId": 138195,
"refOrderCode": "OFS-PR2021120100000007",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:27:23",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:27:22",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:27:23",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000018",
"refOrderId": 82873,
"refOrderDetailId": 138196,
"refOrderCode": "OFS-PR2021120100000007",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:27:23",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:27:22",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:27:23",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34887,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021120100000017",
"refOrderId": 82872,
"refOrderCode": "OFS-PR2021120100000006",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-12-01 17:22:28",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000017",
"refOrderId": 82872,
"refOrderDetailId": 138193,
"refOrderCode": "OFS-PR2021120100000006",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:22:28",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:22:27",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:22:28",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000017",
"refOrderId": 82872,
"refOrderDetailId": 138194,
"refOrderCode": "OFS-PR2021120100000006",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:22:28",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 17:22:27",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:22:28",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34885,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021120100000015",
"refOrderId": 82871,
"refOrderCode": "OFS-PR2021120100000005",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-12-01 17:04:41",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000015",
"refOrderId": 82871,
"refOrderDetailId": 138191,
"refOrderCode": "OFS-PR2021120100000005",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:04:41",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 16:52:33",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:04:41",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000015",
"refOrderId": 82871,
"refOrderDetailId": 138192,
"refOrderCode": "OFS-PR2021120100000005",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 17:04:41",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 16:52:33",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 17:04:41",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34877,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021120100000008",
"refOrderId": 82869,
"refOrderCode": "OFS-PR2021120100000003",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-12-01 14:23:14",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000008",
"refOrderId": 82869,
"refOrderDetailId": 138187,
"refOrderCode": "OFS-PR2021120100000003",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 14:23:14",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 14:19:15",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 14:23:14",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021120100000008",
"refOrderId": 82869,
"refOrderDetailId": 138188,
"refOrderCode": "OFS-PR2021120100000003",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-12-01 14:23:14",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-12-01 14:19:15",
"createdBy": "xxy",
"lastUpdated": "2021-12-01 14:23:14",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34867,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021113000000040",
"refOrderId": 82866,
"refOrderCode": "OFS-PR2021113000000002",
"refOrderType": "PURCHASE_RETURN",
"status": 900,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "B2C",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderId": 2,
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPostalCode": "430000",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 2,
"totalQty": 20,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 20,
"totalVolumeWeight": 0,
"weightUM": "wu",
"volumeUM": "CM3",
"totalAmount": 180,
"totalPayAmount": 180,
"postageAmount": 0,
"itemTotalAmount": 180,
"totalFulfillQty": 20,
"totalFulfillWeight": 0,
"totalFulfillVolume": 20,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-11-30 17:23:35",
"carrierCode": "OFS",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021113000000040",
"refOrderId": 82866,
"refOrderDetailId": 138183,
"refOrderCode": "OFS-PR2021113000000002",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-11-30 17:23:35",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-11-30 17:22:22",
"createdBy": "xxy",
"lastUpdated": "2021-11-30 17:23:35",
"lastUpdatedBy": "xxy"
},
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021113000000040",
"refOrderId": 82866,
"refOrderDetailId": 138184,
"refOrderCode": "OFS-PR2021113000000002",
"allocInvId": 10006070,
"skuCode": "basic_sku_02",
"skuName": "basic_sku_02",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 10,
"shipQty": 10,
"shipAt": "2021-11-30 17:23:35",
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 90,
"totalPayAmount": 90,
"totalWeight": 0,
"totalVolume": 10,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-11-30 17:22:22",
"createdBy": "xxy",
"lastUpdated": "2021-11-30 17:23:35",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34860,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021113000000033",
"refOrderId": 82865,
"refOrderCode": "OFS-PR2021113000000001",
"refOrderType": "PURCHASE_RETURN",
"status": 500,
"consolidated": 0,
"internalInstructionType": "PURCHASE_RETURN",
"bizChannel": "NA",
"sourcePlatformCode": "OFS",
"processType": "NORMAL",
"sourceOrderCode": "",
"shipToAttentionTo": "tester",
"shipToAddress": "融众国际14楼",
"shipToCountry": "中国",
"shipToState": "1027971",
"shipToCity": "1028185",
"shipToDistrict": "1028337",
"shipToPhone": "027-66666666",
"shipToMobile": "13412341234",
"shipToFax": "77777777",
"shipToEmail": "tester@ttx.com.cn",
"totalLines": 0,
"totalQty": 0,
"totalContainers": 0,
"totalCases": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"totalPayAmount": 4.44,
"postageAmount": 0,
"itemTotalAmount": 0,
"totalFulfillQty": 0,
"totalFulfillWeight": 0,
"totalFulfillVolume": 0,
"totalFulfillVolumeWeight": 0,
"carrierCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"shipFromAttentionTo": "tester",
"shipFromAddress": "融众国际14楼",
"shipFromDistrict": "洪山区",
"shipFromCity": "武汉市",
"shipFromState": "湖北省",
"shipFromCountry": "1",
"shipFromPostalCode": "",
"shipFromPhone": "",
"shipFromMobile": "13412341234",
"shipFromFax": "",
"shipFromEmail": "",
"codAmount": 0,
"tax": 0,
"taxPaid": 1,
"shipToStateName": "湖北省",
"shipToCityName": "武汉市",
"shipToDistrictName": "洪山区"
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021113000000033",
"refOrderId": 82865,
"refOrderDetailId": 138182,
"refOrderCode": "OFS-PR2021113000000001",
"allocInvId": 10006069,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 1,
"shipQty": 0,
"quantityUM": "EA",
"listPrice": 0,
"itemTotalAmount": 4.44,
"totalPayAmount": 4.44,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-11-30 14:54:23",
"createdBy": "xxy",
"lastUpdated": "2021-11-30 14:54:23",
"lastUpdatedBy": "xxy"
}
]
},
{
"header": {
"id": 34854,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021113000000027",
"refOrderId": 1643,
"refOrderCode": "OFS-AH2021113000000049",
"refOrderType": "ADJUST",
"status": 900,
"consolidated": 0,
"internalInstructionType": "ADJUST",
"bizChannel": "NA",
"sourcePlatformCode": "WMS",
"processType": "NORMAL",
"sourceOrderCode": "",
"totalLines": 1,
"totalQty": 7,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"totalAmount": 31.08,
"totalPayAmount": 31.08,
"postageAmount": 0,
"itemTotalAmount": 31.08,
"totalFulfillQty": 7,
"totalFulfillWeight": 0,
"totalFulfillVolume": 0,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-11-30 14:26:33",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"codAmount": 0,
"tax": 0,
"taxPaid": 1
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021113000000027",
"refOrderId": 1643,
"refOrderDetailId": 25668,
"refOrderCode": "OFS-AH2021113000000049",
"allocInvId": 10006116,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 7,
"shipQty": 7,
"shipAt": "2021-11-30 14:26:33",
"quantityUM": "EA",
"listPrice": 4.44,
"itemTotalAmount": 31.08,
"totalPayAmount": 31.08,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-11-30 14:26:33",
"createdBy": "api",
"lastUpdated": "2021-11-30 14:26:33",
"lastUpdatedBy": "api",
"lot": "0707",
"batch": "001",
"agingDate": "2020-07-07",
"expirationDate": "2021-07-31",
"attribute1": "auto_1",
"attribute2": "auto_2",
"attribute3": "auto_3",
"attribute4": "auto_20211130"
}
]
},
{
"header": {
"id": 34850,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021113000000023",
"refOrderId": 1631,
"refOrderCode": "OFS-AH2021113000000037",
"refOrderType": "ADJUST",
"status": 900,
"consolidated": 0,
"internalInstructionType": "ADJUST",
"bizChannel": "NA",
"sourcePlatformCode": "WMS",
"processType": "NORMAL",
"sourceOrderCode": "",
"totalLines": 1,
"totalQty": 7,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"totalAmount": 31.08,
"totalPayAmount": 31.08,
"postageAmount": 0,
"itemTotalAmount": 31.08,
"totalFulfillQty": 7,
"totalFulfillWeight": 0,
"totalFulfillVolume": 0,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-11-30 14:01:29",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"codAmount": 0,
"tax": 0,
"taxPaid": 1
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021113000000023",
"refOrderId": 1631,
"refOrderDetailId": 25656,
"refOrderCode": "OFS-AH2021113000000037",
"allocInvId": 10006116,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 7,
"shipQty": 7,
"shipAt": "2021-11-30 14:01:29",
"quantityUM": "EA",
"listPrice": 4.44,
"itemTotalAmount": 31.08,
"totalPayAmount": 31.08,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-11-30 14:01:29",
"createdBy": "api",
"lastUpdated": "2021-11-30 14:01:29",
"lastUpdatedBy": "api",
"lot": "0707",
"batch": "001",
"agingDate": "2020-07-07",
"expirationDate": "2021-07-31",
"attribute1": "auto_1",
"attribute2": "auto_2",
"attribute3": "auto_3",
"attribute4": "auto_20211130"
}
]
},
{
"header": {
"id": 34848,
"clientCode": "OFS",
"companyCode": "basic_company_01",
"facilityCode": "basic_facility_01",
"code": "OFS-SH2021113000000021",
"refOrderId": 1629,
"refOrderCode": "OFS-AH2021113000000035",
"refOrderType": "ADJUST",
"status": 900,
"consolidated": 0,
"internalInstructionType": "ADJUST",
"bizChannel": "NA",
"sourcePlatformCode": "WMS",
"processType": "NORMAL",
"sourceOrderCode": "",
"totalLines": 1,
"totalQty": 7,
"totalContainers": 0,
"totalCases": 0,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"totalAmount": 31.08,
"totalPayAmount": 31.08,
"postageAmount": 0,
"itemTotalAmount": 31.08,
"totalFulfillQty": 7,
"totalFulfillWeight": 0,
"totalFulfillVolume": 0,
"totalFulfillVolumeWeight": 0,
"shipAt": "2021-11-30 13:46:55",
"primaryWaybillCode": "",
"codRequired": "0",
"invoiceRequired": "0",
"codAmount": 0,
"tax": 0,
"taxPaid": 1
},
"details": [
{
"clientCode": "OFS",
"companyCode": "COMPANY2021110300000020",
"facilityCode": "FACILITY2021110400000001",
"shipmentCode": "OFS-SH2021113000000021",
"refOrderId": 1629,
"refOrderDetailId": 25654,
"refOrderCode": "OFS-AH2021113000000035",
"allocInvId": 10006116,
"skuCode": "basic_sku_01",
"skuName": "basic_sku_01",
"inventorySts": "AVAILABLE",
"isGift": 0,
"requestQty": 7,
"shipQty": 7,
"shipAt": "2021-11-30 13:46:55",
"quantityUM": "EA",
"listPrice": 4.44,
"itemTotalAmount": 31.08,
"totalPayAmount": 31.08,
"totalWeight": 0,
"totalVolume": 0,
"totalVolumeWeight": 0,
"weightUM": "G",
"volumeUM": "CM3",
"created": "2021-11-30 13:46:54",
"createdBy": "api",
"lastUpdated": "2021-11-30 13:46:55",
"lastUpdatedBy": "api",
"lot": "0707",
"batch": "001",
"agingDate": "2020-07-07",
"expirationDate": "2021-07-31",
"attribute1": "auto_1",
"attribute2": "auto_2",
"attribute3": "auto_3",
"attribute4": "auto_20211130"
}
]
}
],
"error": false
}
需求一
接口需要分页查询，想要获取data数组中最后一个列表的数据中的code
解法
查到有两种写法：
写法一：$.data[(@.length-1)].header.code
写法二：$.data[-1].header.code
需求二
想要获取data数组的长度
解法
$.data.length()
问题
在meterSphere中，写法一没有生效，写法二是生效的
用jsonPath校验工具校验，两种写法都是生效的
小工具
附好用的jsonPath校验工具：
http://jsonpath.com/