json - ConvertFrom-Json : Cannot convert the JSON string because a dictionary that was converted from the string contains the duplicated keys

Question

从 OData API 服务返回以下 JSON:

{
  "d": {
    "results": [
      {
        "FileSystemObjectType": 0,
        "Id": 1,
        "ContentTypeId": "0x0100BC97B2F575CB0C42B79549F3BABD32A8",
        "Title": "Nokia California",
        "Address": "200 South Matilda Avenue\nW Washington Ave\n94086 Sunnyvale, California\nUnited States of America",
        "ID": 1,
        "Modified": "2014-02-24T10:06:39Z",
        "Created": "2014-02-24T10:06:39Z",
        "AuthorId": 12,
        "EditorId": 12,
        "OData__UIVersionString": "1.0",
        "Attachments": false,
        "GUID": "d12aafad-502a-4968-a69e-36a7ea05ec80"
      }
    ]
  }
}

并以字符串形式保存到名为 $data 的变量中

尝试使用 ConvertFrom-Json 将 JSON 格式的字符串转换为自定义对象小命令:

$results = $data | ConvertFrom-Json

给出以下错误:

ConvertFrom-Json : Cannot convert the JSON string because a dictionary that was converted from the string contains the duplicated keys 'Id' and 'ID'.

有没有办法在 PowerShell 中转换指定的 JSON 格式的字符串？

Answer 1

这是我如何处理它:

$results = $data.ToString().Replace("ID", "_ID") | ConvertFrom-Json