CSV node not respecting headers

General
1

Hi folks,

I've been through a behaviour that I never seen before when playing with the CSV node, trying to convert an Array of objects to CSV.

From my node "Set payload to single ReportData" I will have N arrays of data({timestamp, raw_data}), which I expect to have individually converted to a CSV structure, based on the JSON keys available in each object to become the headers. I found out that it's not working automatically when triggering the "timestamp node" (you can see the second one won't have data, and will be using a wrong header [I even tried to force headers at msg.columns without success]). But if I do it using the injects A or B, which has the "hardcoded" individual payload from the "delay" node it works perfectly fine.

I'll share some screenshots and I hope I can find some help!

Best regards to everyone!

image
image1791×871 154 KB

image
image1737×562 72.8 KB

2

Welcome to the forum.

Screenshots are not easy to debug, if you could post your flow with some test data, it would be easier for people to help.

looking at the screenshot:

image
image958×204 63.5 KB

This seems to indicate that you are receiving empty rows.
And here you can see that there is a return character in the data causing the csv to break. it is also in the columns names (forgot to highlight)

image
image1488×416 252 KB

3

Thank you for your reply @bakman2! Good news: I found the cause of the issue, and a possible solution. First of all, I'll share a code where you can replicate the issue:

[{"id":"182a6eea8e85c6cd","type":"csv","z":"708f652854836238","name":"","spec":"rfc","sep":",","hdrin":true,"hdrout":"all","multi":"one","ret":"\\n","temp":"","skip":"0","strings":false,"include_empty_strings":"","include_null_values":"","x":1130,"y":1460,"wires":[["bd8d0938ecf72d72"]]},{"id":"432017f0de433b6e","type":"delay","z":"708f652854836238","name":"","pauseType":"rate","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"5","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":640,"y":1360,"wires":[["bbe89288e476592a","54680baf6084d0c3"]]},{"id":"bbe89288e476592a","type":"function","z":"708f652854836238","name":"Replace special symbols","func":"let data = msg.payload\n\nconst dataRemap = data.map(line => {\n    const obj = {};\n    for (let prop in line) {\n        if (line.hasOwnProperty(prop)) {\n            obj[prop.replace(/[^\\w]/g, '')] = line[prop];\n            }\n        }\n        return obj;\n    }\n);\n\n// msg.columns = Object.keys(dataRemap[0]).toString() ;\nmsg.payload = dataRemap;\nreturn msg;\n","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":910,"y":1380,"wires":[["182a6eea8e85c6cd"]]},{"id":"bd8d0938ecf72d72","type":"debug","z":"708f652854836238","name":"debug 6","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1220,"y":1620,"wires":[]},{"id":"fe6b1028ceaba281","type":"inject","z":"708f652854836238","name":"Inject A","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"XOutflowTime\":\"2025-03-18T01:34:37.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-18T01:19:37.000Z\",\"Y2864Outflow15minVolumem3\":5},{\"XOutflowTime\":\"2025-03-18T01:04:37.000Z\",\"Y2864Outflow15minVolumem3\":16},{\"XOutflowTime\":\"2025-03-18T00:34:34.000Z\",\"Y2864Outflow15minVolumem3\":7},{\"XOutflowTime\":\"2025-03-18T00:19:34.000Z\",\"Y2864Outflow15minVolumem3\":8},{\"XOutflowTime\":\"2025-03-18T00:04:33.000Z\",\"Y2864Outflow15minVolumem3\":7},{\"XOutflowTime\":\"2025-03-17T23:49:32.000Z\",\"Y2864Outflow15minVolumem3\":9},{\"XOutflowTime\":\"2025-03-17T23:34:31.000Z\",\"Y2864Outflow15minVolumem3\":7},{\"XOutflowTime\":\"2025-03-17T23:19:30.000Z\",\"Y2864Outflow15minVolumem3\":7},{\"XOutflowTime\":\"2025-03-17T23:04:31.000Z\",\"Y2864Outflow15minVolumem3\":8},{\"XOutflowTime\":\"2025-03-17T22:49:29.000Z\",\"Y2864Outflow15minVolumem3\":8},{\"XOutflowTime\":\"2025-03-17T22:34:29.000Z\",\"Y2864Outflow15minVolumem3\":8},{\"XOutflowTime\":\"2025-03-17T22:19:27.000Z\",\"Y2864Outflow15minVolumem3\":3},{\"XOutflowTime\":\"2025-03-17T22:04:27.000Z\",\"Y2864Outflow15minVolumem3\":3},{\"XOutflowTime\":\"2025-03-17T21:49:26.000Z\",\"Y2864Outflow15minVolumem3\":8},{\"XOutflowTime\":\"2025-03-17T21:34:26.000Z\",\"Y2864Outflow15minVolumem3\":7},{\"XOutflowTime\":\"2025-03-17T21:19:25.000Z\",\"Y2864Outflow15minVolumem3\":8},{\"XOutflowTime\":\"2025-03-17T21:04:23.000Z\",\"Y2864Outflow15minVolumem3\":6},{\"XOutflowTime\":\"2025-03-17T20:49:23.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T20:34:22.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T20:04:21.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T19:49:21.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T19:34:19.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T19:19:19.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T19:04:18.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T18:49:17.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T18:34:17.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T18:19:17.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T18:04:15.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T17:49:15.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T17:34:13.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T17:19:13.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T17:04:12.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T16:49:12.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T16:34:11.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T16:19:10.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T16:04:09.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T15:49:08.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T15:34:08.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T15:19:07.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T15:04:07.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T14:49:05.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T14:34:05.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T14:19:06.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T14:04:04.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T13:49:03.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T13:34:01.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T13:19:01.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T13:04:00.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T12:49:00.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T12:33:59.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T12:18:59.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T12:03:57.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T11:48:58.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T11:33:57.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T11:18:56.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T11:03:56.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T10:48:54.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T10:33:53.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T10:18:52.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T10:03:52.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T09:48:51.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T09:33:51.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T09:18:49.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T09:03:48.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T08:48:48.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T08:33:47.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T08:18:47.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T08:03:46.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T07:48:45.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T07:33:44.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T07:18:43.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T07:03:43.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T06:48:42.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T06:33:42.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T06:18:42.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T06:03:40.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T05:48:39.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T05:33:38.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T05:18:38.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T05:03:38.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T04:48:37.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T04:33:37.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T04:18:36.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T04:03:34.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T03:48:34.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T03:33:33.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T03:18:32.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T03:03:31.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T02:48:31.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T02:33:30.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T02:18:29.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T02:03:29.000Z\",\"Y2864Outflow15minVolumem3\":0},{\"XOutflowTime\":\"2025-03-17T01:48:27.000Z\",\"Y2864Outflow15minVolumem3\":0}]","payloadType":"json","x":150,"y":1160,"wires":[["9c66e026519e5385"]]},{"id":"129e4c98013241b8","type":"inject","z":"708f652854836238","name":"Inject B","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"XInflowTime\":\"2025-03-18T01:34:37.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-18T01:19:37.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-18T01:04:37.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-18T00:34:34.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-18T00:19:34.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-18T00:04:33.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T23:49:32.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T23:34:31.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T23:19:30.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T23:04:31.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T22:49:29.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T22:34:29.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T22:19:27.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T22:04:27.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T21:49:26.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T21:34:26.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T21:19:25.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T21:04:23.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T20:49:23.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T20:34:22.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T20:04:21.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T19:49:21.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T19:34:19.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T19:19:19.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T19:04:18.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T18:49:17.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T18:34:17.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T18:19:17.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T18:04:15.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T17:49:15.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T17:34:13.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T17:19:13.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T17:04:12.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T16:49:12.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T16:34:11.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T16:19:10.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T16:04:09.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T15:49:08.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T15:34:08.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T15:19:07.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T15:04:07.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T14:49:05.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T14:34:05.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T14:19:06.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T14:04:04.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T13:49:03.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T13:34:01.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T13:19:01.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T13:04:00.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T12:49:00.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T12:33:59.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T12:18:59.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T12:03:57.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T11:48:58.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T11:33:57.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T11:18:56.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T11:03:56.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T10:48:54.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T10:33:53.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T10:18:52.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T10:03:52.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T09:48:51.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T09:33:51.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T09:18:49.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T09:03:48.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T08:48:48.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T08:33:47.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T08:18:47.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T08:03:46.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T07:48:45.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T07:33:44.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T07:18:43.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T07:03:43.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T06:48:42.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T06:33:42.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T06:18:42.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T06:03:40.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T05:48:39.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T05:33:38.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T05:18:38.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T05:03:38.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T04:48:37.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T04:33:37.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T04:18:36.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T04:03:34.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T03:48:34.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T03:33:33.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T03:18:32.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T03:03:31.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T02:48:31.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T02:33:30.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T02:18:29.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T02:03:29.000Z\",\"Y2863Inflow15minVolumem3\":0},{\"XInflowTime\":\"2025-03-17T01:48:27.000Z\",\"Y2863Inflow15minVolumem3\":0}]","payloadType":"json","x":150,"y":1220,"wires":[["9c66e026519e5385"]]},{"id":"9c66e026519e5385","type":"join","z":"708f652854836238","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","useparts":false,"accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":330,"y":1200,"wires":[["db86a09b6a19fe97"]]},{"id":"db86a09b6a19fe97","type":"split","z":"708f652854836238","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","property":"payload","x":530,"y":1200,"wires":[["432017f0de433b6e"]]},{"id":"54680baf6084d0c3","type":"debug","z":"708f652854836238","name":"debug 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":900,"y":1200,"wires":[]}]

Basically, the solution I found is to delete the parameter "parts" -> "delete msg.parts
".

The aim to my original flow (the flow I sent now is a simulated part of the process) is to receive an Array of object arrays, split the major one in individual arrays, transform them to single CSV files and send it using FTP.

About the solution:

I found out that, when using the split node, it created a "parts" parameters, if I delete this parameter from my message before it hits the CSV node, the parsers works fine. You can replicate it on the flow that I shared connecting the injectors directly to the delay node instead of going through the join/split nodes.

Best regards !