topic Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components in Talend Studio

Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

mobmsc2 — Wed, 27 Sep 2017 14:55:45 GMT

Using the provided components tGoogleDriveConnection and tGoogleDriveList in conjunction with this help document from Talend including using Google's Developer Playground to get valid access tokens to the drive api I'm able to list the files stored for a particular user account.

I'm hoping to use Jan's tGoogleSheet component to then get the contents of the google documents but I'm having trouble getting the tGoogleSheet to use the same authenticated connection as worked earlier in the job. On GitHub there is a word document which points to a setting on tGoogleSheet

Use existing client

Choose here the tGoogleDrive component which client do you want to reuse in this component instance.

Boolean

but that doesn't seem to be provided in the version I downloaded from exchange.

Has anyone been able to get these to work together and to do so without duplicating authentication details?

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

Anonymous — Thu, 28 Sep 2017 04:52:15 GMT

Hello,

This a custom component written by talend community user and shared on talend exchange portal.

Feel free to contact the author Jan please.

Best regards

Sabrina

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

mobmsc2 — Thu, 28 Sep 2017 12:21:20 GMT

Hi Sabrina,
The documentation suggested to post here and there was probably someone who needed to accomplish the same using Talend that I was hoping might be able to help as well

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

MahiwalVinit — Thu, 30 Nov 2017 15:11:51 GMT

Google drive access token expires after 30 min, To use this component will user have generate access token again and again ?

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

Anonymous — Tue, 05 Dec 2017 08:03:19 GMT

Hello,

So far, I have no idea about your job requirement that Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components.

The third party custom components on Talend Exchange are not supported by Talend since we don't have the source code of these components. It is the ownership of the person who built it.

Hope someone can help on this.

Best regards

Sabrina

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

MahiwalVinit — Wed, 06 Dec 2017 05:47:03 GMT

I am able to connect to google drive uninterruptedly with talend component only. Attached is job flow.

talend.PNG

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

MahiwalVinit — Wed, 06 Dec 2017 05:47:12 GMT

I am able to connect to google drive uninterruptedly with talend component only. Attached is job flow.