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: myusern...@gmail.com / 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: rasi...@wso2.com LinkedIn: http://lk.linkedin.com/in/rasika90 WSO2 Inc. www.wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev