unable to fetch data using tGoogleSheetInput

psujini — Thu, 27 Feb 2020 13:43:24 GMT

Hi Team,

I would like to read the google sheet Using Talend Open Studio DI 7.1

I have downloaded the tGoogleSheetInput from Exchange and using it to read google sheet

but it is throwing the following Exception.

Exception in component tGSpreadsheetInput_1 (GoogleSpreadSheet)
com.google.gdata.util.AuthenticationException: Error authenticating (check service name)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthException(GoogleAuthTokenFactory.java:553)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:430)
at com.google.gdata.client.GoogleAuthTokenFactory.setUserCredentials(GoogleAuthTokenFactory.java:301)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:324)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:301)
at dpix.googlespreadsheet_0_1.GoogleSpreadSheet.tGSpreadsheetInput_1Process(GoogleSpreadSheet.java:658)
at dpix.googlespreadsheet_0_1.GoogleSpreadSheet.runJobInTOS(GoogleSpreadSheet.java:1118)
at dpix.googlespreadsheet_0_1.GoogleSpreadSheet.main(GoogleSpreadSheet.java:967)

I have been to many links for the solution.But i have no clue.

Please let me know any approach to read the google sheet data. attached the screen shots of the configuration i followed.

Re: unable to fetch data using tGoogleSheetInput

Anonymous — Sun, 01 Mar 2020 03:51:01 GMT

Hi
It is a custom component shared by community user on Talend Exchange, can you share the link of component which you have downloaded?

Regards
Shong

Re: unable to fetch data using tGoogleSheetInput

psujini — Wed, 11 Mar 2020 07:47:18 GMT

Hi,

Please find the below link that i have downlaoded from the link

https://exchange.talend.com/#marketplacesearch:gallery=marketplace%252F1&ob=releaseDate&o=0&c=20&d=true&s=tgspreadsheetinput&f=&tf=&bf=&cat=&title=Search%2520Results.

Please do the needful

Thanks.

topic Re: unable to fetch data using tGoogleSheetInput in Talend Studio

unable to fetch data using tGoogleSheetInput

Re: unable to fetch data using tGoogleSheetInput

Re: unable to fetch data using tGoogleSheetInput