c# - 从 C# 中的 JSON 响应中删除所有出现的特定键

Question

我有一个 JSON 字符串，我想从中消除给定键的所有出现。

JSON 我有：

string requstBody =       
{
              "payLoad": [
                {
                  "BaseVersionId_": 9,
                  "VersionId_": 10,              
                  "AssetCollateralLink": [
                    {
                      "AssetId": 137,
                      "BaseVersionId_": 9,
                      "VersionId_": 10
                    },
                    {
                      "AssetId": 136,
                      "BaseVersionId_": 0,
                      "VersionId_": 1
                    }
                  ],
                  "CollateralProvider": [],
                  "AdvCollateralAllocation": [
                    {
                      "LinkId": 91,
                      "IsDeleted_": false,
                      "BaseVersionId_": 1,
                      "VersionId_": 2
                    }
                  ]
                }
              ]
            }

我想消除键“BaseVersionID_”和“VersionId_”如下：

  string requstBody =  
{
              "payLoad": [
                {
                  "AssetCollateralLink": [
                    {
                      "AssetId": 137
                    },
                    {
                      "AssetId": 136
                    }
                  ],
                  "CollateralProvider": [],
                  "AdvCollateralAllocation": [
                    {
                      "LinkId": 91,
                      "IsDeleted_": false
                    }
                  ]
                }
              ]
            }

我使用了 JObject.Remove(); 如下

JObject sampleObj1 = new JObject();
sampleObj1 = JsonHelper.JsonParse(requestBody);
sampleObj1.Remove("BaseVersionId_");

但只能删除 payLoad Hierarchy 下的键。如何删除所有出现的 Key。

标签： c#jsonjobjectformatter

Answer 1

我会这样使用 JsonPath：

var toRemove =  jsonObject
                .SelectTokens("$.payLoad.[*].AssetCollateralLink.[*]..BaseVersionId_")
                .Concat(stuff.SelectTokens("$.payLoad.[*].AssetCollateralLink.[*]..VersionId_"))
                .Concat(stuff.SelectTokens("$.payLoad.[*].AdvCollateralAllocation.[*]..VersionId_"))
                .Concat(stuff.SelectTokens("$.payLoad.[*].AdvCollateralAllocation.[*]..BaseVersionId_"))
                .ToList();

for (int i = toRemove.Count - 1; i >= 0; i--)
{
    toRemove[i].Parent?.Remove();
}