In this series of posts (#tools), I will tell you about tools I use every day.
We stare with reading and getting JSON date path.
The JSON Path Finder is a very helpful tool, especially if you often work with long and multi-level JSON input. It’s easy to use, just click on the page, you should see a sample date:
If you want to get the path of the third item from the instructions table, just in the right window, find and select it. Above will be the path:
Now in JSON Path Finder click Sample to load more extensive data set, and select random property by browsing data trees:
I got a path like this:
x[290].personal.deepest.darkest.secret.that.they.have["never told anyone"]Of cores, we can use the Parse JSON step, but I frequently don’t use it, for reducing the number of steps in a flow.
So I have a small example of how to get data:
Next, what we must do is replace two things. The x is our outputs from a preview step. And we must replace quotation marks (") with the single quotation marks ('):
x[290].personal.deepest.darkest.secret.that.they.have["never told anyone"]outputs('JSON')[290].personal.deepest.darkest.secret.that.they.have['never told anyone']Okay, so far, is good. Let’s assume what happened if that path won’t be existing in the outputs? PA will return network error, so me must do one other amendment to the path:
outputs('JSON')[12]['personal']?['deepest']?['darkest']?['secret']?['that']?['they']?['have']?['no secret']
On the left, I have:
//Compose 1
outputs('JSON')[290].personal.deepest.darkest.secret.that.they.have['never told anyone']
//Compose 1 - bad
outputs('JSON')[12]['personal']?['deepest']?['darkest']?['secret']?['that']?['they']?['have']?['no secret']//Compose 2
outputs('JSON')[290].personal.deepest.darkest.secret.that.they.have['never told anyone']
//Compose 2 - bad
outputs('JSON')[290].personal.deepest.darkest.secret.that.they.have['no secret']I put each branch in [' and '] chars, and the period (.) replaced with a question mark (?) char.Now, if Power Autome hits a non-existent branch, it returns empty (null) data.
And that’s all. Have a lovely day!