I am extracting data from my smart meter and thought I could make this change node into a one liner. But for the life of me I cannot replace "calc" in the second entry in the node with the reference to the value in the first line. The value is a string containing a hex value. If it's not possible I …

What does the input payload look like ?

"00000B96" - for example, it's the actual consumption in Watt hours.

Could you please post a debug output including the object ? (meaning the input that goes into this change node)

In jsonata i don't see a quick way as it does not seem to like concatenation and parsing it after that. In a function node it works; m = "0x"+msg.payload return {WattsNow:parseInt(m)};

Oh yes, I have already done it in a function node with: msg.Wh_now = parseInt(msg.payload.elecMtr["0702"]["04"]["00"], 16); I was just wondering if it was possible in a change node with a simple JSONata expression.

[image] bakman2: Fiddling a bit further, this works in jsonata: $parseInteger($string("0x"&payload),'0') Yes that works, but the normal notation for referencing the value doesn't work in JSONata. You need to replace the square brackets with"." Took me a while, this works fine: $parseInteger…

Node-RED

Node-RED Forum

JSONata question

General

bakman2 24 May 2020 17:10 8

Fiddling a bit further, this works in jsonata:

$parseInteger($string("0x"&payload),'0')

1 Like

Topic		Replies	Views
Change node - can this be done? General	11	285	6 May 2024
Change node and jsonata General	8	2285	18 October 2019
Puzzling JSONATA problem in Change Node General	2	221	13 January 2023
Weird JSONata problem General	22	6480	21 August 2018
Insert variable inside a json array General	9	1714	3 April 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.

JSONata question

Related topics