Ok, to keep things separate: I'm stuck now with a message I have made with a python3 script to make a JSON message. The message as given is: {"ssid": "Marys_Farm_2.4", "signal_level": "-72"} {"ssid": "PiNet", "signal_level": "-70"} {"ssid": "Optus_ABA172_5GHz", "signal_level": "-48"} {"ssid": "Ma…

As (I think) everyone has agreed, it is best to fix any message format problems at source, so I have taken another look at the Python script you posted in the other thread. Here is the script as I modified it, with comments to explain the change. Essentially I'm making a Python dictionary for each…

It would be better to do it correctly in python to start with.

Yes, agreed. But as I said: That is a beyond vertical curve just now. I'll run off and see what I can learn ITMT. Thanks.

(Sorry) Searching and trying to understand. Found this link Write json into file Python 3 - Stack Overflow But in those examples the JSON parts are not separated with a , They are just appended to one another - as I kind of have. (Ok, mine have a \n between them) So I am missing something in…

Ideally you would only send valid json. However, of this is all you have then in a function... msg.payload = JSON.parse(`[ ${msg.payload.split('\n').join(',')} ]`) return msg untested

(Sorry for late/slow reply) That's in a function node in NR - yes? Just as DCJ said: Better to keep it all in python.

[image] Trying_to_learn: That's in a function node in NR - yes Yes: [image] Steve-Mcl: in a function... [image] Trying_to_learn: Just as DCJ said: Better to keep it all in python As did I... [image] Steve-Mcl: Ideally you would only send valid json But I gave you an (un…

I am not having a good time just now. My parsing system is not as good as I would like. Sorry. I'll see what happens. But initial test gives me: SyntaxError: Unexpected token , in JSON at position 3 I'll work on that and see what I can work out.

Change it to this: const json = `[ ${msg.payload.split('\n').join(',')} ]` node.warn({json}) msg.payload = JSON.parse(json) return msg [/quote] What do you see?

Just before I do that: (Not having a go at you) I stuck some debug nodes in the code. Going in is one big message. After that node it has split them into single messages. (See below) Going in: {"ssid": "Marys_Farm_2.4", "signal_level": "-49"} {"ssid": "Marys_Farm_5", "signal_level": "-53"} {"…

[image] Trying_to_learn: But it isn't JSON format. :frowning: (I think) It is valid json. [Screenshot_20230625-013446] Check for yourself: https://jsonlint.com/ Actually, if you look at your debug, you can see it has been parsed to a js array of objects. But then you run it through JSON n…

Node-RED

Node-RED Forum

More fun with message formatting

General

jbudd 26 June 2023 07:11 21

https://discourse.nodered.org/t/bar-chart-colours/79327

Topic		Replies	Views
Get multiple charts from json file Dashboard	34	2382	26 March 2021
Graph with stored data Dashboard	29	5914	26 October 2020
WAP list with graph - help please General	26	326	7 July 2023
Message handeling..... stuck General	21	915	7 June 2019
Join outputs from two python scripts into one message General function-node	18	559	2 November 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.

More fun with message formatting

Related topics