Identify JSON properties dynamically based on value

Question

Identify JSON properties dynamically based on value

Nandan Hegde 36,716 MVP Volunteer Moderator

I have a scenario wherein I am not sure what would be the JSON output values/structure as it changes based on different input values :

1st scenario :

2nd scenario:

I need the JSON property that has values like AzurekeyvaultsecretReference.

So w.r.t 1st scenario, we need
MWSAUthToken
Secretkeys as my output

and in case of 2nd scenario, output should be accountkey

@Rich Matheisen

Rich Matheisen 48,026 Reputation points

2022-12-26T15:59:35.447+00:00

Are both of your examples taken from the same object type?
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-12-26T16:27:27.827+00:00

Thank you for your response.
The above images are 2 different outputs for the same Azure rest api for different inputs based on the configurations in azure data factory.
And hence I am not sure which all aspects do have the key vault reference. So the thought is to scan all properties and check for that aspect and then drill down to those specific properties

1 answer

Your answer

Rich Matheisen 48,026 Reputation points

2022-12-26T15:59:35.447+00:00

Are both of your examples taken from the same object type?
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-12-26T16:27:27.827+00:00

Thank you for your response.
The above images are 2 different outputs for the same Azure rest api for different inputs based on the configurations in azure data factory.
And hence I am not sure which all aspects do have the key vault reference. So the thought is to scan all properties and check for that aspect and then drill down to those specific properties

Answer 1

Rich Matheisen 48,026

The Invoke-RestMethod should, in this case, be returning a PSObject. If you know the property name you should be able to access its value directly. If the property doesn't exist you'll get a $null value. You should also find the names of all the PSObject properties in the object if you want to verify whether the property exists regardless of its value.

What you've provided in your screenshots are the textual representations of the PSObject returned from two different instances of a PSObject.

Share via

Identify JSON properties dynamically based on value

1 answer

Your answer