ConvertFrom-Json not parsing array within array

Question

The json payload look like this:

{
  "clients": [
    {
      "scope": "scope1",
      "claim": "scope1",
      "id": ["123", "567"]
    },
    {
      "scope": "scope2",
      "claim": "claim2",
      "id": ["321", "765"]
    }
  ]
}

When try to get the json in pwsh variable, I'm not getting the id values and it just displays System.Object[].

> $inputjson = (((get-content .\inputfile.json) -Join " " ) | convertfrom-json )

> echo $inputjson

 clients                                                                               
 -------                                                                 
 {@{scope=scope1; claim=scope1; id=System.Object[]}, @{scope=scope2; claim=claim2; id=System.Object[]}}

Any help on how to get these array with array values?

you still can access the values, try $json.clients without echo. and $json.clients[0].id for example will return the ids for the scope1 — Santiago Squarzon
– Santiago Squarzon, Commented May 6, 2021 at 3:33
@SantiagoSquarzon : Thanks. I can access it, but the actual problem is the API is not accepting the payload because of this System.Object[] in "id" field. I'm using Invoke-RestMethod -Method POST -Headers $headers -Body $inputjson -Uri $uri to call the API — Zeigeist
– Zeigeist, Commented May 6, 2021 at 3:46

Zeigeist · Accepted Answer · 2021-05-06 04:58:52Z

0

As @SantiagoSquaron said in the comment, we could access the array content by $inputjson.clients[0].id. Thanks @SantiagoSquaron.

answered May 6, 2021 at 4:58

Zeigeist

4,0554 gold badges23 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

ConvertFrom-Json not parsing array within array

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