blocks|key|2700432|text|我已经设法通过将此解决方案与oAuth2.0+Accessing+older+GData+APIs+(Spreadsheet+API)+using+OAuth+2+and+a+service+account的服务帐户一起使用来解决此问题|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2700433|解决方案:+1.在https://console.developers.google.com/project中创建项目和谷歌服务帐户|2700434|2700435|生成您的p12密钥。|ordered-list-item|2700436|允许在开发人员控制台中使用您要使用的API(基本上我们将使用旧的API，因此您可以跳过此步骤，但以防万一)|2700437|使用以下代码(.NET+Framework4.5！)|2700438|也不要忘记在您通过按共享为普通用户授予权限时授予"youraccount@developer.gserviceaccount.com“对电子表格文档的访问权限。|2700439|<+code+>G211|2700440|代码：|2700441|using+System.Security.Cryptography.X509Certificates;
using+Google.GData.Client;
using+Google.GData.Extensions;
using+Google.GData.Spreadsheets;
using+Google.Apis.Auth.OAuth2;

string+keyFilePath+=+@"C:\key.p12";++++//+found+in+developer+console
string+serviceAccountEmail+=+"youraccount@developer.gserviceaccount.com";+++//+found+in+developer+console
var+certificate+=+new+X509Certificate2(keyFilePath,+"notasecret",+X509KeyStorageFlags.Exportable);

ServiceAccountCredential+credential+=+new+ServiceAccountCredential(new+ServiceAccountCredential.Initializer(serviceAccountEmail)+//create+credential+using+certificate
++++++++{
++++++++++++Scopes+=+new[]+{+"https://spreadsheets.google.com/feeds/"+}+//this+scopr+is+for+spreadsheets,+check+google+scope+FAQ+for+others
++++++++}.FromCertificate(certificate));

credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Wait();+//request+token

var+requestFactory+=+new+GDataRequestFactory("Some+Name");+
requestFactory.CustomHeaders.Add(string.Format("Authorization:+Bearer+{0}",+credential.Token.AccessToken));

SpreadsheetsService+myService+=+new+SpreadsheetsService("You+App+Name");+//create+your+old+service
myService.RequestFactory+=+requestFactory;+//add+new+request+factory+to+your+old+service

SpreadsheetQuery+query+=+new+SpreadsheetQuery();+//do+the+job+as+you+done+it+before
SpreadsheetFeed+feed+=+myService.Query(query);|code-block|syntax|javascript|2700442|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/13664731/accessing-older-gdata-apis-spreadsheet-api-using-oauth-2-and-a-service-account|1|https://console.developers.google.com/project^0|N|28|0|0|9|19|1|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|F|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1H|8|@]|9|@]|C|$]]|$1|J|3|K|5|I|7|1I|8|@]|9|@]|C|$]]|$1|L|3|M|5|I|7|1J|8|@]|9|@]|C|$]]|$1|N|3|O|5|I|7|1K|8|@]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1L|8|@]|9|@]|C|$]]|$1|R|3|S|5|6|7|1M|8|@]|9|@]|C|$]]|$1|T|3|U|5|V|7|1N|8|@]|9|@]|C|$W|X]]|$1|Y|3|-4|5|6|7|1O|8|@]|9|@]|C|$]]]|Z|$10|$5|11|12|13|C|$14|15]]|16|$5|11|12|13|C|$14|17]]]]

I've managed to solve this by using this solution with Service Account with oAuth2.0 
<a href="https://stackoverflow.com/questions/13664731/accessing-older-gdata-apis-spreadsheet-api-using-oauth-2-and-a-service-account">Accessing older GData APIs (Spreadsheet API) using OAuth 2 and a service account</a>

The solution:
1. Create Project and Google Service Account in <a href="https://console.developers.google.com/project" rel="nofollow noreferrer">https://console.developers.google.com/project</a>

<ol start="2">
<li>Generate your p12 key.</li>
<li>Allow APIs in Developer console you want to use (basically we are going to use old API, so you can skip this step, but just in case)</li>
<li>Use the code below (.NET Framework 4.5!)</li>
<li>Also don't forget to grant "youraccount@developer.gserviceaccount.com" access to your spreadsheet document as you grant permissions for usual users by pressing Share.</li>
</ol>

Code:

<pre><code>using System.Security.Cryptography.X509Certificates;
using Google.GData.Client;
using Google.GData.Extensions;
using Google.GData.Spreadsheets;
using Google.Apis.Auth.OAuth2;

string keyFilePath = @"C:\key.p12"; // found in developer console
string serviceAccountEmail = "youraccount@developer.gserviceaccount.com"; // found in developer console
var certificate = new X509Certificate2(keyFilePath, "notasecret", X509KeyStorageFlags.Exportable);

ServiceAccountCredential credential = new ServiceAccountCredential(new ServiceAccountCredential.Initializer(serviceAccountEmail) //create credential using certificate
 {
 Scopes = new[] { "https://spreadsheets.google.com/feeds/" } //this scopr is for spreadsheets, check google scope FAQ for others
 }.FromCertificate(certificate));

credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Wait(); //request token

