Extract latest attribute

Third party integrations Node-RED
1

guys, need some help again.
i want extract latest notification from attributes, but im stuck…
payload is:

image
image523×686 26.7 KB

path is data.attributes[“2023-05-28 08:13”] but attribute name changes… any help?

2

The JSONata expression you require is

(
$keylist:=data.attributes.$keys()[$contains($," ")];
$lookup(data.attributes, $keylist[-1])
)

Edit - neater code…
(
$a:=data.attributes;
$k:=$keys($a)[$contains($,":")];
$lookup($a, $k[-1])
)

3

thanx but i need more guides… where should i write this json?

image
image878×647 22.5 KB

4

You did not post your flow, and only a picture of the data, so I had to guess as to what you really wanted.

Note- this is a JSONata (expression), not JSON (data structure). It can either go into a change node, or directly into the output property option of the current state node.

If, as you have above, you are saving the entity value into msg.data, then you can use a following change node, and in that set msg.payload to the outcome of the JSONata expression above - use the ‘J:’ option.

Alternatively, you can do this directly in the current state node.

  • set msg.payload to = the J: (JSONata expression) option
  • use the modified JSONata expression as follows
(
    $a:=$entity().attributes;
    $k:=$keys($a)[$contains($,":")];
    $lookup($a, $k[-1])
)

This should work, but I can’t test this in full.
You also don’t really need the msg.data property, so you can delete this from the list if you like.

5

Perfect. THANK YOU!