Update app.py

app.py

@@ -67,6 +67,9 @@ def fetch_vendor_logs_from_salesforce():
         result = sf.query_all(query)
         logs = []
         for record in result['records']:
+            if not record['Vendor__c']:
+                logger.warning(f"Skipping Vendor_Log__c record {record['Id']} with null Vendor__c")
+                continue
             # Format dates and handle potential future dates
             work_completion_date = record['Work_Completion_Date__c'] or "N/A"
             actual_completion_date = record['Actual_Completion_Date__c'] or "N/A"