topic Re: Read a Google drive public file in Talend Studio

Read a Google drive public file

Anonymous — Wed, 29 Jan 2020 16:55:23 GMT

Hi,

I was looking at the tGoogleDriveGet component and expecting it to be pretty simple to read a public file. However, all the docs I can find go on about authentication etc. Are there any simple examples about?

Thanks

Andy

Re: Read a Google drive public file

Anonymous — Fri, 31 Jan 2020 20:58:20 GMT

This isn't simple I'm afraid. OAuth 2.0 is a multi step authentication process. Great when you have configured it, and very easy. But configuring your token initially is a real pain. I have written a tutorial on this here: https://community.talend.com/t5/Design-and-Development/Using-OAuth-2-0-with-Talend-to-Access-Google-APIs/m-p/133568

Re: Read a Google drive public file

Anonymous — Mon, 03 Feb 2020 09:02:18 GMT

Thanks for the reply.

I'm surprised you need to authenticate to read a public file - sounds like a bug.

Re: Read a Google drive public file

Anonymous — Mon, 03 Feb 2020 10:29:53 GMT

How do you mean a public file? Can you access it without any Google credentials manually? Could I, for example, call the URL without being logged in to any Google product and just download the file?

Re: Read a Google drive public file

Anonymous — Mon, 03 Feb 2020 10:35:00 GMT

yes - here is an example file which you should be able to view:

https://docs.google.com/document/d/1L9yyhw3S5KHHzhcGF72r_J7_7NV1yQ3frHF-TXa8HHc/edit?usp=sharing

Re: Read a Google drive public file

Anonymous — Mon, 03 Feb 2020 10:54:27 GMT

I've just had a look. I don't think this is a bug, this looks like a limitation of the Google Drive API. It seems that you need to have credentials to be able to find file ids. This kind of makes sense, as the credentials will let the API know of your access levels.

Re: Read a Google drive public file

Anonymous — Mon, 03 Feb 2020 18:00:21 GMT

But the file ID is in the URL

Re: Read a Google drive public file

Anonymous — Mon, 03 Feb 2020 19:53:13 GMT

Yes, but the Google Drive API requires that users are authenticated. This can be see here: https://developers.google.com/drive/api/v3/about-auth

Re: Read a Google drive public file

Anonymous — Tue, 04 Feb 2020 10:08:37 GMT

Ok, thanks. Don't seem to have Developer Console enabled in our company G Suite, so i'll have to do it in Java.

Re: Read a Google drive public file

Anonymous — Tue, 04 Feb 2020 10:33:42 GMT

It might be easier and quicker to just set up a Gmail account to use for this purpose. Certainly quicker than writing a load of code.