Here is my scenario. I have a vendor who emails CSV files directly to Box. I need to extract those CSV files from BOX and put them into a staging table so my ETL can finish the rest of the processing. This is my first time using the Box components and/or the CSV components (so if there is a better option, i'm open to suggestions). Anyway, it appears from what I have read is that I need to download the files from box to a local storage directory and then process the files. And this works well when I just run it on my local machine. But does anyone know how to implement this solution when running this in the Talend Cloud? There has to be some type of local file system, but it does not appear we have direct access to it. Any help, direction or guidance is kindly appreciated.
And if there is an easier more efficient way to do this w/o having to download the file, that is even better!!!
