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)