PowerShell 如何在解析的 JSON 上添加一些东西？

PowerShell how to add something on parsed JSON?

提问by Blank

I want to add something in my parsed JSON using PowerShell. My code:

我想使用 PowerShell 在我解析的 JSON 中添加一些内容。我的代码：

function ConvertFromJson([string]$file)
{
    [System.Reflection.Assembly]::LoadWithPartialName("System.Web.Extensions")
    $jsoncontent = Get-Content $file
    $jsonobj = New-Object System.Web.Script.Serialization.JavaScriptSerializer
    $global:json = $jsonobj.DeserializeObject($jsoncontent)
}

My JSON:

我的JSON：

{
  "BlockA": {
    "BlockB": {
      "name": "BlockB",
      "value": "Value_B"
    },
}

I want make BlockC like this:

我想让 BlockC 像这样：

{
  "BlockA": {
    "BlockB": {
      "name": "BlockB",
      "value": "Value_B"
    },
    "BlockC": {
      "name": "BlockC",
      "value": "Value_C"
    },
}

I tried

我试过

$json.BlockA.Add("BlockC", "")

and

和

$json.BlockA.BlockC.Add("name", "BlockC")

but it doesn't work with the error:

但它不适用于错误：

there is no add method

没有添加方法

I tried all of i can do (trying Add Method, use Add-Member), but all failed.

我尝试了我能做的所有事情（尝试添加方法，使用添加成员），但都失败了。

added : PS C:\Users\Develop7> $json.BlockA.BlockC | Get-Member

添加： PS C:\Users\Develop7> $json.BlockA.BlockC | 获取会员

   TypeName: System.String

Name             MemberType            Definition
----             ----------            ----------
Clone            Method                System.Object Clone()
CompareTo        Method                int CompareTo(System.Object value), int CompareTo(string strB)
Contains         Method                bool Contains(string value)
CopyTo           Method                System.Void CopyTo(int sourceIndex, char[] destination, int destinationIndex,...
EndsWith         Method                bool EndsWith(string value), bool EndsWith(string value, System.StringCompari...
Equals           Method                bool Equals(System.Object obj), bool Equals(string value), bool Equals(string...
GetEnumerator    Method                System.CharEnumerator GetEnumerator()
GetHashCode      Method                int GetHashCode()
GetType          Method                type GetType()
GetTypeCode      Method                System.TypeCode GetTypeCode()
IndexOf          Method                int IndexOf(char value), int IndexOf(char value, int startIndex), int IndexOf...
IndexOfAny       Method                int IndexOfAny(char[] anyOf), int IndexOfAny(char[] anyOf, int startIndex), i...
Insert           Method                string Insert(int startIndex, string value)
IsNormalized     Method                bool IsNormalized(), bool IsNormalized(System.Text.NormalizationForm normaliz...
LastIndexOf      Method                int LastIndexOf(char value), int LastIndexOf(char value, int startIndex), int...
LastIndexOfAny   Method                int LastIndexOfAny(char[] anyOf), int LastIndexOfAny(char[] anyOf, int startI...
Normalize        Method                string Normalize(), string Normalize(System.Text.NormalizationForm normalizat...
PadLeft          Method                string PadLeft(int totalWidth), string PadLeft(int totalWidth, char paddingChar)
PadRight         Method                string PadRight(int totalWidth), string PadRight(int totalWidth, char padding...
Remove           Method                string Remove(int startIndex, int count), string Remove(int startIndex)
Replace          Method                string Replace(char oldChar, char newChar), string Replace(string oldValue, s...
Split            Method                string[] Split(Params char[] separator), string[] Split(char[] separator, int...
StartsWith       Method                bool StartsWith(string value), bool StartsWith(string value, System.StringCom...
Substring        Method                string Substring(int startIndex), string Substring(int startIndex, int length)
ToCharArray      Method                char[] ToCharArray(), char[] ToCharArray(int startIndex, int length)
ToLower          Method                string ToLower(), string ToLower(System.Globalization.CultureInfo culture)
ToLowerInvariant Method                string ToLowerInvariant()
ToString         Method                string ToString(), string ToString(System.IFormatProvider provider)
ToUpper          Method                string ToUpper(), string ToUpper(System.Globalization.CultureInfo culture)
ToUpperInvariant Method                string ToUpperInvariant()
Trim             Method                string Trim(Params char[] trimChars), string Trim()
TrimEnd          Method                string TrimEnd(Params char[] trimChars)
TrimStart        Method                string TrimStart(Params char[] trimChars)
Chars            ParameterizedProperty char Chars(int index) {get;}
Length           Property              System.Int32 Length {get;}

回答by RickH

If you're using PowerShell 3.0/4.0 you can simplify your conversion using the ConvertFrom-Json cmdlet.

如果您使用的是 PowerShell 3.0/4.0，则可以使用ConvertFrom-Json cmdlet简化转换。

Beyond that, if you have PS or .Net Object Types, the Add-Member cmdlet allows you to add arbitrary properties. The following shows how to add a property based on a Json block:

除此之外，如果您有 PS 或 .Net 对象类型，则 Add-Member cmdlet 允许您添加任意属性。下面展示了如何基于 Json 块添加属性：

$json = @"
{
  "BlockA": {
    "BlockB": {
      "name": "BlockB",
      "value": "Value_B"
    }
  }
}
"@

$blockcvalue =@"
    {
    "name":"BlockC",
    "value":"ValueC"
    }
"@

$jobj = ConvertFrom-Json -InputObject $json

$jobj.BlockA | add-member -Name "BlockC" -value (Convertfrom-Json $blockcvalue) -MemberType NoteProperty

write-host (ConvertTo-Json $jobj)

回答by Alexander Obersht

You get that error because your $json is actually a collection of two objects. One of them is an assembly and the other one is a dictionary. Pipe output from the line that loads assembly to Out-Nullto avoid that. Example:

您会收到该错误，因为您的 $json 实际上是两个对象的集合。其中一个是程序集，另一个是字典。从加载装配线的管道输出Out-Null以避免这种情况。例子：

function ConvertFrom-Json([String]$sRawJson) {
    [System.Reflection.Assembly]::LoadWithPartialName("System.Web.Extensions") `
        | Out-Null
    $oJsSerializer = `
        New-Object System.Web.Script.Serialization.JavaScriptSerializer

    return $oJsSerializer.DeserializeObject($sRawJson)
}

$sBaseContent = @"
{
    "BlockA": {
        "BlockB": {
            "name": "BlockB",
            "value": "Value_B"
        }
    }
}
"@

$sBlockcContent  = @"
{
    "name": "BlockC",
    "value": "Value_C"
}
"@

$jsonBaseObj = ConvertFrom-Json($sBaseContent)
$jsonBlockcObj = ConvertFrom-Json($sBlockcContent)

$jsonBaseObj.BlockA.Add("BlockC", $jsonBlockcObj)
$jsonBaseObj