Hi @knolleary
Firstly, really appreciate such quick response, as I live in NZ, I tought it is middle of the night elsewhere in the world and everyone is asleep when I posted.
This is magic! I ve spent the last two days searching the internet, but getting frustrated and more confused. Your advise is invaluable for a beginner like me and the best way to learn is by example (as shown by you). One example worth a thousand words.
I used the change node and hey presto it works.
I think I did try the change node before with the same json object, but I think I used "json" instead of "expression type". Have to admit I do not quite understand jsonata.
Also tried the function node and also works, it makes sense.
Do not quite understand the template node and why {{ }} the payload.
Thanks again.
Ken Kok
NZ
