Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!
Labels (2)
6 Replies
Anonymous
Not applicable
Author

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: TalendHelpCenter0683p000009MA5A.pngbtaining an access token for Google Drive?
Best regards
Sabrina
Anonymous
Not applicable
Author

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.
0683p000009MDGZ.png   0683p000009MDLD.jpg 
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
howie
Contributor
Contributor

I'm stuck at this same point. Any resolution?
Anonymous
Not applicable
Author

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
howie
Contributor
Contributor

I'm just testing the component. I'm using the same as pictured above by Juan.
Anonymous
Not applicable
Author

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