How to extract Nested Json values (eg Properties) within Resource Graph Explorer?

Occasional Contributor

Hi,

 

I am aware of using mvexpand to expand an array into rows, but what is the best approach when they are nested. For example:

properties.frontendIPConfigurations[0].properties.loadBalancingRules[0].id

 

If this was in a script or PS, we would need a loop within a loop, but it seems limited within Resource Graph Explorer.

 

Many thanks

J

 

0 Replies