JSONPath使用介绍

tool

发布日期: 2022-11-13

简介

JSONPath是JSON的解析器，能通过简洁的表达式提取JSON中的值。与XPath从xml中提取元素的方式类似。

这里的应用场景是接口发送请求返回的response的json，提供JSONPath进行解析获取到需要断言的字段，与预期结果进行断言，判断接口测试的正确性。

JSONPath语法	描述
$	根节点
@	当前节点
. or []	子节点
..	选择所有符合条件的节点
*	所有节点
[]	迭代器标志，如数组下标
[,]	支持迭代器中做多选
[start : end : step]	数组切片运算符
?()	支持过滤操作
()	支持表达式计算

以likeshop商城H5版本首页接口的返回值为例，来讲解JSONPath的使用

{
    "code": 1,
    "msg": "",
    "data": {
        "news": [
            {
                "id": 2,
                "title": "双12活动预告~~~",
                "is_new": 1
            },
            {
                "id": 1,
                "title": "电商商城管理规章制度"
            }
        ],
        "shop_logo": "http://101.43.8.10:6969/static/common/image/default/shop_logo.png?=v1",
        "coupon": [],
        "activity_area": [
            {
                "id": 1,
                "name": "热销榜单",
                "title": "开学季必备",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/a3bf099101793a2e0bfe087b92e51403.png"
            },
            {
                "id": 2,
                "name": "品牌闪购",
                "title": "享惊喜折扣",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png"
            },
            {
                "id": 3,
                "name": "新品首发",
                "title": "抢惊喜福利",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png"
            }
        ],
        "seckill": {
            "id": 5,
            "start_time": "17:02",
            "end_time": 1673279700,
            "goods": [
                {
                    "id": 3,
                    "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
                    "min_price": "13.50",
                    "seckill_price": "9.90",
                    "sales_sum": 0
                },
                {
                    "id": 7,
                    "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
                    "min_price": "32.80",
                    "seckill_price": "29.90",
                    "sales_sum": 0
                },
                {
                    "id": 6,
                    "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
                    "min_price": "29.00",
                    "seckill_price": "26.90",
                    "sales_sum": 0
                },
                {
                    "id": 10,
                    "name": "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png",
                    "min_price": "1680.00",
                    "seckill_price": "999.00",
                    "sales_sum": 0
                }
            ]
        },
        "host_goods": [
            {
                "id": 4,
                "name": "晨光文具可削铅笔 六角2B 红黑抽条 木杆铅笔 儿童铅笔 AWP30804",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png",
                "price": "7.00",
                "market_price": "8.00",
                "sales_sum": 43676
            },
            {
                "id": 3,
                "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
                "price": "13.50",
                "market_price": "21.00",
                "sales_sum": 35368
            },
            {
                "id": 6,
                "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
                "price": "29.00",
                "market_price": "69.00",
                "sales_sum": 12352
            },
            {
                "id": 1,
                "name": "晨光中性笔笔芯黑0.5mm黑色碳素签字笔GP-1008按动式水笔学生考试用蓝黑医生处方笔教师专用红笔圆珠笔文具",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/45b6bb2224e4051ecf407cabb54cd781.png",
                "price": "44.82",
                "market_price": "55.00",
                "sales_sum": 6880
            },
            {
                "id": 2,
                "name": "晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png",
                "price": "43.90",
                "market_price": "78.00",
                "sales_sum": 6863
            }
        ],
        "new_goods": [
            {
                "id": 10,
                "name": "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png",
                "price": "1680.00",
                "market_price": "2400.00",
                "sales_sum": 685
            },
            {
                "id": 9,
                "name": "日本进口pilot百乐贵客钢笔 硬橡胶生漆18k金笔fkv-88sr莳绘30号金尖限定万年笔商务礼品套装",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/f245c44d136296f80071a26765e93cdf.png",
                "price": "6860.00",
                "market_price": "9800.00",
                "sales_sum": 98
            },
            {
                "id": 8,
                "name": "HERO/英雄钢笔HS208女神钢笔成人女士商务高档礼盒装办公时尚练字女生专用精致送礼官方正品代写贺卡",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/5e11c751c7e662764764e132ab6a8f72.png",
                "price": "1359.00",
                "market_price": "2598.00",
                "sales_sum": 352
            },
            {
                "id": 7,
                "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
                "price": "32.80",
                "market_price": "32.80",
                "sales_sum": 1366
            },
            {
                "id": 6,
                "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
                "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
                "price": "29.00",
                "market_price": "69.00",
                "sales_sum": 12352
            }
        ],
        "mall_logo": "?=v1"
    },
    "show": 0,
    "time": "0.085458"
}

