topic tGoogleDriveGet connection to tFileInputDelimited in Talend Studio

tGoogleDriveGet connection to tFileInputDelimited

Anonymous — Sat, 16 Nov 2024 05:01:05 GMT

I am trying to pull a spreadsheet from google drive, transform it using tmap and load it into a database. Whenever I have the tGoogleDriveGet component linked to a logrow, there are no errors; however, when I link the google drive component to the tInputFile component I get a null pointer exception. I am not sure what the problem is here.

*note: in my googledriveget component, I checked the box to save the file (to my desktop) and then used that path in the inputfiledelimited component.

Re: tGoogleDriveGet connection to tFileInputDelimited

Anonymous — Fri, 09 Aug 2019 22:32:55 GMT

Hi,

Did you cross check whether the file is getting downloaded to your local desktop? If the file is downloaded to your desktop, please check file name in your tfileinput component is same as in the folder where you downloaded the file.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tGoogleDriveGet connection to tFileInputDelimited

Anonymous — Mon, 19 Aug 2019 14:58:23 GMT

It is saving to the location I have designated and I added the same file name to the tfileinput component; however, I keep getting a null pointer exception for my googledriveget component. I can't figure out what would be wrong with my setup since there is no error when I just have a path of googledriveget --> tlogrow.