Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once __DIR__ . '/vendor/autoload.php';
- define('APPLICATION_NAME', 'Google Sheets API PHP Quickstart');
- define('CREDENTIALS_PATH', '~/.credentials/sheets.googleapis.com-php-quickstart.json');
- define('CLIENT_SECRET_PATH', __DIR__ . '/client_secret.json');
- // If modifying these scopes, delete your previously saved credentials
- // at ~/.credentials/sheets.googleapis.com-php-quickstart.json
- define('SCOPES', implode(' ', array(
- Google_Service_Sheets::SPREADSHEETS_READONLY)
- ));
- if (php_sapi_name() != 'cli') {
- throw new Exception('This application must be run on the command line.');
- }
- /**
- * Returns an authorized API client.
- * @return Google_Client the authorized client object
- */
- function getClient() {
- $client = new Google_Client();
- $client->setApplicationName(APPLICATION_NAME);
- $client->setScopes(SCOPES);
- $client->setAuthConfig(CLIENT_SECRET_PATH);
- $client->setAccessType('offline');
- // Load previously authorized credentials from a file.
- $credentialsPath = expandHomeDirectory(CREDENTIALS_PATH);
- if (file_exists($credentialsPath)) {
- $accessToken = json_decode(file_get_contents($credentialsPath), true);
- } else {
- // Request authorization from the user.
- $authUrl = $client->createAuthUrl();
- printf("Open the following link in your browser:n%sn", $authUrl);
- print 'Enter verification code: ';
- $authCode = trim(fgets(STDIN));
- // Exchange authorization code for an access token.
- $accessToken = $client->fetchAccessTokenWithAuthCode($authCode);
- // Store the credentials to disk.
- if(!file_exists(dirname($credentialsPath))) {
- mkdir(dirname($credentialsPath), 0700, true);
- }
- file_put_contents($credentialsPath, json_encode($accessToken));
- printf("Credentials saved to %sn", $credentialsPath);
- }
- $client->setAccessToken($accessToken);
- // Refresh the token if it's expired.
- if ($client->isAccessTokenExpired()) {
- $client->fetchAccessTokenWithRefreshToken($client->getRefreshToken());
- file_put_contents($credentialsPath, json_encode($client->getAccessToken()));
- }
- return $client;
- }
- /**
- * Expands the home directory alias '~' to the full path.
- * @param string $path the path to expand.
- * @return string the expanded path.
- */
- function expandHomeDirectory($path) {
- $homeDirectory = getenv('HOME');
- if (empty($homeDirectory)) {
- $homeDirectory = getenv('HOMEDRIVE') . getenv('HOMEPATH');
- }
- return str_replace('~', realpath($homeDirectory), $path);
- }
- // Get the API client and construct the service object.
- $client = getClient();
- $service = new Google_Service_Sheets($client);
- // Prints the names and majors of students in a sample spreadsheet:
- $spreadsheetId = 'myfileid';
- $range = 'Class Data!A2';
- $response = $service->spreadsheets_values->get($spreadsheetId, $range);
- $values = $response->getValues();
- if (count($values) == 0) {
- print "No data found.n";
- } else {
- print "Name, Major:n";
- foreach ($values as $row) {
- // Print columns A and E, which correspond to indices 0 and 4.
- printf("%s, %sn", $row[0], $row[4]);
- }
- }
- $values = array(
- array(
- 5
- ),
- // Additional rows ...
- );
- $body = new Google_Service_Sheets_ValueRange(array(
- 'values' => $values
- ));
- $params = array(
- 'valueInputOption' => $valueInputOption
- );
- $result = $service->spreadsheets_values->update($spreadsheetId, $range,
- $body, $params);
- Uncaught exception 'Google_Service_Exception' with message '{
- "error": {
- "code": 403,
- "message": "Request had insufficient authentication scopes.",
- "errors": [
- {
- "message": "Request had insufficient authentication scopes.",
- "domain": "global",
- "reason": "forbidden"
- }
- ],
- "status": "PERMISSION_DENIED"
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement