如何使用PHP调用Google Classroom API获取作业、测验分数
问题原因及解决方案
你遇到的403权限不足错误由两类核心原因导致:授权范围(Scope)未覆盖成绩读取权限、本地缓存的旧令牌未更新。
具体解决步骤
- 补充缺失的授权Scope
要读取作业/测验的评分数据,你需要额外添加成绩读取权限,修改代码中setScopes部分如下:
- 补充缺失的授权Scope
$client->setScopes(array( Google_Service_Classroom::CLASSROOM_COURSES, Google_Service_Classroom::CLASSROOM_STUDENT_SUBMISSIONS_STUDENTS_READONLY, // 新增成绩读取权限 Google_Service_Classroom::CLASSROOM_GRADES_READONLY, Google_Service_Classroom::CLASSROOM_ROSTERS ));
如果你的账号是班级教师,需要查看所有学生提交,建议额外添加Google_Service_Classroom::CLASSROOM_STUDENT_SUBMISSIONS_COURSEWORK_READONLYScope,覆盖教师端的全部提交读取权限。
- 删除本地旧授权令牌
删除你项目目录下的token.json文件,之前的令牌已经绑定了旧的权限范围,修改Scope后必须重新走授权流程,生成带新权限的令牌。
- 删除本地旧授权令牌
- 校验Google Cloud控制台配置
- 确认你的Google Cloud项目已启用Google Classroom API
- 确认OAuth同意屏幕中已添加上述所有需要的Scope,未发布的应用需要将你用来授权的Google账号添加到测试用户列表中
- 校验账号权限
你用来授权登录的Google账号,必须是对应Classroom班级的教师/管理员,学生账号仅能读取本人的提交及分数,无法获取全班数据。
- 校验账号权限
Laravel框架适配建议
你可以直接将上述逻辑封装为Laravel服务类:
- 执行
composer require google/apiclient:^2.0安装依赖 - 将credentials.json放在storage/app目录下,令牌存在storage/framework/cache或者数据库中,避免本地文件读写权限问题
- 封装服务类示例:
<?php namespace App\Services; use Google_Client; use Google_Service_Classroom; class GoogleClassroomService { protected $client; protected $service; public function __construct() { $this->client = new Google_Client(); $this->client->setApplicationName(config('app.name')); $this->client->setScopes([ Google_Service_Classroom::CLASSROOM_COURSES, Google_Service_Classroom::CLASSROOM_STUDENT_SUBMISSIONS_COURSEWORK_READONLY, Google_Service_Classroom::CLASSROOM_GRADES_READONLY, Google_Service_Classroom::CLASSROOM_ROSTERS ]); $this->client->setAuthConfig(storage_path('app/credentials.json')); $this->client->setAccessType('offline'); $this->client->setPrompt('select_account consent'); // 从缓存读取令牌 $accessToken = cache()->get('google_classroom_token'); if ($accessToken) { $this->client->setAccessToken($accessToken); } if ($this->client->isAccessTokenExpired()) { if ($this->client->getRefreshToken()) { $newToken = $this->client->fetchAccessTokenWithRefreshToken($this->client->getRefreshToken()); cache()->put('google_classroom_token', $newToken, now()->addDays(6)); } } $this->service = new Google_Service_Classroom($this->client); } // 获取指定作业的所有学生分数 public function getCourseWorkScores(string $courseId, string $courseWorkId) { $submissions = $this->service->courses_courseWork_studentSubmissions ->listCoursesCourseWorkStudentSubmissions($courseId, $courseWorkId) ->studentSubmissions; $scores = []; foreach ($submissions as $submission) { $student = $this->service->courses_students->get($courseId, $submission->userId); $scores[] = [ 'student_name' => $student->profile->name->fullName, 'assigned_grade' => $submission->assignedGrade, 'max_grade' => $submission->maxPoints ]; } return $scores; } }
验证测试
完成上述修改后重新运行quickstart.php,按照提示重新授权,即可正常获取作业/测验分数。
内容的提问来源于stack exchange,提问作者Mahmud Hosen
相关产品推荐
相关产品推荐

