Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Best regards
Sabrina
Hello
I would like to read a Google Spreadsheet file from Google drive, so I've downloaded your components
1 - Token Google
I created a new project: TestTalend
Library > Google Drive API > Enable
Credentials > Configure consent screen
OAuth consent screen > Internal > Create
Application name : TalendProduct
Support email: my email
> Save
Credentials Menu > Create credentials > OAuth ClientID
In ApplicationType, it is no longer possible to choose "Other", so I tried "Web Application" and "Desktop App"
Name: TalendWebClient
> Create
I've downloaded json file
2 - Talend
tGoogleDrive >iterate> tGoogleSheetInput_1 >main> tLogRow
* tGoogledrive
Operational Mode : List files (to test token)
Application Name : TestTalend
Authentification Method : ClientID for native application
Client-ID or user email: I tried both of them
Client Secret File (json) : my json file
File mime-type : application/vnd.google-apps.spreadsheet
* tGoogleSheetInput_1
Client setup: tGoogleDrive informations
File ID: ((String)globalMap.get("tGoogleDrive_1_FILE_ID"))
Sheet name: file name
Start reading data at line : 2
When I run job, Chrome asks me to access to drive, I accept
A window appears and displays "Received verification code. You may now close this window."
I close this window
In Talend console, i have the following message:
"Attempting to open that address in the default browser now...
Opening in existing browser session."
But Talend never takes control, and ends up leaving in time out
I must be missing a step, but I can't see which one
Can you help me?
Thank you
Best regards