Hi,
I’m trying to decode a CSV file received from an HTTP node, the problem is that the file is ANSI encoded and I can’t find a way to decode it properly. I used Move Binary Data node but ANSI is not in the list
Does anyone have an idea for a solution?
Thanks,
Gregory
Read Binary File is for reading local files not files from the internet, To get that file going it should be like what you posted earlier. I am seeing an encoding issue of somekind but I get that when downloading the file directly and reading it on my machine as well so could be the document itself or I am missing a language pack or something.
I don’t have any problems with the encoding when I read the file from my computer either.
What about the document? It is used in other services, there are no problems.
When I open the file on my local machine that I download directly from that site I see the same format as the one in n8n so I assume it is the encoding. It could be that you need to save it to disk then read it with the correct encoding.
When that option is set it will try to set all the json data from the binary file and some of those fields might not exist. The snippet below from the docs might help.
If set to active, all JSON data is replaced with the data retrieved from binary key. If it is not set to active, the data will be written to a single key. This field is displayed when 'Binary to JSON' is selected from the Mode dropdown list.