How to get particular values from JSON using powershell

Question

I have to get the values from JSON file for my test report purpose. Can anyone help me how get values of passes, failure from the below JSON data.

    {
  "stats": {
    "suites": 2,
    "tests": 4,
    "passes": 3,
    "pending": 0,
    "failures": 0,
    "start": "2021-11-05T15:58:26.817Z",
    "end": "2021-11-05T15:59:26.701Z",
    "duration": 55162,
    "testsRegistered": 4,
    "passPercent": 75,
    "pendingPercent": 0,
    "other": 0,
    "hasOther": false,
    "skipped": 1,
    "hasSkipped": true
  },
}

I have tried below code, but not getting correct result

$json= Get-Content -Raw -Path 'C:\report.json' | ConvertFrom-Json
write-host "passes : $($json.passes)"
write-host "failures : $($json.failures)"

Result:

$json= Get-Content -Raw -Path 'C:\report.json' | ConvertFrom-Json
write-host "passes : $($json.passes)"
write-host "failures : $($json.failures)"
passes : 
failures :

Edit: I have got the solution by adding below code

$json= Get-Content -Raw -Path 'C:\report.json' | ConvertFrom-Json
write-host "passes : $($json.stats.passes)"
write-host "failures : $($json.stats.failures)"

The json you show is invalid (the final comma after the closing curly bracket should not be there) or is this just part of the file? If so, please show us a sanitized version where the complete structure of the json data can be seen — Theo
– Theo, Commented Nov 7, 2021 at 20:58

Serge · Accepted Answer · 2021-11-07 13:29:14Z

1

try this

$json= Get-Content -Raw -Path <jsonFile>.json | ConvertFrom-Json
//or
$json = $response | ConvertFrom-Json //if you have it from url


write-host "passes : $($json.passes)"
write-host "failures : $($json.failures)"

edited Nov 7, 2021 at 13:29

answered Nov 7, 2021 at 13:19

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

Comments

BugBee · Accepted Answer · 2021-11-14 11:59:12Z

0

I have got the solution by adding below code

$json= Get-Content -Raw -Path 'C:\report.json' | ConvertFrom-Json
write-host "passes : $($json.stats.passes)"
write-host "failures : $($json.stats.failures)"

Result:

passes : 14
failures : 0

answered Nov 14, 2021 at 11:59

BugBee

1391 silver badge14 bronze badges

Collectives™ on Stack Overflow

How to get particular values from JSON using powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related