var requestFactory = new GDataRequestFactory("Some Name"); 
requestFactory.CustomHeaders.Add(string.Format("Authorization: Bearer {0}", credential.Token.AccessToken));

SpreadsheetsService myService = new SpreadsheetsService("You App Name"); //create your old service
myService.RequestFactory = requestFactory; //add new request factory to your old service

SpreadsheetQuery query = new SpreadsheetQuery(); //do the job as you done it before
SpreadsheetFeed feed = myService.Query(query);
</code></pre>

blocks|key|2700531|text|安德鲁，我想知道你怎么弄到google.apis.auth.oauth2动态链接库的。我正在尝试实现你的修复，但我找不到正确的方法来安装库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2700532|我觉得在我有了那个部分之后，我也许能让它工作。|2700533|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Andrew I was wondering how you got the google.apis.auth.oauth2 dll. Im trying to impliment your fix and I cant find the correct way to install the library. 

I feel like I may be able to get this to work after I have that part.

blocks|key|135500|text|好吧，我想通了。一步一步的说明，如下所示-另请参阅我在下面提供的代码。仅供参考，它在.Net+3.5中运行，与以前提供的解决方案不同，它没有新的依赖项。您应该在任何时间内启动并运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|135501|135502|如果您还没有创建您的OAuth+2.0凭据-我假设您已经知道如何获得这些凭据，但在这里：|ordered-list-item|135503|135504|a)登录到你的谷歌开发者控制台：http://console.developers.google.com+b)创建一个项目c)创建你的凭证-使用‘已安装的应用程序’d)添加你需要的API+-我认为Drive+API是绝对必要的。我还添加了Drive+SDK以防万一。|offset|length|135505|将以下代码复制到VS中，并使用客户端密钥和密钥编辑第一个Main()方法。|unordered-list-item|135506|
|135507|运行应用程序并复制新的访问令牌和刷新令牌。将这些凭据和剩余的凭据放入下面的第二个Main()方法中。|135508|135509|您现在应该能够运行第二个Main()方法(只需颠倒命名)。从现在开始，这就是您所需要的--不需要重新运行第一个Main()方法。|135510|135511|顺便说一句，下面的第一个Main()方法可以在这里找到：https://developers.google.com/google-apps/spreadsheets/authorize|135512|但是，我添加了缺少的令牌类型以及访问类型。这些都是必需的，所以使用下面的代码：|135513|using+System;
using+Google.GData.Client;
using+Google.GData.Spreadsheets;
using+Google.GData.Documents;
using+System.Configuration;
using+System.Collections.Specialized;

