In this picture I use the word 'product' in the name:value pairs of payload.{ } Is it possible to set the name 'product' with the string value of a msg.? By example. The msg.test message contains a string value: 'product'. Is it possible to use this message as the "name:value" pair? I thought …

Try $lookup() [{"id":"965ef7ad.16d87","type":"inject","z":"9b3f9f31.c45298","name":"","props":[{"p":"payload"},{"p":"test","v":"product","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":230,"y":780,"wires":[["d16bafd0.71ee88"]]},{"i…

Please share an example of the output msg JSON you are expecting to get. And an example copy of the input msg

Hello Wolff, I am not pretty sure, if I understood you well, but did you check the helper function setObjectProperty(msg, prop, value, createMissing) (ref. Node-RED ) already? - Maybe this can help you. If not, I would need more information to understand your problem. Maybe - as requested already -…

[image] MrWolff: I thought the JSONata must be like: payload.{msg.test: $} But this doesn't work... :roll_eyes: If I understand your question, it may be as simple as this: { test: payload } Here is what it looks like in a change node, given the 2 fields test and payload as strings... [imag…

The thing I want to do is: I have 2 dropdown menus. When I select the product in 'dropdown product' I want to select in the 'dropdown type' the product type. So when I select ball in 'product'. I want to select the type of ball in 'type'. [Schermafbeelding 2021-05-10 om 18.13.53] I used a templ…

Can you share the payload containing the differen product types ?

What do you mean? The different product types are in the template node: [image]

Hi Wolff, Maybe you should check out this entry in the forum (btw: I received it looking for „depending drop down“): https://discourse.nodered.org/t/problem-with-drop-down-menu/34003 There you find an option with msg.options to send the possible options for the dropdown; meaning: as soon as one v…

Hi Ranki, Thanks for helping! Yes I know the msg.options. But I don't send the whole list of options to the second dropdown. Do you tested my flow and saw that? I need to use the csv to choose the options. Because I want to be able to update the options by updating the csv with no need to update …

Thank you very much @E1cid ! It works like magic. Trying to understand it...

[{"product":"ball","ball":"baseball","train":"yellowtrain","hat":"bighat"},{"product":"train","ball":"football","train":"bluetrain","hat":"smallhat"},{"product":"hat","ball":"tennisball","train":"redtrain","hat":"mediumhat"}] $lookup(array_of _object, key_search_value) will go through each object o…

Node-RED

Node-RED Forum

How to use msg.payload string value in JSONata?

General

system Closed 25 May 2021 12:07 15

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Dynamic Objectpath for extracting an element General	17	880	27 September 2021
Select value from CSV file General	27	1883	24 May 2021
Referrencing msg.payload in JSON General	32	31945	30 December 2020
UI Dropdown - Populating Data General	28	20678	30 July 2021
Pulling global values and and merging other variables using json General	18	2319	3 March 2021

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.

How to use msg.payload string value in JSONata?

Related topics