Extract a substring from a JSON file in powershell

Question

I have a Json file with combination of strings, substrings and array as attached below.

I tried to fetch the Id using the psobject and reading the JSON file as RAW but didnt workout.

$json = (Get-Content "C:\Users\rasto\OneDrive\Desktop\Job_board\output.json" -Raw) | ConvertFrom-Json

$json.psobject.TypeNames.item

Further I tried to run loop but didnt work as well.

$data = Get-Content "Path to json file" | Out-String | ConvertFrom-Json

foreach ($line in $data) {
     $line.id
}

Json File:

{
    "data":  [
                 {
                     "id":  "146993",
                     "text":  "value1"
                 },
                 {
                     "id":  "14699",
                     "text":  "value2"
                 }
             ],
    "meta":  {
                 "newest_id":  "146",
                 "oldest_id":  "146",
                 "result_count":  79
             }
}

I want to extract the values in field "id" using PowerShell.

Output:

146993 14699

Mathias R. Jessen · Accepted Answer · 2021-12-12 13:06:45Z

1

$data is not an array, so looping over it won't make any difference. You need to dereference the data member of the the root object to get to the array that has objects with the id property:

$data = Get-Content "Path to json file" |ConvertFrom-Json
$IDs = $data.data.id

answered Dec 12, 2021 at 13:06

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

Extract a substring from a JSON file in powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related