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 !

4

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