I am facing issue when reading Google Sheets v4 in FME, below error occurred. Help you know how it gets rid of it.
DEBUG: urllib3.connectionpool Retrying (Retry(total=9, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)'))':
Question
Error while reading Google Sheets v4 in FME Form 2023.2
- Observer
+20- Safer
Hi *.googleapis.com traffic. I'd recommend checking with your IT about this, or testing from a different network (like home WiFi without VPN) to see if the issue persists!
Also, since the Google Sheets reader is a Python-based format, it’s possible that FME's Python environment still needs to trust the certificate chain. Typically, FME checks the OS certificate store first, but may still need the certificate added to FME's bundled cacert.pem
Here's an article on that for reference: SSL Certificate Handling for FME Transformers
If you’re still having trouble, feel free to open a case with us: Support Case 🙂