实例讲解

根据上面的基本语法和提供的json串，实例说明使用各个语法写成的jsonpath表达式

`$`根节点

$根节点：进行操作的所有规则必须是从根节点开始匹配

表达式只写$即表示整个json。篇幅问题这里就不再复写了。

`@` 当前节点

当前节点下有一个或多个子节点，在当前节点的子节点中进行匹配是用@表示从当前节点下进行匹配。@用在匹配当前节点是否包含匹配表达式符合的内容，@符号前面书写的节点名，即为当前节点。@是用来做匹配使用的，会在过滤的章节中介绍具体应用。

`.`或`[]`子节点

用.表示找下一级节点

$.data.news

[
  [
    {
      "id": 2,
      "title": "双12活动预告~~~",
      "is_new": 1
    },
    {
      "id": 1,
      "title": "电商商城管理规章制度"
    }
  ]
]

用[]当前集合节点下的某个/些子节点

$.data.activity_area[1:]

[
  {
    "id": 2,
    "name": "品牌闪购",
    "title": "享惊喜折扣",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png"
  },
  {
    "id": 3,
    "name": "新品首发",
    "title": "抢惊喜福利",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png"
  }
]

`..`递归

使用..查找所有符合条件的节点

$..name

[
  "热销榜单",
  "品牌闪购",
  "新品首发",
  "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
  "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
  "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
  "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
  "晨光文具可削铅笔 六角2B 红黑抽条 木杆铅笔 儿童铅笔 AWP30804",
  "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
  "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
  "晨光中性笔笔芯黑0.5mm黑色碳素签字笔GP-1008按动式水笔学生考试用蓝黑医生处方笔教师专用红笔圆珠笔文具",
  "晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38",
  "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
  "日本进口pilot百乐贵客钢笔 硬橡胶生漆18k金笔fkv-88sr莳绘30号金尖限定万年笔商务礼品套装",
  "HERO/英雄钢笔HS208女神钢笔成人女士商务高档礼盒装办公时尚练字女生专用精致送礼官方正品代写贺卡",
  "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
  "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支"
]

`*`通配符

使用*匹配所有节点

$.data.seckill.* 匹配$.data.seckill的所有子节点

[
  5,
  "17:02",
  1673279700,
  [
    {
      "id": 3,
      "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
      "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
      "min_price": "13.50",
      "seckill_price": "9.90",
      "sales_sum": 0
    },
    {
      "id": 7,
      "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
      "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
      "min_price": "32.80",
      "seckill_price": "29.90",
      "sales_sum": 0
    },
    {
      "id": 6,
      "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
      "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
      "min_price": "29.00",
      "seckill_price": "26.90",
      "sales_sum": 0
    },
    {
      "id": 10,
      "name": "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
      "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png",
      "min_price": "1680.00",
      "seckill_price": "999.00",
      "sales_sum": 0
    }
  ]
]

可以对比一下$.data.seckill的结果：

[
  {
    "id": 5,
    "start_time": "17:02",
    "end_time": 1673279700,
    "goods": [
      {
        "id": 3,
        "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
        "min_price": "13.50",
        "seckill_price": "9.90",
        "sales_sum": 0
      },
      {
        "id": 7,
        "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
        "min_price": "32.80",
        "seckill_price": "29.90",
        "sales_sum": 0
      },
      {
        "id": 6,
        "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
        "min_price": "29.00",
        "seckill_price": "26.90",
        "sales_sum": 0
      },
      {
        "id": 10,
        "name": "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png",
        "min_price": "1680.00",
        "seckill_price": "999.00",
        "sales_sum": 0
      }
    ]
  }
]

`[]`迭代器下标

[]单个匹配

$.data.news[1]

