java - Google sheet API(使用 java)显示“消息”:“请求的身份验证范围不足。”,“状态”:“PERMISSION_DENIED”
问题描述
我正在使用 google sheet API 在驱动器上编辑我的 google sheet。链接共享已开启。但这显示以下错误:
线程“主”com.google.api.client.googleapis.json.GoogleJsonResponseException 中的异常:403 Forbidden {“code”:403,“errors”:[{“domain”:“global”,“message”:“请求有身份验证范围不足。”,“原因”:“禁止”}],“消息”:“请求的身份验证范围不足。”,“状态”:“PERMISSION_DENIED”}
我的代码如下:
import com.google.api.client.auth.oauth2.Credential;
import com.google.api.client.extensions.java6.auth.oauth2.AuthorizationCodeInstalledApp;
import com.google.api.client.extensions.jetty.auth.oauth2.LocalServerReceiver;
import com.google.api.client.googleapis.auth.oauth2.GoogleAuthorizationCodeFlow;
import com.google.api.client.googleapis.auth.oauth2.GoogleClientSecrets;
import com.google.api.client.googleapis.javanet.GoogleNetHttpTransport;
import com.google.api.client.http.javanet.NetHttpTransport;
import com.google.api.client.json.JsonFactory;
import com.google.api.client.json.jackson2.JacksonFactory;
import com.google.api.client.util.store.FileDataStoreFactory;
import com.google.api.services.sheets.v4.Sheets;
import com.google.api.services.sheets.v4.SheetsScopes;
import com.google.api.services.sheets.v4.model.AppendValuesResponse;
import com.google.api.services.sheets.v4.model.UpdateValuesResponse;
import com.google.api.services.sheets.v4.model.ValueRange;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.security.GeneralSecurityException;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;
public class SheetsQuickstart {
private static final String APPLICATION_NAME = "Google Sheets API Java Quickstart";
private static final JsonFactory JSON_FACTORY = JacksonFactory.getDefaultInstance();
private static final String TOKENS_DIRECTORY_PATH = "tokens";
/*
* Global instance of the scopes required by this quickstart.
* If modifying these scopes, delete your previously saved tokens/ folder.
*/
private static final List<String> SCOPES = Collections.singletonList(SheetsScopes.SPREADSHEETS);
private static final String CREDENTIALS_FILE_PATH = "/credentials.json";
/**
* Creates an authorized Credential object.
* @param HTTP_TRANSPORT The network HTTP Transport.
* @return An authorized Credential object.
* @throws IOException If the credentials.json file cannot be found.
*/
private static Credential getCredentials(final NetHttpTransport HTTP_TRANSPORT) throws IOException {
// Load client secrets.
InputStream in = SheetsQuickstart.class.getResourceAsStream(CREDENTIALS_FILE_PATH);
if (in == null) {
throw new FileNotFoundException("Resource not found: " + CREDENTIALS_FILE_PATH);
}
GoogleClientSecrets clientSecrets = GoogleClientSecrets.load(JSON_FACTORY, new InputStreamReader(in));
// Build flow and trigger user authorization request.
GoogleAuthorizationCodeFlow flow = new GoogleAuthorizationCodeFlow.Builder(
HTTP_TRANSPORT, JSON_FACTORY, clientSecrets, SCOPES)
.setDataStoreFactory(new FileDataStoreFactory(new java.io.File(TOKENS_DIRECTORY_PATH)))
.setAccessType("offline")
.build();
LocalServerReceiver receiver = new LocalServerReceiver.Builder().setPort(8888).build();
return new AuthorizationCodeInstalledApp(flow, receiver).authorize("user");
}
/*
* Prints the names and majors of students in a sample spreadsheet:
* https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
*/
public static void main(String... args) throws IOException, GeneralSecurityException {
// Build a new authorized API client service.
final NetHttpTransport HTTP_TRANSPORT = GoogleNetHttpTransport.newTrustedTransport();
final String spreadsheetId = "1KQy633356786cc22i0sCYFoD4h333oTl2Lk";//
final String range = "Sheet_name!A2:B"; //I am intentionally not showing the name and also the link
Sheets service = new Sheets.Builder(HTTP_TRANSPORT, JSON_FACTORY, getCredentials(HTTP_TRANSPORT))
.setApplicationName(APPLICATION_NAME)
.build();
ValueRange response = service.spreadsheets().values().get(spreadsheetId, range).execute();
List<List<Object>> values = Arrays.asList(
Arrays.asList("Franklin",6897877));
ValueRange body = new ValueRange()
.setValues(values);
AppendValuesResponse result =
service.spreadsheets().values().append(spreadsheetId, range, body)
.setValueInputOption("USER_ENTERED").setInsertDataOption("INSERT_ROWS").setIncludeValuesInResponse(true)
.execute();
System.out.printf("%d cells appended.", result.getUpdates().getUpdatedCells());
List<List<Object>> value = response.getValues();
if (values == null || values.isEmpty()) {
System.out.println("No data found.");
} else {
System.out.println("Name, ID");
for (List row : value) {
System.out.printf("%s, %s\n", row.get(0), row.get(1));
}
}
}
}
解决方案
当您使用 Sheets API Quickstart中的代码时,我猜您首先生成了一个令牌来读取电子表格,它只需要SheetsScopes.SPREADSHEETS_READONLY
令牌并执行示例。
为了更新范围,您需要删除保存在 中的令牌文件TOKENS_DIRECTORY_PATH
,再次执行代码并登录。然后 Oauth2 将为您提供新的更新令牌。
推荐阅读
- c# - SixLabors/ImageSharp 分解了一些 jpeg
- kubernetes - config.lock 上的 Kubernetes 权限被拒绝错误
- javascript - 如何为`设置静态SVG大小
` 下的元素 - annotations - 定义openapi/swagger注解的常用参数
- python - 实体 - DialogFlow 中的文本到编号
- formatting - 将字符串中的所有数值相乘时格式化十进制输出?
- javascript - ng-option 在第一次调用时不选择模型值
- sapui5 - 如何从外部访问组件模型
- ruby - Slim:方法调用中的注释语法
- scsi - 物理驱动器上 SCSI 读取 (10) 的最大传输大小