I have a nested array that I'm trying to find a specific key/value in. Path: payload[0][11].mac Value: 10:2b:41:11:c8:b6 To find the value I'm iterating using forEach: msg.payload.forEach(function (key,value) { if (value == '10:2b:41:11:c8:b6') { node.warn("Found!") } }); Howeve…

If it is always a 2 level array then a simple for loop followed by a filter will do it... const findMac = msg.topic const data = msg.payload const foundEntries = [] for (let index = 0; index < data.length; index++) { const element = data[index] foundEntries.push(... element.filter(e => e.ma…

Ok, so here is the JSONata (to satisfy my mind)... $filter(payload.**, function($v, $i, $a) { $v.mac = topic }) [image] Demo Flow... [{"id":"945d1ab3b1d5ed07","type":"inject","z":"57d91feb40155fe2","name":"find mac 10:2b:41:11:c8:b6","props":[{"p":"topic","vt":"str"}],"repeat":"","crontab":"","…

Just to note the JSONata $filter function is not required, this should work [$$.payload.**[$.mac = $$.topic]]

At least I tried JSONata :wink: :rofl:

I see, i'm still recovering from the shock!

Just goes to show why any sensible person would use a function node. :wink:

Thanks guys, a lot of good suggestions that pointed me the right way. I ended doing it like this, which is useful for whatever key in whatever depth :slight_smile: function recurse(data) { data.forEach(function (element){ if(Array.isArray(element)) { recurse(element); …

Node-RED

Node-RED Forum

How can I iterate recursivly throgh msg.payload to find a specific key/Value

General

system Closed 19 January 2023 22:03 9

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How to split an array based on an element within the array? General	15	1910	19 March 2021
Search for data in msg. payload based on values within payload. Is this possible? General	10	1376	11 November 2020
Iterating CSV msg.payload array General	5	1677	14 September 2019
More jsonata array filtering General jsonata	21	430	1 May 2023
Search string in array General function-node	10	948	23 May 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How can I iterate recursivly throgh msg.payload to find a specific key/Value

Related topics