How to Extract Specific Objects from JSON using PowerShell?

You can use a script like this:

$inputFile = ".json.json"
$outputFile = ".new_file.json"
$coreJson = Get-Content -Path $inputFile -Raw | ConvertFrom-Json -AsHashtable

$outHash = [ordered]@{}
foreach ($key in $coreJson.Keys) {
if ($coreJson.$key.earned -or $coreJson.$key.earned_time) {
$outHash[$key] = $coreJson.$key
}
}
$outHash | ConvertTo-Json | Set-Content -Path $outputFile

Just make sure to add `ConvertTo-Json` at the end to get your desired output!

If you’re open to experimenting, I wrote a quick fix to clean the JSON format:

$text = '{
"1": {
"earned": 0
},
"19": {
"earned": 1,
"earned_time": 1000000000
},
"20": {
"earned": 1,
"earned_time": 1000000000
},
"16": {
"earned": 0
}
}'

$reformatted = $text.split("`r`n") | % { if ($_ -like "*: {") {"{ value: "+$_.replace(": {","")+"," } else {$_} }
$reformatted = $reformatted.split("`r`n") | % { if ($_ -eq "{") {"[" } else {$_} }
$reformatted = $reformatted.split("`r`n") | % { if ($_ -like " }") {"]" } else {$_} }

$final_list = $reformatted | convertfrom-json

$final_list | ? {$_.earned -eq 1}

You can achieve filtering by treating the JSON like this:

$var1 = ('{
"1": {
"earned": 0
},
"19": {
"earned": 1,
"earned_time": 1000000000
},
"20": {
"earned": 1,
"earned_time": 1000000000
},
"16": {
"earned": 0
}
}' | ConvertFrom-Json)

($var1.PSObject.Properties | Where-Object Name -in ('19','20')).Value | ConvertTo-Json

This way, you can filter specific properties easily. You might find it more straightforward to manipulate them as PSCustomObjects.

Just a heads up, the structure of your JSON is not ideal. If you can, consider reformatting it. A cleaner version would be arrays with objects, like this:

[
{"value": 1, "earned": 0},
{"value": 19, "earned": 1, "earned_time": 1000000000},
{"value": 20, "earned": 1, "earned_time": 1000000000},
{"value": 16, "earned": 0}
]

Making that change will simplify your queries down the line!

Consistent JSON structure is key. Make sure every object has the same properties to streamline filtering. For instance, if "earned_time" is relevant, it should appear for each object, potentially as null or 0 where not applicable.