One Star

Not able to download a Google Drive sheet into Talend

Hi,
I'm currently having issues downloading a GoogleDrive sheet into talend.
I'm using the following steps in Talend: tGoogleDriveConnection-->tGoogleDriveGet-->tLogRow
Talend is connecting well with Google drive, however, it fails once it reaches to the tGoogleDriveGet step. See error message in the screenshot attached.
Please Advise.
6 REPLIES
Moderator

Re: Not able to download a Google Drive sheet into Talend

Hi,
There is a excel file in the root directory of Google Drive? Could you please give us more information about your Google Drive?

Did you follow up the scenario "Obtaining an access token for Google Drive" in component reference: TalendHelpCenter:tGoogleDriveConnection?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Not able to download a Google Drive sheet into Talend

Hi,
Name of File: 'GoogleSheetsTest' is the name of an excel file in my google drive which I wish to download to Talend. Am I supposed to put something different here?
Also,
I did follow all the instructions on TalendHelpCenter:tGoogleDriveConnection.
My connection to google drive is successful. I have been able to successfully list my google drive files in talend by using the steps tGoogleDriveConnecion-->tGoogleDriveList-->tIterateToFlow-->tLogRow. 
Now where I'm having issues with is to actually download these files from google drive to Talend.
Please Advise.
One Star

Re: Not able to download a Google Drive sheet into Talend

Sabrina,
Here is the link to my google drive document: 
https://docs.google.com/spreadsheets/d/1ehVbgPl1wS6-YdsiF1pKnc6mCweSnmuPkPVAmGStEnk/edit?usp=sharing
root directory: My Drive
One Star

Re: Not able to download a Google Drive sheet into Talend

Hi,
Did you solved your problem ? I've got the same issue ! I can successfully connected to the drive (tcreate and tlist works) but can't manage to use tget...
One Star

Re: Not able to download a Google Drive sheet into Talend

FYI , I've created a Jira issue ticket
https://jira.talendforge.org/browse/TBD-2858
Four Stars

Re: Not able to download a Google Drive sheet into Talend

Hello, is there any update on this issue?