Hi Shahi, I believe this was related to a recent issue that has now been fixed which was returning the wrong URI for worksheets [1]. Could you confirm please that it is now working as you expect? Thanks
Regards [1] https://groups.google.com/group/google-apps-apis-downtime-notify/browse_thread/thread/5b2930706388eddd?hl=en On Tue, Aug 30, 2011 at 1:05 PM, OpenEntry Shahi <[email protected]> wrote: > I am really stuck with this problem because it was working fine some two > days ago or so. > What i have done is uploading the xls file using the DocumentListEntry which > gives me SpreadsheetEntry and then trying to get the first worksheetEntry > from the newly created SpreadsheetEntry as follows: > SpreadsheetEntry.getWorksheets().get(0). I have 3 worksheets on my uploaded > xls file. But when trying to get the first worksheet, i am getting Not Found > error. As already mentioned, this was working fine some days ago. > > To make it more clear, i am providing my sample code below: > > private DocumentListEntry uploadFile(String filepath, String title) throws > IOException, ServiceException { > File file = new File(filepath); > String mimeType = > DocumentListEntry.MediaType.fromFileName(file.getName()).getMimeType(); > SpreadsheetEntry spreadsheetEntry = new SpreadsheetEntry(); > spreadsheetEntry.setFile(file, mimeType); > spreadsheetEntry.setTitle(new PlainTextConstruct(title)); > spreadsheetEntry = client.insert(new > URL("https://docs.google.com/feeds/default/private/full/";), > spreadsheetEntry);//client is an authenticated DocsService object > > myService = new > SpreadsheetService("openentry-catalog-1");//myService is an authenticated > SpreadsheetService object > myService.setAuthSubToken(sessionToken, privateKey); > SpreadsheetEntry spreadsheet = (SpreadsheetEntry) spreadsheetEntry; > WorksheetEntry companyWorksheet = > spreadsheet.getWorksheets().get(0); //at this point the exception is thrown > which is listed below > } > > Thrown Exception > com.google.gdata.util.ResourceNotFoundException: OK > <HTML> > <HEAD> > <TITLE>Not Found</TITLE> > </HEAD> > <BODY BGCOLOR="#FFFFFF" TEXT="#000000"> > <H1>Not Found</H1> > <H2>Error 404</H2> > </BODY> > </HTML> > > at > com.google.gdata.client.http.HttpGDataRequest.handleErrorResponse(HttpGDataRequest.java:555) > at > com.google.gdata.client.http.GoogleGDataRequest.handleErrorResponse(GoogleGDataRequest.java:563) > at > com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:536) > at > com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:515) > at > com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:535) > at com.google.gdata.client.Service.getFeed(Service.java:1073) > -- Ali Afshar | www.googplus.org/ali | Google Developer Relations
