tGoogleDriveGet connection to tFileInputDelimited

Highlighted
Five Stars

tGoogleDriveGet connection to tFileInputDelimited

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.


Accepted Solutions
Highlighted
Employee

Re: tGoogleDriveGet connection to tFileInputDelimited

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

View solution in original post


All Replies
Highlighted
Employee

Re: tGoogleDriveGet connection to tFileInputDelimited

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

View solution in original post

Highlighted
Five Stars

Re: tGoogleDriveGet connection to tFileInputDelimited

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog