使用公共值合并Python中的两个JSON数组

Question

我想请您帮助解决以下问题:我有两个从API调用中生成的JSON文件，它们应该使用一个唯一的值，即序列号进行组合。第一个JSON文件，它是以以下语法重复的一千行网络设备上行链路列表：

{
    "serial": "ABCD-ABCD-ABCD",
    "model": "XYZ",
    "uplinks": [
        {
            "interface": "wan1",
            "status": "active",
            "ip": "10.10.10.2",
            "gateway": "10.10.10.2",
            "primaryDns": "8.8.8.8",
            "secondaryDns": "8.8.4.4",
            "ipAssignedBy": "dhcp"
        },
        {
            "interface": "wan2",
            "status": "not connected",
            "ip": "10.20.10.2",
            "gateway": "10.20.10.2",
            "primaryDns": "8.8.8.8",
            "secondaryDns": "8.8.4.4",
            "ipAssignedBy": "dhcp"
        }
    ]
}

第二个JSON文件，它是以以下语法重复的一千行设备库存列表：

 {
   "name": "ABC",
   "serial": "ABCD-ABCD-ABCD",
   "mac": "FF:FF:FF:FF:FF:FF",
   "networkId": "12412345235342",
   "productType": "appliance",
   "lanIp": "10.10.10.2",
   "configurationUpdatedAt": "2022-01-30T17:26:07Z",
   "url": "https://xyz"
}

我想要实现的是使用序列号作为匹配值将JSON 1“上行”部分插入到JSON2中：

{
"name": "ABC",
"serial": "ABCD-ABCD-ABCD",
"mac": "FF:FF:FF:FF:FF:FF",
"networkId": "12412345235342",
"productType": "appliance",
"lanIp": "10.10.10.2",
"configurationUpdatedAt": "2022-01-30T17:26:07Z",
"url": "https://xyz",
"uplinks": [
        {
            "interface": "wan1",
            "status": "active",
            "ip": "10.10.10.2",
            "gateway": "10.10.10.2",
            "primaryDns": "8.8.8.8",
            "secondaryDns": "8.8.4.4",
            "ipAssignedBy": "dhcp"
        },
        {
            "interface": "wan2",
            "status": "not connected",
            "ip": "10.20.10.2",
            "gateway": "10.20.10.2",
            "primaryDns": "8.8.8.8",
            "secondaryDns": "8.8.4.4",
            "ipAssignedBy": "dhcp"
        }
    ]
}

谢谢你的帮助！)

Answer 1

json1={
    "serial": "ABCD-ABCD-ABCD",
    "model": "XYZ",
    "uplinks": [
        {
            "interface": "wan1",
            "status": "active",
            "ip": "10.10.10.2",
            "gateway": "10.10.10.2",
            "primaryDns": "8.8.8.8",
            "secondaryDns": "8.8.4.4",
            "ipAssignedBy": "dhcp"
        },
        {
            "interface": "wan2",
            "status": "not connected",
            "ip": "10.20.10.2",
            "gateway": "10.20.10.2",
            "primaryDns": "8.8.8.8",
            "secondaryDns": "8.8.4.4",
            "ipAssignedBy": "dhcp"
        }
    ]
}

json2= {
   "name": "ABC",
   "serial": "ABCD-ABCD-ABCD",
   "mac": "FF:FF:FF:FF:FF:FF",
   "networkId": "12412345235342",
   "productType": "appliance",
   "lanIp": "10.10.10.2",
   "configurationUpdatedAt": "2022-01-30T17:26:07Z",
   "url": "https://xyz"
}
if json1['serial']==json2['serial']:
    json2['uplinks']=json1['uplinks']

我希望这能解决你的问题。