namespace+GoogleSpreadsheet
{
++class+GoogleOAutho2
++{

++++private+static+String+folderName+=+"crazy.ivan";


++++static+void+Main(string[]+args)
++++{
++++++////////////////////////////////////////////////////////////////////////////
++++++//+STEP+1:+Configure+how+to+perform+OAuth+2.0
++++++////////////////////////////////////////////////////////////////////////////

++++++//+TODO:+Update+the+following+information+with+that+obtained+from
++++++//+https://code.google.com/apis/console.+After+registering
++++++//+your+application,+these+will+be+provided+for+you.

++++++string+CLIENT_ID+=+"your_client_id";

++++++//+This+is+the+OAuth+2.0+Client+Secret+retrieved
++++++//+above.++Be+sure+to+store+this+value+securely.++Leaking+this
++++++//+value+would+enable+others+to+act+on+behalf+of+your+application!
++++++string+CLIENT_SECRET+=+"your_secret_key"

++++++//+Space+separated+list+of+scopes+for+which+to+request+access.
++++++string+SCOPE+=+"https://www.googleapis.com/auth/drive+https://spreadsheets.google.com/feeds+https://docs.google.com/feeds";

++++++//+This+is+the+Redirect+URI+for+installed+applications.
++++++//+If+you+are+building+a+web+application,+you+have+to+set+your
++++++//+Redirect+URI+at+https://code.google.com/apis/console.
++++++string+REDIRECT_URI+=+"urn:ietf:wg:oauth:2.0:oob";

++++++string+TOKEN_TYPE+=+"refresh";

++++++////////////////////////////////////////////////////////////////////////////
++++++//+STEP+2:+Set+up+the+OAuth+2.0+object
++++++////////////////////////////////////////////////////////////////////////////

++++++//+OAuth2Parameters+holds+all+the+parameters+related+to+OAuth+2.0.
++++++OAuth2Parameters+parameters+=+new+OAuth2Parameters();

++++++//+Set+your+OAuth+2.0+Client+Id+(which+you+can+register+at
++++++//+https://code.google.com/apis/console).
++++++parameters.ClientId+=+CLIENT_ID;

++++++//+Set+your+OAuth+2.0+Client+Secret,+which+can+be+obtained+at
++++++//+https://code.google.com/apis/console.
++++++parameters.ClientSecret+=+CLIENT_SECRET;

++++++//+Set+your+Redirect+URI,+which+can+be+registered+at
++++++//+https://code.google.com/apis/console.
++++++parameters.RedirectUri+=+REDIRECT_URI;

++++++////////////////////////////////////////////////////////////////////////////
++++++//+STEP+3:+Get+the+Authorization+URL
++++++////////////////////////////////////////////////////////////////////////////

++++++//+Set+the+scope+for+this+particular+service.
++++++parameters.Scope+=+SCOPE;

++++++parameters.AccessType+=+"offline";+//+IMPORTANT+and+was+missing+in+the+original

++++++parameters.TokenType+=+TOKEN_TYPE;+//+IMPORTANT+and+was+missing+in+the+original


++++++//+Get+the+authorization+url.++The+user+of+your+application+must+visit
++++++//+this+url+in+order+to+authorize+with+Google.++If+you+are+building+a
++++++//+browser-based+application,+you+can+redirect+the+user+to+the+authorization
++++++//+url.
++++++string+authorizationUrl+=+OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
++++++Console.WriteLine(authorizationUrl);
++++++Console.WriteLine("Please+visit+the+URL+above+to+authorize+your+OAuth+"
++++++++%2B+"request+token.++Once+that+is+complete,+type+in+your+access+code+to+"
++++++++%2B+"continue...");
++++++parameters.AccessCode+=+Console.ReadLine();

++++++////////////////////////////////////////////////////////////////////////////
++++++//+STEP+4:+Get+the+Access+Token
++++++////////////////////////////////////////////////////////////////////////////

++++++//+Once+the+user+authorizes+with+Google,+the+request+token+can+be+exchanged
++++++//+for+a+long-lived+access+token.++If+you+are+building+a+browser-based
++++++//+application,+you+should+parse+the+incoming+request+token+from+the+url+and
++++++//+set+it+in+OAuthParameters+before+calling+GetAccessToken().
++++++OAuthUtil.GetAccessToken(parameters);
++++++string+accessToken+=+parameters.AccessToken;
++++++string+refreshToken+=+parameters.RefreshToken;
++++++Console.WriteLine("OAuth+Access+Token:+"+%2B+accessToken+%2B+"\n");
++++++Console.WriteLine("OAuth+Refresh+Token:+"+%2B+refreshToken+%2B+"\n");

++++++////////////////////////////////////////////////////////////////////////////
++++++//+STEP+5:+Make+an+OAuth+authorized+request+to+Google
++++++////////////////////////////////////////////////////////////////////////////

++++++//+Initialize+the+variables+needed+to+make+the+request
++++++GOAuth2RequestFactory+requestFactory+=
++++++++++new+GOAuth2RequestFactory(null,+"MySpreadsheetIntegration-v1",+parameters);
++++++SpreadsheetsService+service+=+new+SpreadsheetsService("MySpreadsheetIntegration-v1");
++++++service.RequestFactory+=+requestFactory;

++++++//+Make+the+request+to+Google
++++++//+See+other+portions+of+this+guide+for+code+to+put+here...

++++++//+Instantiate+a+SpreadsheetQuery+object+to+retrieve+spreadsheets.
++++++Google.GData.Spreadsheets.SpreadsheetQuery+query+=+new+Google.GData.Spreadsheets.SpreadsheetQuery();

++++++//+Make+a+request+to+the+API+and+get+all+spreadsheets.
++++++SpreadsheetFeed+feed+=+service.Query(query);

++++++//+Iterate+through+all+of+the+spreadsheets+returned
++++++foreach+(SpreadsheetEntry+entry+in+feed.Entries)
++++++{
++++++++//+Print+the+title+of+this+spreadsheet+to+the+screen
++++++++Console.WriteLine(entry.Title.Text);
++++++}
++++++Console.ReadLine();

+++++}


++++//+once+you+copied+your+access+and+refresh+tokens
++++//+then+you+can+run+this+method+directly+from+now+on...
++++static+void+MainX(string[]+args)
++++{
++++GOAuth2RequestFactory+requestFactory+=+RefreshAuthenticate();

+++++++++SpreadsheetsService+service+=+new+SpreadsheetsService("MySpreadsheetIntegration-v1");++
+++++++++service.RequestFactory+=+requestFactory;

++++++//+Instantiate+a+SpreadsheetQuery+object+to+retrieve+spreadsheets.
++++++Google.GData.Spreadsheets.SpreadsheetQuery+query+=+new+Google.GData.Spreadsheets.SpreadsheetQuery();

++++++//+Make+a+request+to+the+API+and+get+all+spreadsheets.
++++++SpreadsheetFeed+feed+=+service.Query(query);

++++++//+Iterate+through+all+of+the+spreadsheets+returned
++++++foreach+(SpreadsheetEntry+entry+in+feed.Entries)
++++++{
++++++++//+Print+the+title+of+this+spreadsheet+to+the+screen
++++++++Console.WriteLine(entry.Title.Text);
++++++}
++++++Console.ReadLine();



++++public+static+GOAuth2RequestFactory+RefreshAuthenticate()+{
++++++++OAuth2Parameters+parameters+=+new+OAuth2Parameters(){
++++++++++++RefreshToken+=+"the_refresh_token_you_copied_from_the_CLI_running_the_first_method";
++++++++++++AccessToken+=+"the_access_token_you_copied_from_the_CLI_running_the_first_method";
++++++++++++ClientId+=+"your_client_id";
++++++++++++ClientSecret+=+"your_dirty_little_secret";
++++++++++++Scope+=+"https://www.googleapis.com/auth/drive+https://spreadsheets.google.com/feeds",
++++++++++++AccessType+=+"offline",
++++++++++++TokenType+=+"refresh"
++++++++};
++++++++string+authUrl+=+OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
++++++++return+new+GOAuth2RequestFactory(null,+"evilspeculator",+parameters);
++++}
++}
}|code-block|syntax|javascript|135514|希望这对你们有用--祝你们好运！|135515|entityMap|0|LINK|mutability|MUTABLE|url|http://console.developers.google.com/|1|https://developers.google.com/google-apps/spreadsheets/authorize^0|0|0|0|0|G|10|0|0|0|0|0|0|0|0|S|1S|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1I|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1K|8|@]|9|@$I|1L|J|1M|1|1N]]|A|$]]|$1|K|3|L|5|M|7|1O|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1P|8|@]|9|@]|A|$]]|$1|P|3|Q|5|M|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|O|5|6|7|1R|8|@]|9|@]|A|$]]|$1|S|3|T|5|M|7|1S|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1U|8|@]|9|@$I|1V|J|1W|1|1X]]|A|$]]|$1|X|3|Y|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Z|3|10|5|11|7|1Z|8|@]|9|@]|A|$12|13]]|$1|14|3|15|5|6|7|20|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|21|8|@]|9|@]|A|$]]]|17|$18|$5|19|1A|1B|A|$1C|1D]]|1E|$5|19|1A|1B|A|$1C|1F]]]]

Alright, I figured it out. Step by step instructions as follows - also see the code I provided below. FYI, this runs in .Net 3.5 and unlike the solution offered previously there are no new dependencies. You should be up and running in no time.

<ol>
<li>If you haven't yet create your OAuth 2.0 credentials - I assume you already know how to get those but here:

a) Log into your Google developer console: <a href="http://console.developers.google.com" rel="nofollow">http://console.developers.google.com</a>
b) Create a project
c) Create your credentials - use 'installed application'
d) add the APIs that you need - I think Drive API is definitely required. I also added Drive SDK just in case.</li>
<li>Copy the code below into VS and edit the first Main() method with your client key and secret key.</li>
<li>Run the app and copy both the new access token and the refresh token. Put those and your remaining credentials into the second Main() method below.</li>
<li>You now should be able to run the second Main() method (just reverse the naming). From now on that will be all you need - there is no need to re-run the first Main() method.</li>
</ol>

