Hello Everyone, Thanks in advance for everyone that helps here! Issue: I have msg.payload1.value.values that has over 100 arrays. I am wondering how to I output the data in sections like node red does? See pic below. My end goal is to have this data display in the dashboard in blocks of 10. [image] [image]

picture? kinda want to see your output after all of this :slight_smile: you got it plugged into your data not the mimmic we made? Any questions? do you see how / under stand how value.instance and value.type work in the function ? reformatted_Obj['Array [' + index_number + ']' + ' type: ' + current_element_inside_index_number.value.type

Ok so for step one of any one wanting to help you out is to get the data that needs to be manipulated. It can be static and a one off So you create a flow like this: [{"id":"3d8b5600.b8529a","type":"inject","z":"32b9138.e8e466c","name":"","topic":"","payload":"","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":370,"y":320,"wires":[["edbb9fbe.c16818"]]},{"id":"9d4b75a8.a7b28","type":"debug","z":"32b9138.e8e466c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":750,"y":320,"wires":[]},{"id":"edbb9fbe.c16818","type":"function","z":"32b9138.e8e466c","name":"FAKE MSG.PAYLOAD","func":"\n\nmsg.payload1 = \n{\n \"value\":\n {\n \"len\":644,\n \"objectId\":\n {\n \"unknown\":'unknown'\n },\n \"property\":\n {\n \"unknown\":'unknown'\n },\n \"values\":\n [\n 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47\n ]\n }\n}\n \n\n\n\nreturn msg;\n","outputs":1,"noerr":0,"x":560,"y":320,"wires":[["9d4b75a8.a7b28"]]}] Please import this into a flow as you can see it creates a mimmic of your msg.payload1 without needing to have all of your nodes. [helpme] I can see it goes deeper tan the array I made. can you pleas edit/finish the code to create a good mimmic of your msg.payload1

each {"type":12,"value":{"type":2,"instance":3001614}}, is an array the data i really want is {"type":2,"instance":3001614} lol i planed on doing splinting and sorting to achieve getting just this value.

This works with your payload m = msg.payload.payload1.value.values let i,j,t,c=10; for (i=0,j=m.length; i<j; i+=c) { t = m.slice(i,i+c); node.send({payload:t}) }

[image] meeki007: [{"id":"3d8b5600.b8529a","type":"inject","z":"32b9138.e8e466c","name":"","topic":"","payload":"","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":370,"y":320,"wires":[["edbb9fbe.c16818"]]},{"id":"9d4b75a8.a7b28","type":"debug","z":"32b9138.e8e466c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":750,"y":320,"wires":},{"id":"edbb9fbe.c16818","type":"function","z":"32b9138.e8e466c","name":"FAKE MSG.PAYLOAD","func":"\n\nmsg.payload1 = \n{\n "value":\n {\n "len":644,\n "objectId":\n {\n "unknown":'unknown'\n },\n "property":\n {\n "unknown":'unknown'\n },\n "values":\n [\n 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47\n ]\n }\n}\n \n\n\n\nreturn msg;\n","outputs":1,"noerr":0,"x":560,"y":320,"wires":[["9d4b75a8.a7b28"]]}] how do i add the below after 0: [image]

what is carried in payload1 is valid JSON. why not to parse using proper tools?

because @Navybrandon stated he planned on making this work with the dashboard UI. Figured he needed to start somewhere

@meeki007 my flow is too large to share. it also calls upon other flows so the import limit is reached.

[{"id":"f18f1dc3.a83ae","type":"function","z":"1fea49bd.2c3b16","name":"FAKE MSG.PAYLOAD","func":"\n\nmsg.payload1 = \n{\n \"value\":\n {\n \"len\":644,\n \"objectId\":\n {\n type: 8,\n instance: 532897\n },\n \"property\":\n {\n id: 76,\n index: 4294967295\n },\n \"values\":\n [\n \"0\": {\n type: 12\n },\n \"value\": {\n type: 8,\n instance: 532897\n },\n }\n ,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47\n ]\n }\n}\n \n\n\n\nreturn msg;\n","outputs":1,"noerr":9,"x":1180,"y":860,"wires":[["ac366f78.8305e"]]}]

@bakman2 I re-ran that function and error was cannot read property of 'value' of undefined.

Node-RED

Node-RED Forum

Sort msg.payload Arrays into sections

General

meeki007 1 November 2019 16:28 26

please read https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506

Topic		Replies	Views
Split JSON Object Array General	34	1365	8 November 2024
Sort a payload array into object id's and into a UI General	11	635	27 November 2020
Sorting array values General	22	4903	1 September 2021
How to seperate value from incoming msg.payload? Dashboard	52	98352	5 December 2020
Extract from array ,object Dashboard	12	371	16 February 2024

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.

Sort msg.payload Arrays into sections

Related topics