Hi folks, I am searching for a way to transform easily nested object properties, for one of my new nodes. For example the input message of my node could be like this: { "payload": [ { "someProperty": "A", "someOtherProperty": "B" }, { "someProperty": "C", "s…

[image] BartButenaers: I see that they also offer a registerFunction , so that might be what I am looking for. Will try it... That seems to do the job. My callback function is nicely called with the required input, and my output is used by Jsonata. Case closed :+1:

I'd start with jsonata given that is built-in to Node-RED and is a library for transforming JSON structured data.

Hey Nick, Yes that indeed has popped up in my head already. So I had a quick look at jsonata yesterday. But I have to be honest that it is ages ago that I used jsonata, and now it has become one big cryptogram for me ... I have in my config screen: A dropdown list containing 4 transformations,…

I'm very interested in how you solve this. In one of my nodes I needed to find a particular key-value pair buried in an object of arbitrary structure. I was able to do it (barely) using the JS Object.getOwnPropertyNames() function and the NR RED.util.compareObjects() function, but I am sure that the…

Hey @drmibell , [image] drmibell: is it possible to use JASONata in the JS file of such a node? Well you can use jsonata fairly easily in a custom node (see here ). However I am not sure whether I can use it to transform an object via a custom transformation call back function. I would like …

[image] BartButenaers: you can use jsonata fairly easily in a custom node Thanks for that. My code is working now, but I'll give JSONata a try just to see if I can expand my toolbox. If I can keep track of what is a JS object and what is a JSON string, it might be fun.

[image] drmibell: I'll give JSONata a try Then you might also have a quick look at their Javascript API . I see that they also offer a registerFunction, so that might be what I am looking for. Will try it...

Hi @drmibell , I got it working using the Jsonata transforms. And it works fine! However few days afterwards my Node-RED became suddenly completely unresponsive, and I had no clue what was causing that. So I started experimenting with profiling in Node-RED (via ClinicJs , my message tracer and my o…

Apply transformation on nested object fields (based on dot notation)

Developing Nodes

BartButenaers 18 November 2021 07:16 4

Ah I now see that Jsonata has a ~> (transform) operator. So I assume I need to use that one ...

Cpu profiling a single node: collecting ideas

Topic		Replies	Views
Jsonata, modify some elements in an array of objects General jsonata	13	333	14 April 2024
JSONata: Using the result of an Object Function to reference a Message Property in a Change Node General	5	295	11 January 2023
Jsonata in Node-Red not working as for example on try.jasonata or in the Node-Red Test UI General	2	738	16 August 2021
Json Data Mapping General	12	330	25 August 2022
Mapping a specific data of an array of properties in JSON General	9	1401	23 February 2021

Apply transformation on nested object fields (based on dot notation)

Related topics