Write node or convert node is appending to last line instead of appending to a new line

[oKuxy]

Unfortunately, i am not allowed to upload anything. But i am using self hosted n8n and here’s the issue.

i have an http request, it returns 1 item, then a split node after it, no i have 10 items outputted (the http returned data is 10). I placed a convert json to csv node after it then a write to file node.

All is good so far.

Now request again with different parameter, again returns 10 to the convert node and sends it to write node (which i set it to append).

New responses were appended.

THE ISSUE:

later i need to read from file, then convert from csv to json, the convert node outputs only 9! Not 20. After lengthy process, i open the csv, turns out, it appended the second request to the last line in the csv instead of jumping to a new line.

I worked around it by doing printf “\n” >> test.csv before appending any new responses.

THE SECOND ISSUE:

Now that the csv is in correct order, the convert csv to json no longer outputs anything. It turns green on execution but nothing is outputted not even 0item shows. Simply blank.

[barn4k]

hello @oKuxy

Can you provide csv samples? You don’t need to upload them, as it’s only text

Also, please, share the workflow.

You can select all nodes with ctrl+a, copy it with ctrl+c. Then past the content here after pressing button </> with ctrl+v.