如何调试“;呼叫者没有权限”;
本文关键字:呼叫者 权限 何调试 调试 | 更新日期: 2023-09-27 17:58:25
我使用的是Google Sheets API v4。
我已经用一些表进行了测试,我的代码可以工作,但用一些表就不行了。我所做的只是换掉纸张ID。
我使用这里找到的代码:
https://developers.google.com/sheets/quickstart/dotnet
我测试的所有表格都可以在浏览器中阅读和编辑。我面临的错误是:
Google.Apis.Requests.RequestError'r'nThe caller does not have permission [403]'r'nErrors ['r'n'tMessage[The caller does not have permission] Location[ - ] Reason[forbidden] Domain[global]'r'n]'r'n
调试此类问题的步骤是什么?
以下是完整的源代码:
public class Google_Sheets
{
// If modifying these scopes, delete your previously saved credentials
// at ~/.credentials/sheets.googleapis.com-dotnet-quickstart.json
static string[] Scopes = { SheetsService.Scope.SpreadsheetsReadonly };
static string ApplicationName = "Google Sheets API Quickstart";
public static void Test()
{
UserCredential credential;
using (var stream =
new FileStream("Google Drive''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;
Console.WriteLine("Credential file saved to: " + credPath);
}
// Create Google Sheets API service.
var service = new SheetsService(new BaseClientService.Initializer()
{
HttpClientInitializer = credential,
ApplicationName = ApplicationName,
});
// Define request parameters.
// https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
// working
//String spreadsheetId = "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms";
//String range = "Class Data!A2:E";
// not working
String spreadsheetId = "1KJtvpd8iROI7cZ-7--fyoTXTLjzdb8ZghmmQOWkKsh4";
String range = "Sheet1!A1:G";
SpreadsheetsResource.ValuesResource.GetRequest request =
service.Spreadsheets.Values.Get(spreadsheetId, range);
// Prints the names and majors of students in a sample spreadsheet:
// https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
ValueRange response = request.Execute();
IList<IList<Object>> values = response.Values;
if (values != null && values.Count > 0)
{
Console.WriteLine("Name, Major");
foreach (var row in values)
{
Console.WriteLine("{0}, {1}", row[0], row[1]);
}
}
else
{
Console.WriteLine("No data found.");
}
Console.Read();
}
}
原来我的问题是登录了两个不同的谷歌帐户。我想我的工具然后向错误的谷歌账户索要代币。
为了解决这个问题,我做了:
- 注销所有帐户
- 删除在"My Documents.credentials''sheets.googleapis.com dotnet quickstart.json''"中创建的令牌文件
- 登录正确的谷歌帐户
- 重新启动应用程序
- 浏览器窗口现在应该打开并请求访问Google Sheets的权限
没有经过测试,但我认为当所有谷歌账户都可以访问有问题的表格时,我不会有任何问题。