Google Sheet UpdateValuesResponse()

0
votes

I update values in Google Sheet modifyed this quiqstartfile: https://developers.google.com/sheets/api/quickstart/php After update i need response from google api that all is OK (it has not error). How to test that update success? How to make it? I tried:

$result = $service->spreadsheets_values->update($spreadsheetId, $range, $body, $params);
$test=$result->UpdateValuesResponse();
printf($test);

And have error:

PHP Fatal error: Uncaught Error: Call to undefined method Google_Service_Sheets_UpdateValuesResponse::UpdateValuesResponse() in /var/www/html/writegs.php:101 Stack trace: > #0 {main} thrown in /var/www/html/writegs.php on line 101

1
phpgoogle-sheets-api

1 Answers

0
votes

Check the documentation here: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update

According to the PHP example given there, the response you get back from the update is an UpdateValuesResponse object. That's not a method.

So if you're just wanting to test you got a successful response, try:

$result = $service->spreadsheets_values->update($spreadsheetId, $range, $body, $params);
echo '<pre>', var_export($result , true), '</pre>', "\n";

$result = json_decode($result);

$updatedCells = $result->updatedCells;