Hi Marc, we have found a possible solution for this. You can try doing a gsub on the data pill before the file upload.
I just tried that but not sure if I'm setting up the formula correctly (see screenshot):
Hi Marc, you should use the gsub formula on an actual data pill in step 2 when you upload the file you have downloaded in step 1.
What action do I use to though? Because I need to apply the formula in step 2 and then try the Read CSV lines action correct?
It's in the Upload file to Dropbox action. You just need to do the gsub on the body of the file content to upload.
Ok will try this once the AWS outage is fixed (Import.io is down due to that)
To download the dropbox file in the correct encoding UTF-8, use the HTTP Rest Request action instead.
The data of the output will be encoded correctly.
Send us a ticket, we will try our best to assist you with your problem