Dropbox (Read CSV Line) action: Add option for UTF-8 enconding

Receiving CSV file from import.io that is encoded as a UTF-8 file. File uploaded to dropbox has a special character right at the beginning (first character) that is causing an internal error. It only shows up when looking at it in the terminal.

Need a way to read these CSV in dropbox using the Read CSV Line action

Allan Teng

said almost 5 years ago

Hi Marc, we have found a possible solution for this. You can try doing a gsub on the data pill before the file upload.

data.gsub(/^[^",]"/, '"')

Marc Mastrocola

said almost 5 years ago

Hey Allan,

I just tried that but not sure if I'm setting up the formula correctly (see screenshot):

Screen Shot ...

(160 KB)

Allan Teng

said almost 5 years ago

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.

Marc Mastrocola

said almost 5 years ago

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?

Allan Teng

said almost 5 years ago

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.

Marc Mastrocola

said almost 5 years ago

Ok will try this once the AWS outage is fixed (Import.io is down due to that)

Allan Teng

said almost 5 years ago

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.

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem