Hi everyone, I'm new to JSONata and I'm struggling to get this right. I have some data that I need to transform for graphing in node-red. I've had a look through the documentation and examples, and I'm almost there but I can't quite get object creation working in this context. Here's a data struc…

The issue you have is where is this array , is it in payload? If so then you did not set the input array correct, it needs to be in a object with the property payload. like this https://try.jsonata.org/RfHWFmZei then you would end up with a expression [ { "series": ["Temp"], "d…

Welcome... try this thread, it may lead to what you want.. [image] MySQL to dashboard chart - change function Dashboard connect a change node to the output of the mysql node. in the change node select the j: expression option (the j: is for jsonata) click the three dots…

Thanks a lot for this. "data": [[$.{ "x": id, "y": temp }]], This was enough to match the structure I want. I feel like I tried so many permutations of this sort of syntax but could never get it to parse properly.. I think it's the extra square brackets that I wasn't trying. Th…

Yes sorry, I forgot to mention that I was testing on the jsonata.org website and I'm adding in payload on the actual node-red config. I've just spend a little bit adding some rounding and other adjustments to your code, and I'm now getting a proper line graph correctly in the dashboard, so it works! …

Node-RED

Node-RED Forum

JSONata object creation (with $each?)

General

smanjunath211 14 June 2022 11:51 2

Welcome...

try this thread, it may lead to what you want..

Topic		Replies	Views
Prepare array of JSON-Objects with jsonata through change-node for node-red-dashboard multiline-chart General node-red-dashboard , chart	7	1013	4 January 2022
How to use Jsonata on my case? General	9	2337	9 October 2020
Influx + JSONata + Multiline Chart Dashboard	10	977	8 September 2020
Jsonata in Node-Red not working as for example on try.jasonata or in the Node-Red Test UI General	3	731	16 August 2021
JSONata exception -- JSONata expression help please General jsonata , change-node	17	351	3 December 2025

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.

JSONata object creation (with $each?)

Related topics