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 > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
