json - 将 SQL 查询的结果与来自 Invoke-RestMethod 的 JSON 结果匹配

Question

我有两个 JSON 文件，我需要匹配相似的数据并只返回匹配的数据。1 个文件是 SQL 查询的结果，另一个是 Invoke-RestMethod Get 请求的结果

我试图将不同的 json 数据存储到数组中，但我能够正确地深入到 JSON 对象中

[这里是两个 JSON 文件] SQL 查询结果 JSON 文件：

[
    {
        "OnCallTeamName":  "1 Park Ave Support Corporate Desktop Support Teams",
        "ContactPrimaryLoginID":  "chungn03",
        "ContactSecondaryLoginID":  "chungn03",
        "FirstEscalationLoginID":  "giakog01",
        "SecondaryEscalationLoginID":  null
    },
    {
        "OnCallTeamName":  "14 Wall Street Support Corporate Desktop Support Teams",
        "ContactPrimaryLoginID":  "gendua01",
        "ContactSecondaryLoginID":  "gendua01",
        "FirstEscalationLoginID":  "giakog01",
        "SecondaryEscalationLoginID":  null
    },
        "OnCallTeamName":  "WUH Technology Managers",
        "ContactPrimaryLoginID":  "corond01",
        "ContactSecondaryLoginID":  "carela02",
        "FirstEscalationLoginID":  "corond01",
        "SecondaryEscalationLoginID":  null
    },
    {
        "OnCallTeamName":  "Xper",
        "ContactPrimaryLoginID":  "greenj23",
        "ContactSecondaryLoginID":  "greenj23",
        "FirstEscalationLoginID":  "daniet02",
        "SecondaryEscalationLoginID":  null
    }
]

REST 调用 JSON 文件：

[
    {
        "group_name":  "Outage Management Team",
        "group_onlinemembers":  [
                                    {
                                        "user_username":  "moraly01",
                                        "user_firstname":  "Yvette",
                                        "user_lastname":  "Morales",
                                        "user_id":  "58"
                                    }
                                ]
    },
    {
        "group_name":  "Ivanti HEAT",
        "group_onlinemembers":  [
                                    {
                                        "user_username":  "vasquj01",
                                        "user_firstname":  "Jose",
                                        "user_lastname":  "Vasquez",
                                        "user_id":  "148"
                                    },
                                    {
                                        "user_username":  "moraly01",
                                        "user_firstname":  "Yvette",
                                        "user_lastname":  "Morales",
                                        "user_id":  "58"
                                    }
                                ]
    },
    {
        "group_name":  "Telecommunications",
        "group_onlinemembers":  [
                                    {
                                        "user_username":  "moraly01",
                                        "user_firstname":  "Yvette",
                                        "user_lastname":  "Morales",
                                        "user_id":  "58"
                                    },
                                    {
                                        "user_username":  "fernad04",
                                        "user_firstname":  "David",
                                        "user_lastname":  "Fernandez",
                                        "user_id":  "150"
                                    },
                                    {
                                        "user_username":  "efg213",
                                        "user_firstname":  "Edwin",
                                        "user_lastname":  "Guerrero",
                                        "user_id":  "76"
                                    },
                                    {
                                        "user_username":  "reyesl07",
                                        "user_firstname":  "Louis",
                                        "user_lastname":  "Reyes",
                                        "user_id":  "75"
                                    }
                                ]
    },
    {
        "group_name":  "NYU Data Center Operations",
        "group_onlinemembers":  [

                                ]
    }
]

我需要知道如何使用 powershell 循环遍历这些 JSON 文件并只提取匹配项

标签： jsonpowershell