BTW, the first Main() method below was found here: <a href="https://developers.google.com/google-apps/spreadsheets/authorize" rel="nofollow">https://developers.google.com/google-apps/spreadsheets/authorize</a>

I did however add the missing token type as well the access type. Those are needed, so use the code below:

<pre><code>using System;
using Google.GData.Client;
using Google.GData.Spreadsheets;
using Google.GData.Documents;
using System.Configuration;
using System.Collections.Specialized;

namespace GoogleSpreadsheet
{
 class GoogleOAutho2
 {

 private static String folderName = "crazy.ivan";


 static void Main(string[] args)
 {
 ////////////////////////////////////////////////////////////////////////////
 // STEP 1: Configure how to perform OAuth 2.0
 ////////////////////////////////////////////////////////////////////////////

 // TODO: Update the following information with that obtained from
 // https://code.google.com/apis/console. After registering
 // your application, these will be provided for you.

 string CLIENT_ID = "your_client_id";

 // This is the OAuth 2.0 Client Secret retrieved
 // above. Be sure to store this value securely. Leaking this
 // value would enable others to act on behalf of your application!
 string CLIENT_SECRET = "your_secret_key"

 // Space separated list of scopes for which to request access.
 string SCOPE = "https://www.googleapis.com/auth/drive https://spreadsheets.google.com/feeds https://docs.google.com/feeds";

 // This is the Redirect URI for installed applications.
 // If you are building a web application, you have to set your
 // Redirect URI at https://code.google.com/apis/console.
 string REDIRECT_URI = "urn:ietf:wg:oauth:2.0:oob";

 string TOKEN_TYPE = "refresh";

 ////////////////////////////////////////////////////////////////////////////
 // STEP 2: Set up the OAuth 2.0 object
 ////////////////////////////////////////////////////////////////////////////

 // OAuth2Parameters holds all the parameters related to OAuth 2.0.
 OAuth2Parameters parameters = new OAuth2Parameters();

 // Set your OAuth 2.0 Client Id (which you can register at
 // https://code.google.com/apis/console).
 parameters.ClientId = CLIENT_ID;

 // Set your OAuth 2.0 Client Secret, which can be obtained at
 // https://code.google.com/apis/console.
 parameters.ClientSecret = CLIENT_SECRET;

 // Set your Redirect URI, which can be registered at
 // https://code.google.com/apis/console.
 parameters.RedirectUri = REDIRECT_URI;

 ////////////////////////////////////////////////////////////////////////////
 // STEP 3: Get the Authorization URL
 ////////////////////////////////////////////////////////////////////////////

 // Set the scope for this particular service.
 parameters.Scope = SCOPE;

 parameters.AccessType = "offline"; // IMPORTANT and was missing in the original

 parameters.TokenType = TOKEN_TYPE; // IMPORTANT and was missing in the original


 // Get the authorization url. The user of your application must visit
 // this url in order to authorize with Google. If you are building a
 // browser-based application, you can redirect the user to the authorization
 // url.
 string authorizationUrl = OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
 Console.WriteLine(authorizationUrl);
 Console.WriteLine("Please visit the URL above to authorize your OAuth "
 + "request token. Once that is complete, type in your access code to "
 + "continue...");
 parameters.AccessCode = Console.ReadLine();

 ////////////////////////////////////////////////////////////////////////////
 // STEP 4: Get the Access Token
 ////////////////////////////////////////////////////////////////////////////

 // Once the user authorizes with Google, the request token can be exchanged
 // for a long-lived access token. If you are building a browser-based
 // application, you should parse the incoming request token from the url and
 // set it in OAuthParameters before calling GetAccessToken().
 OAuthUtil.GetAccessToken(parameters);
 string accessToken = parameters.AccessToken;
 string refreshToken = parameters.RefreshToken;
 Console.WriteLine("OAuth Access Token: " + accessToken + "\n");
 Console.WriteLine("OAuth Refresh Token: " + refreshToken + "\n");

 ////////////////////////////////////////////////////////////////////////////
 // STEP 5: Make an OAuth authorized request to Google
 ////////////////////////////////////////////////////////////////////////////

 // Initialize the variables needed to make the request
 GOAuth2RequestFactory requestFactory =
 new GOAuth2RequestFactory(null, "MySpreadsheetIntegration-v1", parameters);
 SpreadsheetsService service = new SpreadsheetsService("MySpreadsheetIntegration-v1");
 service.RequestFactory = requestFactory;

 // Make the request to Google
 // See other portions of this guide for code to put here...

 // Instantiate a SpreadsheetQuery object to retrieve spreadsheets.
 Google.GData.Spreadsheets.SpreadsheetQuery query = new Google.GData.Spreadsheets.SpreadsheetQuery();

 // Make a request to the API and get all spreadsheets.
 SpreadsheetFeed feed = service.Query(query);

 // Iterate through all of the spreadsheets returned
 foreach (SpreadsheetEntry entry in feed.Entries)
 {
 // Print the title of this spreadsheet to the screen
 Console.WriteLine(entry.Title.Text);
 }
 Console.ReadLine();

 }


