erktrek
September 8, 2020, 12:38am
3827
Jsonata is actually kind of nice.. xquery for JSON. You can do a ton of things like referencing variables $flowContext() / $globalContext() and environment variables $env().
Really spiffy is recursion....
Stupid JSONATA Tricks...
In JSONATA you can grab the value of a property of the message object by doing something like this:
$lookup('payload');
If you try and go "deeper" this does not work:
$lookup('payload.value');
As far as I can tell there is no simple command to do this in JSONATA directly.. but with some functional/recursion trickery you can:
(
$getkey := function($x,$keyVal){
$count($split($keyVal,'.')) > 1
? $x ~> $lookup($split($keyVal,'.')[0]) ~> $getkey($substringAfter($key…
And use it in a change node..
1 Like
