Dear all, I need some suggestion on how to get notified about completed orders from crypto exchange. There is a node that is giving me a parameters about completed orders. I am getting it in the following format: [Screenshot 2022-02-18 133608] I have an idea that for each of this object to crea…

One method: [{"id":"3e32b9a35b640723","type":"inject","z":"8a098f827b12daf6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":210,"y":220,"wires":[["9fc45dc141a86816"]]},{"id":"9fc45dc…

ghayne, Thank you very much. With your method I managed to store values int o the global array. So I have currently 18 values in the global array. Now I create new array of values. For this values I would like to check, whether particular is already in the list or not. If the orderIf is already i…

I achieved the same even easier with split function...where I am sending different messages for each order. But I have the same unclearity...how to check whether orderId is in the global array or not. Thank you for your answer. ROk

Have a look at this link if you just want to find if a value (number ?) is in an array. [image] 5 ways to check if an array contains a value in JavaScript A comprehensive article to learn about different ways to check if an array contains a specific item in vanilla JavaScript. …

[image] demokedes: how to check whether orderId is in the global array or not. Getting deep into JSONata now :slight_smile: In this flow an inject node generates random numbers fro 0 to 9. The change node checks if the number is already in the array and appends it if not. After a high enou…

You could simplify the JSONata to $append($flowContext("array")[$ != $$.payload], [$$.payload]) this wiill return the context array minus the incoming payload, then append the new payload to the end of the array, this also works well for arrays of objects. this thread has some good examples of se…

[image] E1cid: $append($flowContext("array")[$ != $.payload], [$.payload]) Doesn't work in the above flow I posted!

that is because the other is global i tested in flow as i dont like to mess with my global context. Change flow to global to get it to work in you above flow.

Dear @ghayne and @E1cid , I was off for few days/weeks, now I am back. With your help I managed to achieve to store orderId into the global array. I have two questions: Global array will stay permanent in the ram of nodered or it will be cleared after restart? If yes, that means, that I will hav…

Node-RED

Node-RED Forum

Suggestion about tracking orders in SQL

General

zenofmud 22 March 2022 23:13 19

You may find this helpful: A guide to understanding 'Persistent Context'

Topic		Replies	Views
I have some questions relating database General	57	3767	3 December 2018
How to save a value from a node to database General home-assistant	14	327	2 June 2023
Generate SQL statement from 2 mqtt messages General	42	1088	20 July 2020
Function to create data and insert into column of existing sqlite DB General database	8	362	6 January 2023
How to insert in a database? General database	48	2558	19 October 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.

Suggestion about tracking orders in SQL

Related topics