how to convert a json-string to a hashtable

Question

How do we convert the json string into a hastable? .

Suppose I have a string such as:

{"Application":"Billing Interface","Business Area":"Interfaces","Region":"YO"}

How do we convert this to a hash table?

I'm doing this right now:

$myJsonString= 
$myJsonString.TrimEnd("}")
             .TrimStart("{")
             .Replace('":"',"= ")
             .Replace('"',"")
             .Replace(","," `n ")
$myJsonString = ConvertFrom-StringData -StringData $myJsonString

How do we convert the json string into a hastable?

AdminOfThings · Accepted Answer · 2020-02-25 17:47:20Z

2

I am not sure why you need a Hashtable specifically, but you could use ConvertFrom-Json to output a PSCustomObject and then convert to a hash table ($hash).

$myjsonstring = '{"Application":"Billing Interface","Business Area":"Interfaces","Region":"YO"}'
$myjsonstring | ConvertFrom-Json | Foreach-Object {
    $hash = @{}
    $_.PSObject.Properties | Foreach-Object {
        $hash.Add($_.Name,$_.Value)
    }
    $hash
}

Note that PowerShell Core has the -AsHashTable parameter that may work for you if you are running that version.

edited Feb 25, 2020 at 17:47

answered Feb 25, 2020 at 17:40

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jawad · Accepted Answer · 2020-02-25 17:19:43Z

1

If you take that json string you have, convert it to an object, you can access the elements by using the name of the element.

$JsonString = "{""Application"":""Billing Interface"",""Business Area"":""Interfaces"",""Region"":""YO""}"
#OR 
$JsonString = Get-Content fromFile.txt

$object = $JsonString | ConvertFrom-Json

$object.Application
$object.'Business Area'

Microsoft Docs on ConvertFrom-Json

answered Feb 25, 2020 at 17:19

Jawad

11.4k3 gold badges28 silver badges43 bronze badges

Comments

avarice · Accepted Answer · 2020-02-27 14:49:29Z

1

An easiest way to do this using .NET class System.Web.Script.Serialization.JavaScriptSerializer . Microsoft Docs Link: https://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer(v=vs.110).aspx

Add-Type -AssemblyName "System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
$jsSerializer = New-Object -TypeName System.Web.Script.Serialization.JavaScriptSerializer
$jsSerializer.Deserialize($myjsonstring, 'Hashtable')

answered Feb 27, 2020 at 14:49

avarice

15.6k3 gold badges19 silver badges38 bronze badges

Collectives™ on Stack Overflow

how to convert a json-string to a hashtable

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related