convertto - PowerShell cómo agregar algo en JSON analizado?

convertto-json

Question

Quiero agregar algo en mi JSON analizado usando PowerShell. Mi código:

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)
}

Mi JSON:

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

Quiero hacer BlockC así:

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

Lo intenté

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

y

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

pero no funciona con el error:

no hay método de agregar

Intenté todo lo que puedo hacer (intente Agregar método, usar Agregar miembro), pero todo ha fallado.

añadido: PS C: / Users / Develop7> $ json.BlockA.BlockC | Get-Member

 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;}

Answer 1

Recibes ese error porque tu $ json es en realidad una colección de dos objetos. Uno de ellos es un conjunto y el otro es un diccionario. Pipe la salida de la línea que carga el ensamblaje a Out-Null para evitar eso. Ejemplo:

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

Answer 2

Si está usando PowerShell 3.0 / 4.0, puede simplificar su conversión usando el cmdlet ConvertFrom-Json .

Más allá de eso, si tiene tipos de objetos PS o .Net, el cmdlet Add-Member le permite agregar propiedades arbitrarias. A continuación se muestra cómo agregar una propiedad basada en un bloque 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)