jsonpath:从庞大的接口返回结果(返回结果为字典类型)中取字段值

从庞大的接口返回结果(返回结果为字典类型)中取字段值,返回结果是list

s = {"ec": 0, "errcode": 0, "em": "", "cache": 0, "adm_num": 3, "levelname": None, "mems": [
    {"uin": 511402865, "role": 0, "g": 0, "join_time": 1589360442, "last_speak_time": 1600570983,
     "lv": {"point": 0, "level": 1}, "card": "", "tags": "-1", "flag": 0, "nick": "\u671d\u82b1\u5915\u62fe",
     "qage": 14, "rm": 0}, {"uin": 475566024, "role": 1, "g": 0, "join_time": 1589360443, "last_speak_time": 1596195430,
                            "lv": {"point": 0, "level": 1}, "card": "", "tags": "-1", "flag": 0, "nick": "CC",
                            "qage": 15, "rm": 1},
    {"uin": 616745045, "role": 1, "g": 0, "join_time": 1589360443, "last_speak_time": 1589360443,
     "lv": {"point": 0, "level": 1}, "card": "", "tags": "-1", "flag": 0, "nick": "\u5927\u5e08\u5144", "qage": 14,
     "rm": 1}, {"uin": 1473732204, "role": 1, "g": 0, "join_time": 1589360443, "last_speak_time": 1596699591,
                "lv": {"point": 0, "level": 1}, "card": "", "tags": "-1", "flag": 0, "nick": "\u5b89\u5927\u53d4",
                "qage": 10, "rm": 1},
    {"uin": 1930890111, "role": 2, "g": -1, "join_time": 1589360638, "last_speak_time": 1589363741,
     "lv": {"point": 0, "level": 1}, "card": "", "tags": "-1", "flag": 0, "nick": "56", "qage": 9, "rm": 1},
    {"uin": 549313033, "role": 2, "g": 0, "join_time": 1590131830, "last_speak_time": 1597542612,
     "lv": {"point": 0, "level": 1}, "card": "\u767d\u5b87\u9e4f", "tags": "-1", "flag": 0, "nick": "\u79e6\u6b87",
     "qage": 12, "rm": 1}, {"uin": 121654011, "role": 2, "g": 1, "join_time": 1591326665, "last_speak_time": 1597549705,
                            "lv": {"point": 0, "level": 1}, "card": "\u8e6d\u8bfe-\u66f9\u4e3a\u7f8e", "tags": "-1",
                            "flag": 0, "nick": "\u265dAimee\u00b7Too\u2740", "qage": 14, "rm": 1},
    {"uin": 411732604, "role": 2, "g": 1, "join_time": 1591326665, "last_speak_time": 1591584091,
     "lv": {"point": 0, "level": 1}, "card": "", "tags": "-1", "flag": 0,
     "nick": "\u4e09\u53f6\u8349\u7684\u624b\u6307", "qage": 14, "rm": 1},
    {"uin": 690763103, "role": 2, "g": 1, "join_time": 1591326665, "last_speak_time": 1599960754,
     "lv": {"point": 0, "level": 1}, "card": "\u674e\u9ad8\u82f1", "tags": "-1", "flag": 0,
     "nick": "\u4e24\u6b21\u65b9\u7684\u65cb\u5f8b", "qage": 12, "rm": 1},
    {"uin": 1522503760, "role": 2, "g": 0, "join_time": 1591326665, "last_speak_time": 1598146137,
     "lv": {"point": 0, "level": 1}, "card": "\u79b9\u6881", "tags": "-1", "flag": 0, "nick": "\u79b9\u6881", "qage": 9,
     "rm": 1}, {"uin": 635763064, "role": 2, "g": 1, "join_time": 1592997221, "last_speak_time": 1600572109,
                "lv": {"point": 0, "level": 1}, "card": "\u970d\u7d2b\u9633", "tags": "-1", "flag": 0,
                "nick": "\u6f02\u6d41\u6d77\u5cb8", "qage": 13, "rm": 1},
    {"uin": 857566034, "role": 2, "g": 1, "join_time": 1593329449, "last_speak_time": 1600565621,
     "lv": {"point": 0, "level": 1}, "card": "\u4ee3\u723d", "tags": "-1", "flag": 0,
     "nick": "\u767d\u7fbd\u5f52\u697c", "qage": 12, "rm": 1},
    {"uin": 347158400, "role": 2, "g": 0, "join_time": 1593345739, "last_speak_time": 1599385077,
     "lv": {"point": 0, "level": 1}, "card": "\u6731\u6210", "tags": "-1", "flag": 0, "nick": "\u9ea6\u514b.vod",
     "qage": 16, "rm": 1}, {"uin": 704096641, "role": 2, "g": 1, "join_time": 1594023174, "last_speak_time": 1600572110,
                            "lv": {"point": 0, "level": 1}, "card": "\u803f\u5a1f", "tags": "-1", "flag": 0,
                            "nick": "704096641", "qage": 13, "rm": 1},
    {"uin": 978502577, "role": 2, "g": 1, "join_time": 1594883618, "last_speak_time": 1599992058,
     "lv": {"point": 0, "level": 1}, "card": "\u5f20\u4e39\u96ea", "tags": "-1", "flag": 0,
     "nick": "\u3000\u3000Amour\u256e\u66ae\u5ff5", "qage": 9, "rm": 1},
    {"uin": 799614279, "role": 2, "g": 0, "join_time": 1594884719, "last_speak_time": 1600565607,
     "lv": {"point": 0, "level": 1}, "card": "\u9c81\u6d25\u5065", "tags": "-1", "flag": 0,
     "nick": "\u4e28\u5bd2\u5c10\u6708\u309e", "qage": 13, "rm": 1},
    {"uin": 695254152, "role": 2, "g": 0, "join_time": 1594886366, "last_speak_time": 1600572106,
     "lv": {"point": 0, "level": 1}, "card": "\u738b\u7965\u9f99", "tags": "-1", "flag": 0,
     "nick": "\u8ffd\u68a6\u8d64\u5b50\u5fc3", "qage": 13, "rm": 1},
    {"uin": 251202767, "role": 2, "g": 1, "join_time": 1594943472, "last_speak_time": 1600572310,
     "lv": {"point": 0, "level": 1}, "card": "\u9ad8\u96ef", "tags": "-1", "flag": 0,
     "nick": "\u7d2b\u8272\u7cbe\u7075", "qage": 16, "rm": 1},
    {"uin": 120617143, "role": 2, "g": 1, "join_time": 1595481073, "last_speak_time": 1596951515,
     "lv": {"point": 0, "level": 1}, "card": "\u7b71", "tags": "-1", "flag": 0, "nick": "\u6668\u98ce\u5915\u96e8",
     "qage": 18, "rm": 1}, {"uin": 357084975, "role": 2, "g": 1, "join_time": 1595817181, "last_speak_time": 1600572106,
                            "lv": {"point": 0, "level": 1}, "card": "\u674e\u97e9\u97e9", "tags": "-1", "flag": 0,
                            "nick": "\u2581\u2581\u5e7b\u68a6\u541f\u8ff7\u60d1\u4e0d\u4f4f\u7684\u5fc3", "qage": 8,
                            "rm": 1},
    {"uin": 296915611, "role": 2, "g": -1, "join_time": 1595927320, "last_speak_time": 1600572383,
     "lv": {"point": 0, "level": 1}, "card": "\u9b4f\u5f3a", "tags": "-1", "flag": 0,
     "nick": "\u8def\u4eba\u7532@\u63d0\u4e0d\u8d77\u52b2", "qage": 13, "rm": 1}], "count": 48, "svr_time": 1600572532,
     "max_count": 200, "search_count": 48, "extmode": 0}

import jsonpath

# print(jsonpath.jsonpath(s,'$.max_count'))
# print(jsonpath.jsonpath(s,'$.mems[0].nick'))
# print(jsonpath.jsonpath(s,'$..level')) #

# $表示字典最外层,'.+下一层级的字段名称'
print(jsonpath.jsonpath(s,'$.search_count'))
#下一个层级的字段如果是字典或者列表,可以取对应字典或者列表的第几个,然后再'.+字段名',获取对应字段值
print(jsonpath.jsonpath(s,'$.mems[1].nick'))
# 当不知道某个字段在字典第几层时,可以选择'..+字段名'的方式
print(jsonpath.jsonpath(s,'$..nick'))

输出结果:
[48]
['CC']
['朝花夕拾', 'CC', '大师兄', '安大叔', '56', '秦殇', '♝Aimee·Too❀', '三叶草的手指', '两次方的旋律', '禹梁', '漂流海岸', '白羽归楼', '麦克.vod', '704096641', '\u3000\u3000Amour╮暮念', '丨寒尐月ゞ', '追梦赤子心', '紫色精灵', '晨风夕雨', '▁▁幻梦吟迷惑不住的心', '路人甲@提不起劲']
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值