Check if JSON response contains a string using Powershell script

Question

$w = $wallets | ConvertTo-Json -Depth 3

{
    "result":  {
                   "wallets":  [
                                   {
                                       "name":  "W1"
                                   },
                                   {
                                       "name":  "W2"
                                   },
                                   {
                                       "name":  "W3"
                                   },
                                   {
                                       "name":  "W4"
                                   }
                               ]
               },
    "error":  null,
    "id":  "test"
}

I want to check if the JSON response above contains wallet name "W1". So I wrote this in PowerShell which doesn't work:

if ($w.wallets.name -contains "W1") {
    Write-Host "Wallet 'W1' exists"
}

How do I check something in above JSON using PowerShell?

JSON is a string representation. You'd need to convert it to a collection of objects to check properly, using ConvertFrom-Json — Geoduck
– Geoduck, Commented Jul 31, 2021 at 23:39
From that JSON the condition would be if($json.result.wallets.name -contains 'W1'){...} — Santiago Squarzon
– Santiago Squarzon, Commented Jul 31, 2021 at 23:42

Geoduck · Accepted Answer · 2021-07-31 23:57:26Z

3

JSON is a string. -contains won't work for it. You need to convert your JSON to an object.

In your example, you would just operate on $wallets and not even convert it to JSON, but let's assume your JSON actually comes from somewhere else.

$o = $w | ConvertFrom-Json

Now, you can operate on it like an object:

if ($o.result.wallets.name -contains "W1") {
    Write-Host "Wallet 'W1' exists"
}

answered Jul 31, 2021 at 23:57

Geoduck

9,0212 gold badges29 silver badges27 bronze badges

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

3 Comments

hellouniverse Over a year ago

($o.wallets.name -contains "W1") in if condition works from shell when $o is pastebin.com/raw/nibSGKpM But it doesn't work when I send a POST request to API with ConvertFrom-Json it returns error: ConvertFrom-Json : Invalid JSON primitive: and without it $o =$w is pastebin.com/raw/hMqNVXtv. Something wrong with API or I need to use something else when using POST request? Tried lot of things but nothing works

hellouniverse Over a year ago

I have shared the script that worked for me in the answer

Geoduck Over a year ago

That looks like a completely different issue. At a glance, it looks like $w is your wallets array already, so you would just do $w.name -contains "W1", but you'd have to post a full question with how you are setting $w

hellouniverse · Accepted Answer · 2021-08-01 00:43:58Z

0

Not sure how did it get resolved but below script works:

if ($w.Contains("W1")) {
    Write-Host "Wallet 'W1' exists"
}

answered Aug 1, 2021 at 0:43

hellouniverse

1232 silver badges12 bronze badges

2 Comments

Daniel Over a year ago

You changed from using $w.wallets.name -contains "W1" to $w.Contains("W1"). -contains and .Contains() work differently.

Theo Over a year ago

This is not good... using the string method .Contains() on the whole JSON string may return $true also when some other element or even element Name happens to contain the (sub)string "W1". You really need to use the -contains or -in operator to check for that value in an array. As @GarrGodfrey commented, do $wallets.result.wallets.name -contains 'W1' or alternatively 'W1' in $wallets.result.wallets.name. (if you need case sensitive matching, use -ccontains or -cin)

Collectives™ on Stack Overflow

Check if JSON response contains a string using Powershell script

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related