Just wondering if anyone knows an easy way to convert between different types of JSON? I've had a look at an online converter but it wanted to wrap each row in curly quotes whereas I'm after:- { "111222333": "the ball and chain", "123456789": "ted", "213546879": "harry", "312645978"…

Hi @dclear I'm not clear from your two example pieces of JSON which you want to convert into the other. Although your post suggests you are starting with something else entirely and you want to get to the first example, but some online tool has given you the second example. Exactly what format are…

[image] dclear: convert between different types of JSON Also do you mean JSON (which means the data is a string) or do you mean javascript objects?

You are looking for a kind of "transpose" function ? Try a function node: a = msg.payload // array input o = {} for(x=0;x<a.length;x++){ o[a[x].number] = a[x].name } return {payload:o} Output: { "111222333": "the ball and chain", "213546879": "harry", "312645978": "bi…

[image] bakman2: a = msg.payload // array input I don't think the input is an array. I think Object.entries() may be useful here. [image] Object.entries() - JavaScript | MDN The Object.entries() static method returns an array of a given object's own enumerable string-keyed proper…

His input is an array and he wants the ouput as he showed in the first part of his post (it's written in reverse), unless I completely lost it.

Oh, sorry, you are right, I thought he wanted to convert the first to the second, but it is the other way round.

@bakman2 @Colin this is why I asked him to clarify because I think it is ambiguous as to what formats he has.

Node-RED

Node-RED Forum

Convert between different types of JSON

General

dceejay 30 April 2020 13:33 10

It's a follow on / related to this thread How to receive a phone number by MQTT then perform an Excel style vlookup to obtain a caller name?

Topic		Replies	Views
How to convert json General	3	316	22 August 2021
Convert some JSON General	2	361	6 June 2018
Transpose the Object/Array General	9	382	28 December 2022
Java Script Object to Json array General	22	1202	14 April 2020
Transform data from array General	11	794	9 January 2023

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.

Convert between different types of JSON

Related topics