https://community.qlik.com/t5/Talend-Studio/Reading-a-CSV-file-from-Box/m-p/2296495#M69152 <P>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. </P><P></P><P></P><P>And if there is an easier more efficient way to do this w/o having to download the file, that is even better!!!</P><P></P><P></P> Wed, 30 Sep 2020 16:07:42 GMT tlwilli2020 2020-09-30T16:07:42Z https://community.qlik.com/t5/Talend-Studio/Reading-a-CSV-file-from-Box/m-p/2296495#M69152 <P>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. </P><P></P><P></P><P>And if there is an easier more efficient way to do this w/o having to download the file, that is even better!!!</P><P></P><P></P> Wed, 30 Sep 2020 16:07:42 GMT https://community.qlik.com/t5/Talend-Studio/Reading-a-CSV-file-from-Box/m-p/2296495#M69152 tlwilli2020 2020-09-30T16:07:42Z https://community.qlik.com/t5/Talend-Studio/Reading-a-CSV-file-from-Box/m-p/2296496#M69153 <P>Using the instructions from this article helped me solve the problem:</P><P>&nbsp;</P><P>https://help.talend.com/reader/MHHPPMmdrRvET~AKQvk8QA/yAlmxff~AJVc5frEcGHFKw</P> Mon, 05 Oct 2020 20:23:34 GMT https://community.qlik.com/t5/Talend-Studio/Reading-a-CSV-file-from-Box/m-p/2296496#M69153 tlwilli2020 2020-10-05T20:23:34Z