CODEWITHSUNDEEP
c#.netmonogoogle-sheets
Maurits Rijk
Maurits Rijk

Reputation: 9985

Accessing Google Spreadsheets with C# using Google Data API fails with Mono

I'm trying to access my Google spreadsheets using the GData API. I have followed the example which looks like:

var service = new SpreadsheetsService("myTest");
service.setUserCredentials(username, password);
var query = new SpreadsheetQuery();
var feed = service.Query(query);

This should return a feed with a list of spreadsheets. However this fails with:

Google.GData.Client.GDataRequestException: Execution of request failed: http://spreadsheets.google.com/feeds/spreadsheets/private/full ---> System.Net.WebException: The remote server returned an error: (404) Not Found.

When I try the above link directly in my browser I'm able to download the feed, as long as I'm logged in into my Google account.

Some further information:

  1. I'm not behind a firewall
  2. I have checked my username (maurits.rijk at gmail.com) and password several times
  3. I am using Mandriva in VirtualBox on a MacBook
  4. All my code is compiled with Mono

I tried the same functionality in Java on OS-X. That code runs as expected.

Upvotes: 1

Views: 1935

Answers (2)

Maurits Rijk
Maurits Rijk

Reputation: 9985

I found the problem and solution on Google code, Issue 88 as comment 8.

In short, using

mozroots --import --sync --quiet

solves this problem. For me it now works.

Upvotes: 1

systempuntoout
systempuntoout

Reputation: 74064

Looks like a Mono problem to me.
Could you test with fiddler to test if your call reach the server?

Upvotes: 1

Related Questions