Using Json Variable In Powershell

Question

I have some code that returns some data from a database in the following json format:

{
    "dateTime":  "2021-01-27T10:26:19.595198+11:00",
    "sessionId":  "apples",
    "userId":  "exampleUser"
}

For an operation I wish to perform I need to take only the "userId" from this response, how would I do this in Powershell?

question from:https://stackoverflow.com/questions/65910783/using-json-variable-in-powershell

Answer 1

Use ConvertFrom-Json and the Member access operator . (dot):

$data = @'
{
    "dateTime":  "2021-01-27T10:26:19.595198+11:00",
    "sessionId":  "apples",
    "userId":  "exampleUser"
}
'@

($data | ConvertFrom-Json).userId