Is there a library or package which we can use with python to connect to salesforce and get data?
There's also a package called simple_salesforce .
You can install it with:
$ pip install simple_salesforce
You can gain access to your Salesforce account with the following:
from simple_salesforce import Salesforce
sf = Salesforce(username='[email protected]', password='password', security_token='token')
The readme is helpful with regards to details...
I use beatbox
Example to query for a lead by email address
import beatbox
sf_username = "Username"
sf_password = "password"
sf_api_token = "api token"
def get_lead_records_by_email(email)
sf_client = beatbox.PythonClient()
password = str("%s%s" % (sf_password, sf_api_token))
sf_client.login(sf_username, password)
lead_qry = "SELECT id, Email, FirstName, LastName, OwnerId FROM Lead WHERE Email = '%s'" % (email)
records = sf_client.query(lead_qry)
return records
To get other data look at the salesforce api docs
view other beatbox examples here
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With