Google spreadsheets from appengine problems

Question

I want to read a specific Google Drive Spreadsheet from appengine. The spreadsheet is being picked using the Google picker from a web client. I am attempting to access the Spreadsheet by using the query by title. The title gets passed to my appengine servlet and then I query using the Gdata Java Client Lib.

on appengine I have this code:

public static FeedURLFactory factory = FeedURLFactory.getDefault();
public static SpreadsheetService spreadsheetService= new SpreadsheetService("evermedcpr");

List scopes = Arrays.asList("https://spreadsheets.google.com/feeds"); 
AppIdentityService appIdentity = AppIdentityServiceFactory.getAppIdentityService();
AppIdentityService.GetAccessTokenResult accessToken = appIdentity.getAccessToken(scopes);

Credential creds = new Credential(BearerToken.authorizationHeaderAccessMethod());         
creds.setAccessToken(accessToken.getAccessToken());

SpreadsheetService ss = new SpreadsheetService("DBM4G-demo"); 
ss.setOAuth2Credentials(creds);

getSpreadsheet(spreadsheetName);


public SpreadsheetEntry getSpreadsheet(String spreadsheet)
      throws Exception {

      SpreadsheetQuery spreadsheetQuery 
        = new SpreadsheetQuery(new URL("https://spreadsheets.google.com/feeds/"));
      spreadsheetQuery.setTitleQuery(spreadsheet);

      SpreadsheetFeed spreadsheetFeed = spreadsheetService.query(spreadsheetQuery, 
          SpreadsheetFeed.class);
      List<SpreadsheetEntry> spreadsheets = spreadsheetFeed.getEntries();
      if (spreadsheets.isEmpty()) {
        throw new Exception("No spreadsheets with that name");
      }

      return spreadsheets.get(0);
  }

}

I always get a 404 response in my logs:

com.google.api.client.googleapis.services.AbstractGoogleClient <init>: Application name is not set. Call Builder#setApplicationName.
W 2013-07-15 14:50:31.665
[s~evermedcpr/1.368807282351251748].<stderr>: An error occurred: com.google.api.client.googleapis.json.GoogleJsonResponseException: 404 OK
{
  "code" : 404,
  "errors" : [ {
    "domain" : "global",
    "message" : "Not Found",
    "reason" : "notFound"
  } ],
  "message" : "Not Found"
}

How do I go about accessing the selected spread sheet??

Is the OAuth bit working? If not, use the DrEdit tutorial to get OAuth working on App Engine. After that look at CellDemo.java to learn how to use the API. (Note google apps script is simpler option, rather than the spreadsheet API) — eddyparkinson
I guess this wants someone to post a full solution. I have code to do this, but would take me too many hours to extract just the bits that are needed, and debug etc. The DrEdit bit is quite big and a few changes are needed. — eddyparkinson
@eddyparkinson yes oauth is working. I've found the issue. I was using the wrong feedurl. will update soon. — Patrick

Loša Loša · Accepted Answer · 2013-07-16T17:05:48

You define the SpreadsheetService twice. Once as spreadsheetService and once as ss. You only set the OAuth2 credentials to ss, but you use spreadsheetService in your getSpreadsheet method.

You should replace this:

SpreadsheetService ss = new SpreadsheetService("DBM4G-demo"); 
ss.setOAuth2Credentials(creds);

with this:

spreadsheetService.setOAuth2Credentials(creds);

You also use two different application names - BM4G-demo and evermedcpr. I am not sure which one is correct, but it is probably evermedcpr according to the server log.

Another problem is the feed URL in the SpreadsheetQuery constructor. It should be https://spreadsheets.google.com/feeds/spreadsheets (if you want all spreadsheets) or https://spreadsheets.google.com/feeds/spreadsheets/private/full (if you want only private spreadsheets). See Google Spreadsheets documentation for more details about the feed URLs.

Google spreadsheets from appengine problems

2 Answers