请教一下 shell 里使用 jq 处理 json 应该怎么写

[Ryanjie]

如题，有一个 json 文件，

[
    {
        "id": 0001,
        "name": "Zhang.San_123456",
        "email": {
            "qqmail": "[email protected]",
            "163mail": "[email protected]"
        },
        "Address": {
            "Province": "Guangdong",
            "City": "Zhanjiang",
            "Country": "Xuwen"
        }
    },
    {
        "id": 0002,
        "name": "Li.Si_123456",
        "email": {
            "qqmail": "[email protected]",
            "163mail": "[email protected]"
        },
        "Address": {
            "Province": "Sichuan",
            "City": "Yibin",
            "Country": "Jiang'an"
        }
    },
    {
        "id": 0003,
        "name": "Wang.Wu_123456",
        "email": {
            "qqmail": "[email protected]",
            "163mail": "[email protected]"
        },
        "Address": {
            "Province": "Shanxi",
            "City": "Taiyuan",
            "Country": "Qingxu"
        }
    }
]

我想获取里面 name 字段为 Li.Si_123456 的一部分，返回时移除 email 里的 163mail ，返回内容如下：

[
    {
        "id": 0002,
        "name": "Li.Si_123456",
        "url": "http://xxx.com",
        "qqmail": "[email protected]",
        "Address": {
            "Province": "Sichuan",
            "City": "Yibin",
            "Country": "Jiang'an"
        }
    }
]

请教一下这个使用 jq 处理应该怎么写呢，有大佬能指教一下吗？谢谢了^^

[0ZXYDDu796nVCFxq]

https://stackoverflow.com/questions/49632521/how-to-add-a-field-to-a-json-object-with-the-jq-command

https://stackoverflow.com/questions/36227245/deleting-multiple-keys-at-once-with-jq

[Ryanjie]

@gstqc 谢谢大佬指教👍

[Ryanjie]

解决方法：
1. 获取里面 name 字段为 Li.Si_123456 的一部分：`jq --arg NAME ${UserName} '.[] | select(.name==$NAME)'`
2. 返回时移除 email 里的 163mail: `map({id, name, url, qqmail: .email.qqmail,...})`