Allan Teng from Workato
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(/^[^",]"/, '"')
Hey Allan,
I just tried that but not sure if I'm setting up the formula correctly (see screenshot):
Allan Teng from Workato
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?
Allan Teng from Workato
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)
Allan Teng from Workato
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
Marc Mastrocola
Dropbox (Read CSV Line) action: Add option for UTF-8 enconding