[
  {
    "id": 1,
    "title": "电商商城管理规章制度"
  }
]

[,]多个匹配

$.data.seckill.goods[1,2]

[
  {
    "id": 7,
    "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
    "min_price": "32.80",
    "seckill_price": "29.90",
    "sales_sum": 0
  },
  {
    "id": 6,
    "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
    "min_price": "29.00",
    "seckill_price": "26.90",
    "sales_sum": 0
  }
]

`[start:end]` 切片

类似python中的切片，起始、结束

$.data.host_goods[0:3]

[
  {
    "id": 4,
    "name": "晨光文具可削铅笔 六角2B 红黑抽条 木杆铅笔 儿童铅笔 AWP30804",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png",
    "price": "7.00",
    "market_price": "8.00",
    "sales_sum": 43676
  },
  {
    "id": 3,
    "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
    "price": "13.50",
    "market_price": "21.00",
    "sales_sum": 35368
  },
  {
    "id": 6,
    "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
    "price": "29.00",
    "market_price": "69.00",
    "sales_sum": 12352
  }
]

`?()` 过滤

?()过滤，括号里面的是节点的操作

$.data.host_goods[?(@.price>10)]

根节点.data节点.host_goods节点[?进行过滤(@host_goods节点的内容list.price>10价格大于10的全部内容)]

[
  {
    "id": 3,
    "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
    "price": "13.50",
    "market_price": "21.00",
    "sales_sum": 35368
  },
  {
    "id": 6,
    "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
    "price": "29.00",
    "market_price": "69.00",
    "sales_sum": 12352
  },
  {
    "id": 1,
    "name": "晨光中性笔笔芯黑0.5mm黑色碳素签字笔GP-1008按动式水笔学生考试用蓝黑医生处方笔教师专用红笔圆珠笔文具",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/45b6bb2224e4051ecf407cabb54cd781.png",
    "price": "44.82",
    "market_price": "55.00",
    "sales_sum": 6880
  },
  {
    "id": 2,
    "name": "晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png",
    "price": "43.90",
    "market_price": "78.00",
    "sales_sum": 6863
  }
]

`()`过滤

()过滤，括号里是对列表的操作

$.data.host_goods[(@.length-1)] 其中length是host_goods内容列表的长度，-1即最后一个列表元素。

[
  {
    "id": 2,
    "name": "晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38",
    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png",
    "price": "43.90",
    "market_price": "78.00",
    "sales_sum": 6863
  }
]

结合python使用

使用python操作jsonpath，需要安装第三方的插件

$ pip install jsonpath

示例

import jsonpath

