如何解析musixmatch python api JSON响应？

Question

如何解析musixmatchapi的JSON响应？ 我正在调用这个方法 res=艺术家_api.artist\搜索\获取（格式=格式，q\艺术家=艺术家）

我得到的答复是

{'message': {'body': {'artist_list': [{'artist': {'artist_alias_list': [],
                                                  'artist_comment': '',
                                                  'artist_country': '',
                                                  'artist_credits': {'artist_list': []},
                                                  'artist_edit_url': None,
                                                  'artist_id': 26575484.0,
                                                  'artist_mbid': None,
                                                  'artist_name': 'Illenium',
                                                  'artist_name_translation_list': [],
                                                  'artist_rating': 55.0, .........

我在找艺术家的身份证

我试着让艺术家像这样：

    print(res['message']['body']['artist']['artist_id'])

artist_api = swagger_client.ArtistApi()
format = 'json' 

try:
    artist_list = ["adele", "lady gaga", "john legend"];
    for artist in artist_list:
        print(artist)
        res = artist_api.artist_search_get(format=format, q_artist=artist)
        print(res['message']['body']['artist']['artist_id'])
except ApiException as e:
    print "Exception when calling ArtistApi->artist_search_get: %s\n" % e

我收到以下错误消息：

Traceback (most recent call last):
  File "musixmatch.py", line 39, in <module>
    print(res['message']['body']['artist_id'])
TypeError: 'InlineResponse2004' object has no attribute '__getitem__'

请帮忙，我找了很多线索，但还是找不到答案。我是python新手，所以我不确定自己做错了什么。你知道吗

Answer 1

如果JSON文档的层次结构有点混乱，请使用以下代码获取所需的值：

[artist['artist']['artist_id'] for artist in res['message']['body']['artist_list']]

或者，可以使用JSONPath-表达式：$..artist_list..artist_id来获得相同的结果。你知道吗

示例

from jsonpath_rw import parse
import json

res = json.loads("""{
  "message": {
    "header": {},
    "body": {
      "artist_list": [
        {
          "artist": {
            "artist_credits": {            },
            "artist_country": "string",
            "artist_id": 110
          }
        },
        {
          "artist": {
            "artist_credits": {},
            "artist_country": "string",
            "artist_id": 220
          }
        }        
      ]
    }
  }
}""")

# 1-way: Iterate through JSON-document
print([artist['artist']['artist_id'] for artist in res['message']['body']['artist_list']])
# result: [110, 220]

# 2-way: Use JSONPath-expression
jsonpath_expr = parse('$..artist_list..artist_id')
print([match.value for match in jsonpath_expr.find(res)])
# result: [110, 220]