Parse JSON with Powershell, different element name with every parse

Question

I have similar JSONs like this and I want parse these JSONs with Powershell.

{
  "$schema": "./node_modules/@angular/cli/lib/config/schema.json",
  "version": 1,
  "newProjectRoot": "projects",
  "projects": {
    "my-app": {
      "projectType": "application",
      "schematics": {
        "@schematics/angular:component": {
          "style": "scss"
        }....

I can do it with command $angularJsonPSO.projects."my-app".projectType for every single JSON but I want some generic command for all these JSONs. Something like "...projects.*.projectType...". How is possible do it this way ?

$angularJson = Get-Content -Raw -Path "./angular.json"
$angularJsonPSO = $angularJson | ConvertFrom-Json -Depth 10
$projectName = $angularJsonPSO.projects."my-app".projectType

Thank you very much for any answer.

$projectName = $angularJsonPSO.projects | ForEach-Object { $_.PsObject.Properties.Value.projectType } — Theo
– Theo, Commented Oct 21, 2022 at 11:15
As an aside: There is usually no need for -Depth when reading JSON (ConvertFrom-Json - except if your JSON has more than 1024(!) nesting levels). -Depth is only important when writing JSON, however (ConvertTo-Json), because the default depth is then, unfortunately, 2. See this answer for more information. — mklement0
– mklement0, Commented Oct 21, 2022 at 11:32

Mathias R. Jessen · Accepted Answer · 2022-10-21 11:12:12Z

2

Use the hidden psobject memberset to access each property of the projects object:

$angularJson = Get-Content -Raw -Path "./angular.json"
$angularJsonPSO = $angularJson | ConvertFrom-Json -Depth 10

foreach($projectProperty in $angularJsonPSO.projects.psobject.Properties) {
  $projectName = $projectProperty.Name
  $project = $projectProperty.Value

  # now you can access projectType like this
  $project.projectType
}

answered Oct 21, 2022 at 11:12

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

Parse JSON with Powershell, different element name with every parse

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related