Hi All, As per the offline chat with Rajjaz, As a workaround I was able to read my spreadsheet by publishing it as a public document. Then the google spreadsheet is accessible as a CSV or webpage through a shared URL.
Thank you On Sat, Aug 8, 2015 at 5:44 PM, Rajjaz Mohammed <[email protected]> wrote: > Hi Rasika, > I also got that error while i'm try . If you need to connect in public > method please there is a option in sheet as publish so connect after > publish the sheet than it will connect. > On 8 Aug 2015 17:36, "Rasika Perera" <[email protected]> wrote: > >> Hi folks, >> >> I am using DSS 3.2.2 and trying to connect a Google spreadsheet following >> the DSS sample on [1]. When following parameters are provided; >> >> Google Spreadsheet URL: <SPREADSHEET_URL> >>> Visibility: Private >>> User Name: [email protected] / myusername >>> Password: <mypassword> >> >> >> I am getting "Invalid User Credentials" error(see error log on [2]). I >> can confirm provided credentials are correct. Then I tried setting >> visibility option to "Public" and provided a publicly accessible >> spreadsheet URL. >> >> Google Spreadsheet URL: <SPREADSHEET_URL> >>> Visibility: Public >> >> >> Now I am getting "URL Not found : RedirectRequiredException". It seems >> URL redirection is required(see the error log on [3]). >> >> Please correct me If I miss any additional configurations for connecting >> a google spreadsheet. >> >> [1] https://docs.wso2.com/display/DSS322/Google+Spreadsheet+Sample >> [2] Setting visibility private error trace >> >> [2015-08-08 17:04:55,448] ERROR >>> {org.wso2.carbon.dataservices.core.admin.DataServiceAdmin} - Invalid User >>> Credentials >>> com.google.gdata.util.AuthenticationException: Error authenticating >>> (check service name) >>> at >>> com.google.gdata.client.GoogleAuthTokenFactory.getAuthException(GoogleAuthTokenFactory.java:688) >>> at >>> com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:560) >>> at >>> com.google.gdata.client.GoogleAuthTokenFactory.setUserCredentials(GoogleAuthTokenFactory.java:397) >>> at >>> com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:364) >>> at >>> com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:319) >>> at >>> com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:303) >>> at org.wso2.carbon.dataservices.core.admin.DataServiceAdmin. >>> testGSpreadConnection(DataServiceAdmin.java:302) >> >> >> [3] Setting visibility public error trace >> >> [2015-08-08 17:18:24,167] ERROR >>> {org.wso2.carbon.dataservices.core.admin.DataServiceAdmin} - URL Not found: >>> https://docs.google.com/spreadsheets/d/xxxxxxxxxx/edit?usp=sharing >>> com.google.gdata.util.RedirectRequiredException: Moved Temporarily >>> <HTML> >>> <HEAD> >>> <TITLE>Moved Temporarily</TITLE> >>> </HEAD> >>> <BODY BGCOLOR="#FFFFFF" TEXT="#000000"> >>> <H1>Moved Temporarily</H1> >>> The document has moved <A HREF=" >>> https://accounts.google.com/ServiceLogin?service=wise&passive=1209600&continue=https%3A%2F%2Fspreadsheets.google.com%2Ffeeds%2Fworksheets%xxxxx%2Fpublic%2Fbasic&followup=https%3A%2F%2Fspreadsheets.google.com%2Ffeeds%2Fworksheets%xxxxxxx%2Fpublic%2Fbasic&ltmpl=sheets >>> ">here</A>. >>> </BODY> >>> </HTML> >> >> >> at >> com.google.gdata.client.http.GoogleGDataRequest.handleErrorResponse(GoogleGDataRequest.java:562) >> at >> com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:560) >> at >> com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:538) >> at >> com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:536) >> at com.google.gdata.client.Service.getFeed(Service.java:1135) >> at com.google.gdata.client.Service.getFeed(Service.java:998) >> at com.google.gdata.client.GoogleService.getFeed(GoogleService.java:652) >> at com.google.gdata.client.Service.getFeed(Service.java:1017) >> at >> org.wso2.carbon.dataservices.core.admin.DataServiceAdmin.testGSpreadConnection(DataServiceAdmin.java:314) >> >> >> -- >> With Regards, >> >> *Rasika Perera* >> Software Engineer >> M: +94 71 680 9060 E: [email protected] >> LinkedIn: http://lk.linkedin.com/in/rasika90 >> >> WSO2 Inc. www.wso2.com >> lean.enterprise.middleware >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> -- With Regards, *Rasika Perera* Software Engineer M: +94 71 680 9060 E: [email protected] LinkedIn: http://lk.linkedin.com/in/rasika90 WSO2 Inc. www.wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
