Sort objects that contain array values?

General
1

Guys,

I have an object that represents a series of prices and times - as per the screenshot below

image

What i need to do is loop through all of the objects and then sort them based on the price field (lowest to highest)

Any hints on the way to do this ?

Craig

2

With jsonata you should be able to do something like:

payload.items.$^(price)[[0, -1]]
3

Alternatively, a function node can do it:

msg.payload.items.sort( (A,B) => A.price - B.price )
return msg
4

thanks for the hints guys - will give it a whirl and report back

Craig

5

Now i know why NR is so good - if you can whip something out that quickly and easily - dropped your code into a function node chained to my previous node and BOOM - exactly what i needed - thanks Nick

Now to study up online and understand what it is doing !

Craig