使用 Google Spreadsheet api 和 php 更新电子表格数据突然无法正常工作并出现身份验证错误

Question

采用接受输入并更新电子表格中的值的形式。之前工作正常，但突然停止工作并出现此错误消息：

Fatal error: Uncaught exception 'Google_Service_Exception' with message '{ "error": { "code": 403, "message": "The caller does not have permission", "errors": [ { "message": "The caller does not have permission", "domain": "global", "reason": "forbidden" } ], "status": "PERMISSION_DENIED" } } ' in /google-api-php-client-2.2.2/src/Google/Http/REST.php:118 
Stack trace: 
#0 /google-api-php-client-2.2.2/src/Google/Http/REST.php(94): Google_Http_REST::decodeHttpResponse(Object(GuzzleHttp\Psr7\Response), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...') 
#1 [internal function]: Google_Http_REST::doExecute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...') 
#2 /google-api-php-client-2.2.2/src/Google/Task/Runner.php(176): call_user_func_array(Array, Array) 
#3 /google-api-php-client-2.2.2/src/Google/Http/REST.php(58): Google_Task_Runner->run() 
#4 /html/form in /google-api-php-client-2.2.2/src/Google/Http/REST.php on line 118

根据其他问题和答案，这是因为身份验证问题，但该表单在相同的身份验证下工作了 5 年，因此令人困惑。还有其他原因导致表格未更新吗？

这是包含的代码

<?php

ini_set("display_errors", 1);
ini_set("display_startup_errors", 1);
error_reporting(E_ALL);

date_default_timezone_set("US/Central");
// Autoload Composer.

if (file_exists(__DIR__ . "/google-api-php-client-2.2.2/vendor/autoload.php")) {
    require_once __DIR__ . "/google-api-php-client-2.2.2/vendor/autoload.php";

    $spreadsheetId = "********"; // TODO: Update placeholder value.

    // The A1 notation of a range to search for a logical table of data.
    // Values will be appended after the last row of the table.
    $range = "A2"; // TODO: Update placeholder value.

    // TODO: Assign values to desired properties of `requestBody`:
    $values = [
        [
            date("Y-m-d H:i:s"),
            $_POST["prop_type"],
            $_POST["pstreet"],
            $_POST["pcity"],
            $_POST["pzip"],
        ],
    ];

    $service_account_file = "service-account.json";
    $client = new Google_Client();

    $service = new Google_Service_Sheets($client);
    if ($client) {
        $client->setApplicationName("Google Sheet Update");
        $client->setAuthConfig($service_account_file);
        $client->setScopes(Google_Service_Sheets::SPREADSHEETS);

        $client->setAccessType("online");
        $redirect_uri =
        "http://" . $_SERVER["HTTP_HOST"] . $_SERVER["PHP_SELF"];

        $client->setRedirectUri($redirect_uri);

        $guzzle = new GuzzleHttp\Client([
            "verify" => false,
        ]);
        $client->setHttpClient($guzzle);

        $requestBody = new Google_Service_Sheets_ValueRange([
            "values" => $values,
            ]);

        $params = [
            "valueInputOption" => "RAW",
        ];

        $response = $service->spreadsheets_values->append(
            $spreadsheetId,
            $range,
            $requestBody,
            $params
        );
        //echo '<pre>', var_export($response, true), '</pre>', "\n";
    } else {
        echo "Not Valid Client";
        echo "<pre>CLIENT", var_dump($client), "</pre>", "\n";
    }
} else {
    echo "Client File do not exist";
}

?>

Answer 1

调用者没有权限

正是这个意思。您用于授权此代码的任何用户都无权访问该工作表。向具有访问权限的用户授权您的应用程序或授予该用户访问权限。

服务帐户需要预先授权。最常见的方法是获取服务帐户客户端 ID 并通过 Google Drive Web 应用程序与其共享文件。如果有人删除了对该文件的服务帐户访问权限。服务帐户将不再具有访问权限。

我会仔细检查它是否仍然可以访问。