Hi, Please could someone help me to extract a number of variable values from a JSON object returned by my home automation controller - please see screen shot attached To start with I’m looking to extract the values you can see opened, I’ve tried a functions with variations of msg.payload[0][0][0] …

The docs have a guide on understanding the structure of a message: https://nodered.org/docs/user-guide/messages#understanding-the-structure-of-a-message In particular, it explains how the debug sidebar can be used to get the full path to any message element copied straight to your clipboard. Nick

Thanks Nick I recall looking at this now, [image] knolleary: the debug sidebar can be used to get the full path to any message element copied straight to your clipboard. One point of feedback, on the above feature is that these buttons do not seem to work on my iPad with Safari, I’ve tried …

if you google “javascript wildcard” you’ll find loads of tutorials that will help you

What do you get as output if you inject your msg.payload to this change node ? [r-01] [{"id":"c28f4e65.7b03f","type":"tab","label":"Flow 7","disabled":false,"info":""},{"id":"78dc82cc.d458bc","type":"change","z":"c28f4e65.7b03f","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"**.state…

[image] nodecentral: iPad with Safari Unfortunately, Safari is a long way behind current standards I think. Also security is different on mobile devices.

Many thanks @Andrei , that looks good and seems to do the trick nicely :grin:. I had looked up various things online about how to do javascript wildcards; but as I’m not a programmer - it talked about regex and other things, which I struggle with to apply - I had hoped it would be as simple as an as…

Taking it one step further, I had hoped this would work so I could start dissecting the JSON into individual values I could then work with .. is there a way to do this within a single node ? (I looked at the split node but that does not look like it will help.) Or is the only way via separate Chan…

[image] nodecentral: dissecting the JSON into individual values I could then work with Perhaps it is possible to build another jsonata expression (a little bit more complex). I will give it a try.

Well, just changing the expression as below may achieve both goals: a) use only one node and b) extract the values... **.states[[18..19]].value However I am not sure if this will help you at the end of the day. The above will produce an array with the extracted values but you will not know to whic…

Thanks again for your help on this @Andrei What I’m trying to do is create a (human understandable) device report / health message, one that can either be sent out via email, or a notification (Prowl) or spoken (via text to speech). So on demand I can then request (or schedule) a specific device n…

Node-RED

Node-RED Forum

Extract multiple variables from a JSON object

General

Colin 22 February 2021 20:59 21

Please don't open another thread when you have already started a thread about this. I am closing this thread as it is two years old.

Topic		Replies	Views
Extract a variable of a Json General	17	1766	24 December 2020
Extract values JSON string from pcap General	32	1502	7 November 2020
Jsonata test works but doesn't in the flow Developing Nodes	16	1062	6 January 2021
Parsing nested object with wildcard General	17	1591	19 May 2021
Split JSON Object Array General	34	1143	8 November 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.

Extract multiple variables from a JSON object

Related topics