Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

Seven Stars

Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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?

 

Moderator

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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
Seven Stars

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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

Moderator

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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

 

 

 

Seven Stars

Re: Integrating tGoogleDriveConnection and Jan Lolling's tGoogleSheet components

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

 

 

talend.PNG

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads