topic automaticaly read a google sheet everyday in Data Quality

automaticaly read a google sheet everyday

Anonymous — Sat, 16 Nov 2024 09:42:33 GMT

Hi, in the first place I would like to apologize if I don't post this topic at the right place.

I would like to read a google sheet everyday from my place "shared with me" (from my google account),

So my question is : how can I do that ?

I'm trying to use google API OAuth 2.0 Playground and the tGoogleSheet component but I've got the following failure : Error: redirect_uri_mismatch : The redirect URI in the request, http://localhost:63234/Callback, does not match the ones authorized for the OAuth client

and I don't know what i have to do..

I also have to use a previous Talend version (6.3), and I'm not sure that's the best way.

Do you have any idea ?

Regards

Hugo

Re: automaticaly read a google sheet everyday

Anonymous — Mon, 12 Jun 2017 06:55:20 GMT

Hi,

Could you please post your current job setting screenshots on forum which will be helpful for us to address your issue.

For your job requirement, you can use a scheduler to read your google sheet everyday.

Best regards

Sabrina

Re: automaticaly read a google sheet everyday

Anonymous — Fri, 16 Jun 2017 13:54:38 GMT

Hi,

To read the content of the google sheet, I'm using this job.

And i'm trying to automatically get the refresh token with the solution of this website :

https://www.rilhia.com/tutorials/using-oauth-20-talend-access-google-apis

But I have the error message "The connected components in a Job must not form a closed loop. Please check" and I don't know what i did different than his Job.