In an exchange on this post, I shared a custom function which I once wrote, which can be used to "flatten" a JSON object.
The flattened output can take a few different forms, including:
- A CR-delimited list of all paths found within the object
- A CR-delimited list of all the values found at the various node-endpoints
- JSON Array or JSON Object output, which returns both paths and values
The original version of the CF that I posted had a bad bug in it. The version shared with this post has a fix in place for the bug, updated comments, and also a suite of simple tests to help ensure quality.
The CF comes with a few limitations, which are explained in the comments.
I hope that it may be helpful to some.
Array of Paths and Values Output:
Test Case Screenshot: