Google Sheets Api请求的身份验证范围不足

Question

static string[] Scopes = { SheetsService.Scope.Spreadsheets };
static string ApplicationName = "Google Sheets API .NET Quickstart";
public String spreadsheetId;
SheetsService service;

public GoogleHandler(String id)
{
    spreadsheetId = id;
    UserCredential credential;
    using (var stream =
            new FileStream(@"bin\client_secret.json", FileMode.Open, FileAccess.Read))
    {
        string credPath = System.Environment.GetFolderPath(
            System.Environment.SpecialFolder.Personal);
        credPath = Path.Combine(credPath, ".credentials/sheets.googleapis.com-dotnet-quickstart.json");

        credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
            GoogleClientSecrets.Load(stream).Secrets,
            Scopes,
            "user",
            CancellationToken.None,
            new FileDataStore(credPath, true)).Result;
    }

    service = new SheetsService(new BaseClientService.Initializer()
    {
        HttpClientInitializer = credential,
        ApplicationName = ApplicationName,
    });
}

这是我为Google Sheets API编写的代码。我有static string[]Scopes={sheetsservice.scope.spreadsheets}；这是我找到的解决此问题的方法，但这并不能解决我的问题。我已经删除了我的.Credentials文件夹，它不提示我登录。

Answer 1

credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
            GoogleClientSecrets.Load(stream).Secrets,
            Scopes,
            "user",
            CancellationToken.None
            //new FileDataStore(credPath, true)
            ).Result;

我把这句话删掉了，一切都好了！