Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@uday reddy , if the file are stored in Google drive, use the special tGoogleDrive component. Please read the Google drive documentation pages.
Regards
Shong