HI ! I have problem with the spliting returning sql array result. As you will see down below i got the result from sql node normaly, but soon as pass through the split node i got that. [image] Here is the node, what i use: [{"id":"8144efff.0ea0e","type":"inject","z":"11e1e4a1.276eeb","name":"",…

Meanwhile i solved it. I use two json node which are connected to sql node, and result is what i want.

what version of NR and nose.js are you using? (see startup log) what do you see if you change the debug1 node after the split node to display the 'Complete msg object'?

@mac5562 You're trying to split the msg. payload at every \n (newline) when the payload is an array of objects. Try splitting it using an array fixed length of 1 and leave the string/Buffer and Object Input fields empty.

node js version: v12.19.0 node red: 1.2.7 I got this i set the debug node to show the complete msg object [image]

I tried it, but not solved the problem

So, after the split node, you are getting a series of objects each containing a payload that is from a row in the database. This seems to me that it is working exactaly as it is suppose to. Now the question is, what do you want the data to look like and what do you want to do with it?

What i want, the payload object which i got from the split node look like this: [image] I got that with this nodes. [{"id":"ea2f1202.bd75f","type":"inject","z":"11e1e4a1.276eeb","name":"Fake DB Result","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"once…

That is not the sql statement you used in the flow you posted originally. in your original flow you use SELECT device_id FROM devices.

Like i said before, these data not from the database. It's from a inject node, which payload is a array with objects which look like the the data, what i got from sql node after, i give a query.

Please try this: run your flow but change the sql to select * from the database and then look at the results. Copy and paste the results AFTER expanding all the arrows in the debug Then explain what you want the output to look like.

Are you sure the results you receive are all arrays ? By the looks of it you also receive objects, which are not split.

Node-RED

Node-RED Forum

MYSQL result splitting problem

General

zenofmud 1 February 2021 12:28 2

what version of NR and nose.js are you using? (see startup log)
what do you see if you change the debug1 node after the split node to display the 'Complete msg object'?

Topic		Replies	Views
Splitting array - from MySQL query General	36	2256	14 May 2021
Split Node doesn't split an array General split	3	88	23 June 2024
Split Payload object, Fixed length of 1 Array not working General	5	642	29 March 2021
Split node loses information General split	11	601	11 February 2022
Msg split, choose option and MySQL select General	45	2149	23 April 2020

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.

MYSQL result splitting problem

Related topics