Help extract data from JSON I am receiving this JSON string from a Sonoff RF bridge: { "Time":"2020-08-12T20:55:56", "RfReceived":{ "Sync":12980, "Low":410, "High":1270, "Data":"DD80F2", "RfKey":"None" } } I just want the data. (msg.payload = DD80F2). When …

Your payload is a string. Either feed it through a JSON node or set your mqtt in node to automatically parse JSON strings. Then you can simply copy the path to the item of interest from the debug window copy path button.

Can you feed the input into a debug node and post a screenshot please? [Edit] If the debug says it is a string then feed it into a JSON node then into your function.

Are you sure that that is all contained in msg.payload (so it would be msg.payload.RfReceived.Data or might it be outside msg.payload an be msg.RfReceived.Data?

Thanks for looking at it. This is the whole object: {"topic":"tele/bridge1/RESULT","payload":"{\"Time\":\"2020-08-12T21:32:18\",\"RfReceived\":{\"Sync\":13080,\"Low\":420,\"High\":1270,\"Data\":\"DD80F2\",\"RfKey\":\"None\"}}","qos":0,"retain":false,"_msgid":"ae7c74e7.0c06a8"} [data]

[image] zenofmud: msg.RfReceived.Data Thanks- that was it. What was the giveaway? That everything was quoted?

[image] SteveMann: What was the giveaway? That everything was quoted? That & the fact it looks like JSON and it wasn't an expandable object and lastly, it was coloured as strings are in the debug node. In future, if unsure, you can do this in a function node... node.warn(typeof msg.payload)…

Node-RED

Node-RED Forum

JSON question, get one value

General

SteveMann 12 August 2020 22:30 8

Thanks- both good tips.

Topic		Replies	Views
Extracting specific data from string General	6	1197	5 March 2021
Parse json to get particular value General	6	464	24 June 2021
Undefined JSON message payload General	39	2581	26 February 2021
Issue parsing MQTT data General	3	1663	10 July 2019
How do i reference a value out of a JSON string General	16	1706	17 January 2021

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.

JSON question, get one value

Related topics