• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Enhancement Requests Application Enhancements
M

Marc Mastrocola

started a topic over 5 years ago
Not Taken

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

image

image


Allan Teng

said over 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(/^[^",]"/, '"')

M

Marc Mastrocola

said over 5 years ago

Hey Allan,


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


Screen Shot 2017-02-26 at 11.51.14.png
Screen Shot ...
(160 KB)

Allan Teng

said over 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.

M

Marc Mastrocola

said over 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 over 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.


image


M

Marc Mastrocola

said over 5 years ago

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

Allan Teng

said over 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.


image


Login to post a comment

Still can't find your solution?

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

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count