如何解析包含多个JSON对象的JSON响应？

Question

在参考了这个链接后，我遇到了一个情况，即我收到的响应中包含多个JSON对象。与链接中提到的响应（它接收一个包含多个JSON的单个数组）不同，我收到的多个JSON对象之间没有方括号包围，也没有逗号分隔。

响应数据的结构如下所示：

{
  "self": "https://example1.com",
  "key": "keyOne",
  "name": "nameOne",
  "emailAddress": "mailOne",
  "avatarUrls": {
    "48x48": "https://test.com/secure/useravatar?avatarId=1",
    "24x24": "https://test.com/secure/useravatar?size=small&avatarId=1",
    "16x16": "https://test.com/secure/useravatar?size=xsmall&avatarId=1",
    "32x32": "https://test.com/secure/useravatar?size=medium&avatarId=1"
  },
  "displayName": "displayNameOne",
  "active": true,
  "timeZone": "Europe",
  "locale": "en_UK"
}
{
  "self": "https://example2.com",
  "key": "keyTwo",
  "name": "nameTwo",
  "emailAddress": "mailTwo",
  "avatarUrls": {
    "48x48": "https://test.com/secure/useravatar?avatarId=2",
    "24x24": "https://test.com/secure/useravatar?size=small&avatarId=2",
    "16x16": "https://test.com/secure/useravatar?size=xsmall&avatarId=2",
    "32x32": "https://test.com/secure/useravatar?size=medium&avatarId=2"
  },
  "displayName": "displayNameTwo",
  "active": false,
  "timeZone": "Europe",
  "locale": "en_US"
}

我尝试遍历REST API响应，并考虑将响应内容用方括号包裹起来，但都没有成功。

我又查看了这个链接，但这里的情况是每个JSON元素都在单独一行，这与我的情况不符。请问，在Python中应如何处理这个问题呢？

bames53 · Answer

这是一个函数示例，用于解析不规范格式的JSON响应数据：

response = '''
{
"self": "https://example1.com",
"key": "keyOne",
"name": "nameOne",
"emailAddress": "mailOne",
"avatarUrls": {
  "48x48": "https://test.com/secure/useravatar?avatarId=1",
  "24x24": "https://test.com/secure/useravatar?size=small&avatarId=1",
  "16x16": "https://test.com/secure/useravatar?size=xsmall&avatarId=1",
  "32x32": "https://test.com/secure/useravatar?size=medium&avatarId=1"
},
"displayName": "displayNameOne",
"active": true,
"timeZone": "Europe",
"locale": "en_UK"
}
{
"self": "https://example2.com",
"key": "keyTwo",
"name": "nameTwo",
"emailAddress": "mailTwo",
"avatarUrls": {
  "48x48": "https://test.com/secure/useravatar?avatarId=2",
  "24x24": "https://test.com/secure/useravatar?size=small&avatarId=2",
  "16x16": "https://test.com/secure/useravatar?size=xsmall&avatarId=2",
  "32x32": "https://test.com/secure/useravatar?size=medium&avatarId=2"
},
"displayName": "displayNameTwo",
"active": false,
"timeZone": "Europe",
"locale": "en_US"
}
'''

import json

def parse_response(response):
    # 移除响应字符串首尾的空白字符并分割JSON对象
    response = response.strip()
    # 以特定模式切分字符串以获取独立的JSON对象
    json_strs = response.split('
{"self":')
    # 修正切分后的字符串，确保每个JSON对象格式正确
    json_strs = [json_strs[0]] + ['{"self":' + s for s in json_strs[1:]]
    # 将所有JSON对象组合成一个数组字符串
    json_array_str = '[' + ','.join(json_strs) + ']'
    # 将组合后的字符串解析为Python列表
    return json.loads(json_array_str)

# 调用函数解析响应数据
parsed_data = parse_response(response)

# 打印解析后的数据
print(parsed_data)

Adam Matan · Answer

您的数据中包含多个JSON对象，这些对象可以通过识别仅包含 } 的行与紧随其后的仅包含 { 的行来分隔。

基于此，可以采取以下方法进行处理：

data = '''
{
"self": "https://example1.com",
"key": "keyOne",
"name": "nameOne",
"emailAddress": "mailOne",
"avatarUrls": {
  "48x48": "https://test.com/secure/useravatar?avatarId=1",
  "24x24": "https://test.com/secure/useravatar?size=small&avatarId=1",
  "16x16": "https://test.com/secure/useravatar?size=xsmall&avatarId=1",
  "32x32": "https://test.com/secure/useravatar?size=medium&avatarId=1"
},
"displayName": "displayNameOne",
"active": true,
"timeZone": "Europe",
"locale": "en_UK"
}
{
"self": "https://example2.com",
"key": "keyTwo",
"name": "nameTwo",
"emailAddress": "mailTwo",
"avatarUrls": {
  "48x48": "https://test.com/secure/useravatar?avatarId=2",
  "24x24": "https://test.com/secure/useravatar?size=small&avatarId=2",
  "16x16": "https://test.com/secure/useravatar?size=xsmall&avatarId=2",
  "32x32": "https://test.com/secure/useravatar?size=medium&avatarId=2"
},
"displayName": "displayNameTwo",
"active": false,
"timeZone": "Europe",
"locale": "en_US"
}
'''
import json

json对象列表 = []
起始位置 = 0

# 对数据按行分割并遍历
for 索引, 行 in enumerate(数据.splitlines()):
    # 如果当前行是 "{" 且前一行是 "}"，说明找到了一个JSON对象的结束和另一个的开始
    if 索引 > 0 and 行 == "{" and 数据.splitlines()[索引 - 1] == "}":
        # 将从起始位置到当前索引的行合并，然后加载为JSON对象加入列表
        json对象列表.append(json.loads("".join(数据.splitlines()[起始位置:索引])))
        起始位置 = 索引  # 更新起始位置到当前索引

# 将剩余部分的JSON对象加载进列表
json对象列表.append(json.loads("".join(数据.splitlines()[起始位置:])))

# 打印每个解析后的JSON对象，以缩进格式展现
for json对象 in json对象列表:
    print(json.dumps(json对象, indent=2))

Mason Wheeler · Answer

确实有些奇怪，API 返回的数据看似 JSON 却不符合 JSON 的有效格式。

不过，如果每条JSON记录遵循相同的结构，即每条记录占用固定行数（比如16行），那么你可以根据这个规律来分割数据，从而获得多个有效的JSON对象。下面是一个示例代码：

import json

data = ""  # 你的 JSON 数据字符串

# 按行分割数据
data_split = data.splitlines()

# 初始化结果列表
json_results = []

# 每16行数据组成一个有效的JSON对象
for i in range(0, len(data_split), 16):
    # 使用 join 方法组合16行数据为一个字符串
    block = "".join(data_split[i:i+16])
    # 尝试将组合的字符串解析为JSON对象并添加到结果列表
    try:
        json_results.append(json.loads(block))
    except json.JSONDecodeError:
        print(f"解析第 {i//16 + 1} 个JSON对象时发生错误，可能是数据不完整或格式有误。")

print(json_results)