topic Re: URI Google Drive in Talend Studio

URI Google Drive

Anonymous — Wed, 15 Feb 2017 18:00:23 GMT

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!

Re: URI Google Drive

Anonymous — Thu, 16 Feb 2017 07:40:00 GMT

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: TalendHelpCenterbtaining an access token for Google Drive?
Best regards
Sabrina

Re: URI Google Drive

Anonymous — Thu, 16 Feb 2017 09:05:15 GMT

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

Re: URI Google Drive

howie — Thu, 23 Mar 2017 19:08:08 GMT

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

Re: URI Google Drive

Anonymous — Fri, 24 Mar 2017 06:39:53 GMT

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

Re: URI Google Drive

howie — Fri, 24 Mar 2017 13:47:29 GMT

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

Re: URI Google Drive

Anonymous — Fri, 24 Mar 2017 14:11:42 GMT

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