google-sheets-etl icon indicating copy to clipboard operation
google-sheets-etl copied to clipboard

Catch error

Open fulldecent opened this issue 1 year ago • 0 comments

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)

fulldecent avatar Feb 19 '24 20:02 fulldecent