Fetch/Download gsheet using tFileFetch or any other component

[Uday_Reddy1]

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-1vQ3UTujmMShyju2dSWUxN10JtKEPMmUIInNGAam1gfWrZTjFeeRp..."

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

[Anonymous]

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

Regards

Shong