One Star

URI Google Drive

Hi guys,
I need help here. I'm trying to set up the credentials in google APIs to create a tgoogledrive component in TALEND but I don't know what is the uri. Does someone know what I have to write there?
An example would help.
Thanks!
6 REPLIES
Moderator

Re: URI Google Drive

Hi,
What's tgoogledrive component do you want to create? Are you referring to Authorized redirect URIs ?
Have you checked the document about how to get the access token for google drive:TalendHelpCenterSmiley Surprisedbtaining an access token for Google Drive?
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: URI Google Drive

Thanks for your answer. 
Finally I could create the acces token
The point is I want to load data from a Google Drive's sheet. It's a master table but I don't know how to use the tGoogleDriveConnection and the tGoogleDriveGet components. 
I don't know what I'm doing wrong.
   
Now gives me this error:
Exception in component tGoogleDriveGet_1
java.lang.IllegalArgumentException: java.net.MalformedURLException
at com.google.api.client.http.GenericUrl.parseURL(GenericUrl.java:638)
at com.google.api.client.http.GenericUrl.<init>(GenericUrl.java:114)
at practicing_connections.google_0_1.GOOGLE.tGoogleDriveGet_1Process(GOOGLE.java:617)
at practicing_connections.google_0_1.GOOGLE.runJobInTOS(GOOGLE.java:976)
at practicing_connections.google_0_1.GOOGLE.main(GOOGLE.java:821)
Caused by: java.net.MalformedURLException
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at com.google.api.client.http.GenericUrl.parseURL(GenericUrl.java:636)
... 4 more
Caused by: java.lang.NullPointerException
... 8 more
One Star

Re: URI Google Drive

I'm stuck at this same point. Any resolution?
Moderator

Re: URI Google Drive

Hi howie.shain,
What's your current job look like? Could you post your job design screenshots into forum which will be helpful for us to address your issue.
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: URI Google Drive

I'm just testing the component. I'm using the same as pictured above by Juan.
Fifteen Stars

Re: URI Google Drive

I've written a tutorial on this using standard Talend components without the tGoogle ones. It was written a while back and the Google Dashboard has changed a little, but the job that is included still works. This may be of use, it may not. But at the very least you can compare your parameters and results with a different method that works (re-tested last night for another reason).
By the way, this way of working enables Talend to get it's own refresh token and use after the first run. Therefore you will never need to worry about generating an access token again. You can probably use this in combination with the tGoogle components actually.
 
Hope it is of use.
https://www.rilhia.com/tutorials/using-oauth-20-talend-access-google-apis
Rilhia Solutions