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

%3CLINGO-SUB%20id%3D%22lingo-sub-1814929%22%20slang%3D%22en-US%22%3EHow%20to%20extract%20Nested%20Json%20values%20(eg%20Properties)%20within%20Resource%20Graph%20Explorer%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814929%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20aware%20of%20using%20mvexpand%20to%20expand%20an%20array%20into%20rows%2C%20but%20what%20is%20the%20best%20approach%20when%20they%20are%20nested.%20For%20example%3A%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Eproperties%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3CSPAN%3EfrontendIPConfigurations%3C%2FSPAN%3E%3CSPAN%3E%5B%3C%2FSPAN%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%5D.%3C%2FSPAN%3E%3CSPAN%3Eproperties%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3CSPAN%3EloadBalancingRules%3C%2FSPAN%3E%3CSPAN%3E%5B%3C%2FSPAN%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%5D.%3C%2FSPAN%3E%3CSPAN%3Eid%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20was%20in%20a%20script%20or%20PS%2C%20we%20would%20need%20a%20loop%20within%20a%20loop%2C%20but%20it%20seems%20limited%20within%20Resource%20Graph%20Explorer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3EJ%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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