google-sheets-etl
google-sheets-etl copied to clipboard
Catch error
diff --git a/src/Tasks.php b/src/Tasks.php
index 667eb5a..6bdb3b6 100644
--- a/src/Tasks.php
+++ b/src/Tasks.php
@@ -74,7 +74,15 @@ class Tasks
echo 'No spreadsheets ever seen' . PHP_EOL;
return true;
}
- $spreadsheet = $this->googleSheetsAgent->getSpreadsheet($oldestSeen);
+ try {
+ $spreadsheet = $this->googleSheetsAgent->getSpreadsheet($oldestSeen);
+ } catch (\Exception $e) {
+ // Is this a "File not found" error?
+ if (strpos($e->getMessage(), 'File not found') !== false) {
+ echo 'Oldest spreadsheet not accessible: ' . $oldestSeen . PHP_EOL;
+ return false;
+ }
+ }
if (is_null($spreadsheet)) {
echo "Oldest spreadsheet $oldestSeen is no longer accessible" . PHP_EOL;
return false;
(END)