json1 = \
    {
        "code": 1,
        "msg": "",
        "data": {
            "news": [
                {
                    "id": 2,
                    "title": "双12活动预告~~~",
                    "is_new": 1
                },
                {
                    "id": 1,
                    "title": "电商商城管理规章制度"
                }
            ],
            "shop_logo": "http://101.43.8.10:6969/static/common/image/default/shop_logo.png?=v1",
            "coupon": [],
            "activity_area": [
                {
                    "id": 1,
                    "name": "热销榜单",
                    "title": "开学季必备",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/a3bf099101793a2e0bfe087b92e51403.png"
                },
                {
                    "id": 2,
                    "name": "品牌闪购",
                    "title": "享惊喜折扣",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png"
                },
                {
                    "id": 3,
                    "name": "新品首发",
                    "title": "抢惊喜福利",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png"
                }
            ],
            "seckill": {
                "id": 5,
                "start_time": "17:02",
                "end_time": 1673279700,
                "goods": [
                    {
                        "id": 3,
                        "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
                        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
                        "min_price": "13.50",
                        "seckill_price": "9.90",
                        "sales_sum": 0
                    },
                    {
                        "id": 7,
                        "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
                        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
                        "min_price": "32.80",
                        "seckill_price": "29.90",
                        "sales_sum": 0
                    },
                    {
                        "id": 6,
                        "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
                        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
                        "min_price": "29.00",
                        "seckill_price": "26.90",
                        "sales_sum": 0
                    },
                    {
                        "id": 10,
                        "name": "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
                        "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png",
                        "min_price": "1680.00",
                        "seckill_price": "999.00",
                        "sales_sum": 0
                    }
                ]
            },
            "host_goods": [
                {
                    "id": 4,
                    "name": "晨光文具可削铅笔 六角2B 红黑抽条 木杆铅笔 儿童铅笔 AWP30804",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png",
                    "price": "7.00",
                    "market_price": "8.00",
                    "sales_sum": 43676
                },
                {
                    "id": 3,
                    "name": "晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png",
                    "price": "13.50",
                    "market_price": "21.00",
                    "sales_sum": 35368
                },
                {
                    "id": 6,
                    "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
                    "price": "29.00",
                    "market_price": "69.00",
                    "sales_sum": 12352
                },
                {
                    "id": 1,
                    "name": "晨光中性笔笔芯黑0.5mm黑色碳素签字笔GP-1008按动式水笔学生考试用蓝黑医生处方笔教师专用红笔圆珠笔文具",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/45b6bb2224e4051ecf407cabb54cd781.png",
                    "price": "44.82",
                    "market_price": "55.00",
                    "sales_sum": 6880
                },
                {
                    "id": 2,
                    "name": "晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png",
                    "price": "43.90",
                    "market_price": "78.00",
                    "sales_sum": 6863
                }
            ],
            "new_goods": [
                {
                    "id": 10,
                    "name": "顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png",
                    "price": "1680.00",
                    "market_price": "2400.00",
                    "sales_sum": 685
                },
                {
                    "id": 9,
                    "name": "日本进口pilot百乐贵客钢笔 硬橡胶生漆18k金笔fkv-88sr莳绘30号金尖限定万年笔商务礼品套装",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/f245c44d136296f80071a26765e93cdf.png",
                    "price": "6860.00",
                    "market_price": "9800.00",
                    "sales_sum": 98
                },
                {
                    "id": 8,
                    "name": "HERO/英雄钢笔HS208女神钢笔成人女士商务高档礼盒装办公时尚练字女生专用精致送礼官方正品代写贺卡",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/5e11c751c7e662764764e132ab6a8f72.png",
                    "price": "1359.00",
                    "market_price": "2598.00",
                    "sales_sum": 352
                },
                {
                    "id": 7,
                    "name": "得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png",
                    "price": "32.80",
                    "market_price": "32.80",
                    "sales_sum": 1366
                },
                {
                    "id": 6,
                    "name": "小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支",
                    "image": "http://101.43.8.10:6969/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png",
                    "price": "29.00",
                    "market_price": "69.00",
                    "sales_sum": 12352
                }
            ],
            "mall_logo": "?=v1"
        },
        "show": 0,
        "time": "0.085458"
    }

expr1 = '$.data.host_goods[(@.length-1)]'
output1 = jsonpath.jsonpath(json1, expr1)

expr2 = '$.data.news[0].id'
output2 = jsonpath.jsonpath(json1, expr2)
print(output1)
print(output2)

执行结果：

[{'id': 2, 'name': '晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38', 'image': 'http://101.43.8.10:6969/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png', 'price': '43.90', 'market_price': '78.00', 'sales_sum': 6863}]
[2]

老百

http://www.plscript.cn/2022/11/13/jsonpath-shi-yong-jie-shao/

本博客所有文章除特別声明外，均采用 CC BY 4.0 许可协议。转载请注明来源老百 !

JSON JSONPath

Python之魔术方法

在Python中,所有以“__”双下划线包起来的方法,都统称为“Magic Method”,中文称『魔术方法』,例如类的初始化方法__init__

2022-11-15 Python

魔术方法单例模式

Python之日志模块

logging是Python的一个标准库，其中定义的函数和类为应用程序和库的开发实现了一个灵活的事件日志系统。Python logging的配置由四个部分组成：Logger、Handlers、Filter、Formatter。

2022-11-11 Python

logging

简介

实例讲解

$根节点

@ 当前节点

.或[]子节点

..递归

*通配符

[]迭代器下标

[start:end] 切片

?() 过滤

()过滤

结合python使用

`$`根节点

`@` 当前节点

`.`或`[]`子节点

`..`递归

`*`通配符

`[]`迭代器下标

`[start:end]` 切片

`?()` 过滤

`()`过滤