JSON Serialization/Deserialization in PowerShell

Since PowerShell is based on .NET and makes it easy to access .NET functionality, PowerShell can use JSON serializer that comes with .NET.  The follow snippet of code shows how to deserialize a JSON string into an XML object and then how to take an XML object and serialize it to JSON;

   1: Add-Type -Assembly System.ServiceModel.Web,System.Runtime.Serialization

   2:  

   3: function Convert-JsonToXml([string]$json)

   4: {

   5:     $bytes = [byte[]][char[]]$json

   6:     $quotas = [System.Xml.XmlDictionaryReaderQuotas]::Max

   7:     $jsonReader = [System.Runtime.Serialization.Json.JsonReaderWriterFactory]::CreateJsonReader($bytes,$quotas)

   8:     try

   9:     {

  10:         $xml = new-object System.Xml.XmlDocument

  11:  

  12:         $xml.Load($jsonReader)

  13:         $xml

  14:     }

  15:     finally

  16:     {

  17:         $jsonReader.Close()

  18:     }

  19: }

  20:  

  21: function Convert-XmlToJson([xml]$xml)

  22: {

  23:     $memStream = new-object System.IO.MemoryStream

  24:     $jsonWriter = [System.Runtime.Serialization.Json.JsonReaderWriterFactory]::CreateJsonWriter($memStream)

  25:     try

  26:     {

  27:         $xml.Save($jsonWriter)

  28:         $bytes = $memStream.ToArray()

  29:         [System.Text.Encoding]::UTF8.GetString($bytes,0,$bytes.Length)

  30:     }

  31:     finally

  32:     {

  33:         $jsonWriter.Close()

  34:     }

  35: }

  36:  

  37: $str = '{"fname":"John", "lname":"Doe", "age":42, "addr":{"city":"Gotham", "street1":"123 Guano Way", "state":"NY"}}'

  38:  

  39: $xml = Convert-JsonToXml $str

  40: $xml.root.fname

  41: $xml.root.lname

  42:  

  43: $json = Convert-XmlToJson $xml

  44: $json

Note that this does require .NET 3.5.  However it serves to show that when you’re looking for some functionality, if you can’t find it in cmdlet or module form first, check the .NET framework next.  You would be surprised what kind of cool functionality you can find in there.  There’s a bit more to this story.  You can use the WCF DataContractJsonSerializer to bypass XML and directly serialize/deserialize .NET types.  I can’t take credit for this idea though – that was Jaykul’s.

About these ads