Payload binary to Json object

General
1

Hi everyone, i have a problem to convert data in binary to JSON Object.

I read this binary buffer from websocket:

imagen
imagen333Ă—232 3.73 KB

This is the same in string payload

imagen
imagen333Ă—152 4.16 KB

when i use a function with msg.payload= msg.payload.toString(); i get the same string but with double quotation marks, the JSON node here dont works

I m stuck from this, because i dont get the way to parse this and get an object, later i want to parse to handle a bridge with modbus tcp, but please help me with this, because i test some solutions on the forum and no ones works :confused:

Regards.

2

Did you try:

msg.payload = JSON.parse(msg.payload.toString())
1 Like
3

Yes i try that and dont work , this is the result

imagen
imagen334Ă—112 3.35 KB

4

Maybe instead of a picture of your screen you could share the actual buffer data?

The debug window shows a "Copy value" button on every message.

In the forum click the </> button and paste your copied data.

5

Spot the difference:

image
image1041Ă—372 23.5 KB

In short, your data has quotes around it making it invalid JSON.

If you can affect the thing sending the data, you should correct it there.

Failing that, you need to strip off the outer quotes before parsing.

e.g...

  if (msg.payload.length >= 2 && msg.payload.startsWith('"') && msg.payload.endsWith('"')) {
    msg.payload = msg.payload.slice(1, -1)
  }
2 Likes
6

Hi i solve this, using msg.payload=msg.payload.toString(); on a function, later use the JSON node to converting to a JavaScript Object, and its done!

Thanks you all for your support