 // once you copied your access and refresh tokens
 // then you can run this method directly from now on...
 static void MainX(string[] args)
 {
 GOAuth2RequestFactory requestFactory = RefreshAuthenticate();

 SpreadsheetsService service = new SpreadsheetsService("MySpreadsheetIntegration-v1"); 
 service.RequestFactory = requestFactory;

 // Instantiate a SpreadsheetQuery object to retrieve spreadsheets.
 Google.GData.Spreadsheets.SpreadsheetQuery query = new Google.GData.Spreadsheets.SpreadsheetQuery();

 // Make a request to the API and get all spreadsheets.
 SpreadsheetFeed feed = service.Query(query);

 // Iterate through all of the spreadsheets returned
 foreach (SpreadsheetEntry entry in feed.Entries)
 {
 // Print the title of this spreadsheet to the screen
 Console.WriteLine(entry.Title.Text);
 }
 Console.ReadLine();



 public static GOAuth2RequestFactory RefreshAuthenticate() {
 OAuth2Parameters parameters = new OAuth2Parameters(){
 RefreshToken = "the_refresh_token_you_copied_from_the_CLI_running_the_first_method";
 AccessToken = "the_access_token_you_copied_from_the_CLI_running_the_first_method";
 ClientId = "your_client_id";
 ClientSecret = "your_dirty_little_secret";
 Scope = "https://www.googleapis.com/auth/drive https://spreadsheets.google.com/feeds",
 AccessType = "offline",
 TokenType = "refresh"
 };
 string authUrl = OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
 return new GOAuth2RequestFactory(null, "evilspeculator", parameters);
 }
 }
}
</code></pre>

Hope that works for you guys - best of luck!

blocks|key|2912843|text|谷歌已经停用了他们的旧身份验证API。应该改用OAuth+2.0。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912844|我花了太多的时间来弄清楚如何在旧的GData+API中使用新的Auth+API，从互联网上获取零星的信息。为了节省你的时间，我决定用截图分享所有的细节。|2912845|2912846|Go+to+https://console.developers.google.com/project|ordered-list-item|offset|length|2912847|Hit+Create+Project+|style|CODE|2912848|按钮|2912849|​|2912850|📷|atomic|2912851|2912852|2912853|创建项目。键入某个名称。|2912854|2912855|2912856|2912857|2912858|2912859|进入API+&+Auth+>+Credentials并点击Create+new+Client+ID按钮。它将自动为您创建JSON密钥-忽略该密钥。|2912860|2912861|2912862|2912863|2912864|命中Generate+new+P12+key的|2912865|2912866|2912867|2912868|2912869|2912870|2912871|文件下载将自动开始。记住密码，打开刚刚下载的文件时需要密码。|2912872|2912873|2912874|2912875|2912876|2912877|将下载的文件重命名为Key.p12并将其添加到您的解决方案中。确保设置了accordingly.|2912878|的Build+Action和Copy+to+Output+Directory|2912879|2912880|2912881|2912882|2912883|使用Nuget安装Google+API+Auth。在Package+Manager控制台中键入以下内容|2912884|2912885|安装-打包Google.Apis.Auth|2912886|2912887|2912888|2912889|在步骤#4中生成的|2912890|复制服务帐户电子邮件地址。|2912891|2912892|2912893|2912894|2912895|在您的|2912896|中，通过以下代码向该用户授予适当的权限，以查询电子表格。在下面的代码中替换电子邮件和Google电子表格URL地址。|2912897|2912898|const+string+ServiceAccountCredential.Initializer(ServiceAccountEmail)+=+"452351479-q41ce1720qd9l94s8847mhc0toao1fed@developer.gserviceaccount.com"；var+ServiceAccountEmail+=+ServiceAccountCredential(serviceAccountCredentialInitializer)；X509Certificate2("Key.p12"，"notasecret"，X509KeyStorageFlags.Exportable)；var+serviceAccountCredentialInitializer+=+new+ServiceAccountCredential(serviceAccountCredentialInitializer)；{+Scopes+=https://spreadsheets.google.com/feeds{“.FromCertificate”}证书(ServiceAccountEmail)；var+X509Certificate2=如果(!credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Result)抛出新的证书(“访问令牌请求失败”)，则返回新的InvalidOperationException；var+requestFactory+=新服务(Null)；requestFactory.CustomHeaders.Add("Authorization:承载“%2B+credential.Token.AccessToken)；var+RequestFactory+=新服务(Null){+requestFactory+=requestFactory+}；var+requestFactory=新查询(”https://spreadsheets.google.com/feeds/list/0ApZkobM61WIrdGRYshh345523VNsLWc/1/private/full")；var+GDataRequestFactory=service.Query(查询)；var+rows+=+feed.Entries+.Cast()+.Select(arg+=>+new+{+Field0+=+arg.Elements.Value，Field1+=+arg.Elements1.Value+})+.ToList();|2912899|entityMap|0|LINK|mutability|MUTABLE|url|https://console.developers.google.com/project|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/41be134bea5d52070b003c1f9536d8df.png|imageAlt|2|https://ask.qcloudimg.com/http-save/yehe-900000/144450d53df4f77089ad21c57dc05f37.png|3|https://ask.qcloudimg.com/http-save/yehe-900000/1af47966cc98ab8d62f6c1a2ec8a28e6.png|4|https://ask.qcloudimg.com/http-save/yehe-900000/87a0fafecdfe88fa29bf75c9b2b7b025.png|5|https://ask.qcloudimg.com/http-save/yehe-900000/fdf5c6645a2996a8839f9b985d93ec07.png|6|https://ask.qcloudimg.com/http-save/yehe-900000/c1326ceed7ca5c9d58b40472514dd003.png|7|https://ask.qcloudimg.com/http-save/yehe-900000/1d2d14552500099f7e44537b7f094cf3.png|8|https://ask.qcloudimg.com/http-save/yehe-900000/04e6648839d539fb0da6719872b18712.png|9|https://spreadsheets.google.com/feeds|10|https://spreadsheets.google.com/feeds/list/0ApZkobM61WIrdGRYshh345523VNsLWc/1/private/full^0|0|0|0|6|19|0|0|4|E|0|0|0|0|1|1|0|0|0|0|0|0|0|1|2|0|0|0|2|A|F|B|T|K|0|0|0|0|1|3|0|0|2|K|0|0|0|0|0|1|4|0|0|0|0|0|0|0|1|5|0|0|0|0|1|C|E|O|0|0|0|1|6|0|0|0|0|0|0|0|0|1|7|0|0|0|0|0|0|0|1|8|0|0|0|0|0|BU|11|9|O2|2J|A|0^^$0|@$1|2|3|4|5|6|7|3F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|3G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|3H|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|3I|8|@]|9|@$H|3J|I|3K|1|3L]]|A|$]]|$1|J|3|K|5|G|7|3M|8|@$H|3N|I|3O|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|3P|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|3Q|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|3R|8|@]|9|@$H|3S|I|3T|1|3U]]|A|$]]|$1|U|3|Q|5|6|7|3V|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|3W|8|@]|9|@]|A|$]]|$1|W|3|X|5|G|7|3X|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|3Y|8|@]|9|@]|A|$]]|$1|Z|3|Q|5|6|7|3Z|8|@]|9|@]|A|$]]|$1|10|3|S|5|T|7|40|8|@]|9|@$H|41|I|42|1|43]]|A|$]]|$1|11|3|Q|5|6|7|44|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|45|8|@]|9|@]|A|$]]|$1|13|3|14|5|G|7|46|8|@$H|47|I|48|L|M]|$H|49|I|4A|L|M]|$H|4B|I|4C|L|M]]|9|@]|A|$]]|$1|15|3|-4|5|6|7|4D|8|@]|9|@]|A|$]]|$1|16|3|Q|5|6|7|4E|8|@]|9|@]|A|$]]|$1|17|3|S|5|T|7|4F|8|@]|9|@$H|4G|I|4H|1|4I]]|A|$]]|$1|18|3|Q|5|6|7|4J|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|4K|8|@$H|4L|I|4M|L|M]]|9|@]|A|$]]|$1|1B|3|-4|5|G|7|4N|8|@]|9|@]|A|$]]|$1|1C|3|-4|5|6|7|4O|8|@]|9|@]|A|$]]|$1|1D|3|Q|5|6|7|4P|8|@]|9|@]|A|$]]|$1|1E|3|S|5|T|7|4Q|8|@]|9|@$H|4R|I|4S|1|4T]]|A|$]]|$1|1F|3|Q|5|6|7|4U|8|@]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|4V|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|G|7|4W|8|@]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|4X|8|@]|9|@]|A|$]]|$1|1K|3|Q|5|6|7|4Y|8|@]|9|@]|A|$]]|$1|1L|3|S|5|T|7|4Z|8|@]|9|@$H|50|I|51|1|52]]|A|$]]|$1|1M|3|Q|5|6|7|53|8|@]|9|@]|A|$]]|$1|1N|3|-4|5|6|7|54|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|G|7|55|8|@]|9|@]|A|$]]|$1|1Q|3|1R|5|6|7|56|8|@$H|57|I|58|L|M]|$H|59|I|5A|L|M]]|9|@]|A|$]]|$1|1S|3|Q|5|6|7|5B|8|@]|9|@]|A|$]]|$1|1T|3|S|5|T|7|5C|8|@]|9|@$H|5D|I|5E|1|5F]]|A|$]]|$1|1U|3|Q|5|6|7|5G|8|@]|9|@]|A|$]]|$1|1V|3|-4|5|6|7|5H|8|@]|9|@]|A|$]]|$1|1W|3|1X|5|G|7|5I|8|@]|9|@]|A|$]]|$1|1Y|3|-4|5|6|7|5J|8|@]|9|@]|A|$]]|$1|1Z|3|20|5|6|7|5K|8|@]|9|@]|A|$]]|$1|21|3|Q|5|6|7|5L|8|@]|9|@]|A|$]]|$1|22|3|S|5|T|7|5M|8|@]|9|@$H|5N|I|5O|1|5P]]|A|$]]|$1|23|3|Q|5|6|7|5Q|8|@]|9|@]|A|$]]|$1|24|3|25|5|6|7|5R|8|@]|9|@]|A|$]]|$1|26|3|27|5|G|7|5S|8|@]|9|@]|A|$]]|$1|28|3|-4|5|6|7|5T|8|@]|9|@]|A|$]]|$1|29|3|Q|5|6|7|5U|8|@]|9|@]|A|$]]|$1|2A|3|S|5|T|7|5V|8|@]|9|@$H|5W|I|5X|1|5Y]]|A|$]]|$1|2B|3|Q|5|6|7|5Z|8|@]|9|@]|A|$]]|$1|2C|3|2D|5|6|7|60|8|@]|9|@]|A|$]]|$1|2E|3|2F|5|G|7|61|8|@]|9|@]|A|$]]|$1|2G|3|-4|5|6|7|62|8|@]|9|@]|A|$]]|$1|2H|3|2I|5|6|7|63|8|@]|9|@$H|64|I|65|1|66]|$H|67|I|68|1|69]]|A|$]]|$1|2J|3|-4|5|6|7|6A|8|@]|9|@]|A|$]]]|2K|$2L|$5|2M|2N|2O|A|$2P|2Q]]|2R|$5|2S|2N|2T|A|$2U|2V|2W|-4]]|2X|$5|2S|2N|2T|A|$2U|2Y|2W|-4]]|2Z|$5|2S|2N|2T|A|$2U|30|2W|-4]]|31|$5|2S|2N|2T|A|$2U|32|2W|-4]]|33|$5|2S|2N|2T|A|$2U|34|2W|-4]]|35|$5|2S|2N|2T|A|$2U|36|2W|-4]]|37|$5|2S|2N|2T|A|$2U|38|2W|-4]]|39|$5|2S|2N|2T|A|$2U|3A|2W|-4]]|3B|$5|2M|2N|2O|A|$2P|3C]]|3D|$5|2M|2N|2O|A|$2P|3E]]]]

Google has retired their older authentication API. OAuth 2.0 should be used instead.

I spent too much time to figure out how to use newer Auth API with older GData API grabbing bits and pieces of information here and there from the Internet.
I decided to share all the the details with screenshots to save your time.

<ol>
<li>Go to <a href="https://console.developers.google.com/project">https://console.developers.google.com/project</a></li>
<li>Hit <code>Create Project</code> button</li>
</ol>

<img src="https://i.stack.imgur.com/IXUia.png" alt="enter image description here">

<ol start="3">
<li>Create project. Type in some name.</li>
</ol>

<img src="https://i.stack.imgur.com/hhmHh.png" alt="enter image description here">

<ol start="4">
<li>Go to <code>API &amp; Auth</code> > <code>Credentials</code> and hit <code>Create new Client ID</code> button. It will create JSON key for you automatically - ignore that.</li>
</ol>

<img src="https://i.stack.imgur.com/Dt8Bp.png" alt="enter image description here">

<ol start="5">
<li>Hit <code>Generate new P12 key</code></li>
</ol>

<img src="https://i.stack.imgur.com/o89ri.png" alt="enter image description here">

<ol start="6">
<li>File download will start automatically. Remember the password, you will need it to open the file you just downloaded.</li>
</ol>

<img src="https://i.stack.imgur.com/aI9eH.png" alt="enter image description here">

<ol start="7">
<li>Rename downloaded file to Key.p12 and add it to your solution. Make sure you set <code>Build Action</code> and <code>Copy to Output Directory</code> accordingly.</li>
</ol>

<img src="https://i.stack.imgur.com/PAVyW.png" alt="enter image description here">

<ol start="8">
<li>Install Google API Auth using Nuget. Type the following in the Package Manager Console

<pre><code>Install-Package Google.Apis.Auth
</code></pre></li>
</ol>

<img src="https://i.stack.imgur.com/SJrIV.png" alt="enter image description here">

<ol start="9">
<li>Copy service account email address that was generated in Step #4.</li>
</ol>

<img src="https://i.stack.imgur.com/i4vTm.png" alt="enter image description here">

<ol start="10">
<li>Grant appropriate permission to this user in your Google Spreadsheet.</li>
<li>Use the following code to query the spreadsheet. Replace email and Google spreadsheet URL address in the code below.

<pre><code>const string ServiceAccountEmail = "452351479-q41ce1720qd9l94s8847mhc0toao1fed@developer.gserviceaccount.com";

var certificate = new X509Certificate2("Key.p12", "notasecret", X509KeyStorageFlags.Exportable);

var serviceAccountCredentialInitializer = 
 new ServiceAccountCredential.Initializer(ServiceAccountEmail)
 {
 Scopes = new[] { "https://spreadsheets.google.com/feeds" }
 }.FromCertificate(certificate);

var credential = new ServiceAccountCredential(serviceAccountCredentialInitializer);

if (!credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Result)
 throw new InvalidOperationException("Access token request failed.");

var requestFactory = new GDataRequestFactory(null);
requestFactory.CustomHeaders.Add("Authorization: Bearer " + credential.Token.AccessToken);

var service = new SpreadsheetsService(null) { RequestFactory = requestFactory };

var query = new ListQuery("https://spreadsheets.google.com/feeds/list/0ApZkobM61WIrdGRYshh345523VNsLWc/1/private/full");
var feed = service.Query(query);

var rows = feed.Entries
 .Cast&lt;ListEntry&gt;()
 .Select(arg =&gt;
 new
 {
 Field0 = arg.Elements[0].Value,
 Field1 = arg.Elements[1].Value
 })
 .ToList();
</code></pre></li>
</ol>

I'm suddenly starting to get the following exception when attempting to authenticate and access a spreadsheet on Google drive:

<blockquote>
 Unhandled Exception: Google.GData.Client.GDataRequestException:
 Execution of aut hentication request returned unexpected
 result: 404
 at Google.GData.Client.Utilities.getAuthException(TokenCollection tokens,
 Htt pWebResponse response)
 at Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials
 gc, S tring serviceName, String applicationName, Boolean
 fUseKeepAlive, IWebProxy prox yServer, Uri
 clientLoginHandler)
 at Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials
 gc)
 at Google.GData.Client.GDataGAuthRequest.EnsureCredentials()
 at Google.GData.Client.GDataRequest.EnsureWebRequest()
 at Google.GData.Client.GDataGAuthRequest.EnsureWebRequest()
 at Google.GData.Client.GDataRequest.Execute()
 at Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter)
 at Google.GData.Client.GDataGAuthRequest.Execute()
 at Google.GData.Client.Service.Query(Uri queryUri, DateTime ifModifiedSince, String etag, Int64&amp; contentLength)
 at Google.GData.Client.Service.Query(FeedQuery feedQuery)
 at Google.GData.Documents.DocumentsService.Query(DocumentsListQuery
 feedQuery )
 at GoogleLogger.GoogleService.getLastXECLogRows(String folderName, String fileName, Int32 rows)
</blockquote>

This is in code that has been running for two years without any problems. I first thought that I may have lost access permissions on my production system but Google drive loads fine in my web browser. Tried it on several other systems and am getting the very same. 

Did they change something in the Google API today? This can't be coincidence!

Google.GData.Client.GDataRequestException - Authentication suddenly fails in old code

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当我尝试在Google drive上进行身份验证和访问电子表格时，突然开始遇到以下异常：未处理的异常: Google.GData.Client.Utilities.getAuthException(TokenCollection :在Google.GData.Client.Utilities.QueryClientLo...

问Google.GData.Client.GDataRequestException -在旧代码中身份验证突然失败
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Google.GData.Client.GDataRequestException -在旧代码中身份验证突然失败EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Google.GData.Client.GDataRequestException -在旧代码中身份验证突然失败
EN