I’ve recently run into a problem trying to connect to the salesforce API using python simple-salesforce and requests library to download some data for some PowerBI and analytics applications / forecasting / machine learning apps.

I’m on python 3.10.4 on Windows 10 and have the latest updated to latest published version of requests and simple-salesforce.

The error I’m getting is SSL failed self certify. The bit that’s throwing me off is I have another pipeline in golang that is working fine on the same machine. I’ve been able to implement a workaround by setting the verify=False on the session and passing this through to requests. I’m also able to get a response from the server using the lower level urllib3 to make to same request which is working fine.

I’ve also SSH’d into a separate machine and have been able to connect successfully. I’m unsure what my next course of action is. While my longer term plan is to migrate most of the extracts to golang as the distribution is simpler, python is a lot easier to work with in the exploratory stage, especially when I’m looking to run things locally rather than on a remote server.