使用 JSONPath 提取 ID 字段的值

JSONPath 是一种用于查询和提取 JSON 数据的语言。它允许您使用类似于 XPath 的语法来选择特定数据元素。

例如，如果您想要提取以下 JSON 数据中的 'record0' 对象的 ID 字段的值：

{
  "record0": {
    "sf_calc_type": 2,
    "sf_discount": 0.000000,
    "gmt_create": 1683268215000,
    "air_t_sf_agent_bill_detail_id": 170730,
    "agent_id": 1002637,
    "agent_settlement_currency": "",
    "agent_fee_model_id": 49392,
    "remark": "，重量差异",
    "fee_type": "FEE_TYPE9",
    "agent_meterage_amount": "",
    "gmt_modified": 1683268216000,
    "sf_currency": "CAD",
    "sf_settlement_currency": "CAD",
    "cost_gap": 300.000000,
    "create_by": "80002976",
    "bill_discount": "",
    "sf_meterage_amount": 1140.000000,
    "id": 859868,
    "sf_actual_amount": 1140.000000,
    "agent_currency": "CAD",
    "bill_id": 25272,
    "conciliation_version": "",
    "agent_actual_amount": "",
    "bill_amount": "",
    "sf_amount": 1140.000000,
    "bill_currency": "",
    "fee_type_code": "001",
    "agent_discount": "",
    "bill_state": "2",
    "data_source": 5,
    "agent_type": "T",
    "fee_name": "Air Freight",
    "agent_settlement_code": "PMaple-CA02",
    "agent_amount": 840.000000,
    "modified_by": "80002976",
    "operational_state": "10"
  }
}

您可以使用以下 JSONPath 表达式来提取 ID 字段的值：

$.record0.id

这将返回值 859868。

JSONPath 是一个强大的工具，可以用于处理 JSON 数据。它可以帮助您轻松地提取所需的信息，而无需编写复杂的代码。