Fetch/Download gsheet using tFileFetch or any other component

Uday_Reddy1 — Fri, 15 Nov 2024 22:29:16 GMT

Hi,

My requirement is to fetch/download one of many sheets of gsheet in xls format. I tried using tFileFetch component but unsuccessful. Please guide me to solve this issue.

tFileFetch Settings:

Protocol - https

Url - "https://docs.google.com/spreadsheets/d/e/AAAAA-1vQ3UTujmMShyju2dSWUxN10JtKEPMmUIInNGAam1gfWrZTjFeeRpNy792Xm3yWD20K17z5ZlzFZZZZZ/pub?output=xlsx"

Destination directory - "C:/Users/XXXXX/Documents"

Destination filename - "sample.xls"

Need authentication - enabled & credentials to access gsheet provided

Getting error as:

[statistics] connecting to socket on port 3962

[statistics] connected

Exception in component tFileFetch_2 (rough)

java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(SocketInputStream.java:210)

at java.net.SocketInputStream.read(SocketInputStream.java:141)

at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)

at sun.security.ssl.InputRecord.read(InputRecord.java:503)

at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)

at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)

at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:750)

at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)

at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)

at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)

at org.apache.commons.httpclient.HttpConnection.flushRequestOutputStream(HttpConnection.java:827)

at org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:1975)

at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:993)

at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397)

at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)

at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)

at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)

at uday.rough_0_1.rough.tFileFetch_2Process(rough.java:1224)

at uday.rough_0_1.rough.runJobInTOS(rough.java:1604)

at uday.rough_0_1.rough.main(rough.java:1405)

[statistics] disconnected

Thanks

Uday Reddy

Re: Fetch/Download gsheet using tFileFetch or any other component

Anonymous — Sun, 09 Oct 2022 11:10:26 GMT

@uday reddy , if the file are stored in Google drive, use the special tGoogleDrive component. Please read the Google drive documentation pages.

Regards

Shong

topic Re: Fetch/Download gsheet using tFileFetch or any other component in Talend Studio

Fetch/Download gsheet using tFileFetch or any other component

Re: Fetch/Download gsheet using tFileFetch or any other component