I have recently joined as Data Analyst in a good MNC. My company uses Salesforce as their CRM, whenever I'm working with data it is hard for me to download and upload. I use python for my research and visualization. I found this code online but I'm getting data_failed_server
pip install simple_salesforce
from simple_salesforce import Salesforce
sf = Salesforce(
username='myemail@example.com',
password='password',
security_token='token')
"SELECT Owner.Name, store_id__c, account_number__c, username__c, password__c, program_status__c, FROM Account WHERE program_status__c IN ('Live','Test')"
sf_data = sf.query_all("SELECT Owner.Name, store_id__c, account_number__c, username__c, password__c, program_status__c, FROM Account WHERE program_status__c IN ('Live','Test')")
sf_df = pd.DataFrame(sf_data['records']).drop(columns='attributes
just finished training from-
https://bit.ly/3p3BwFrHi Sansa
You can go through the following links:-
https://towardsdatascience.com/using-python-to-get-salesforce-data-97bb5a7ef2cf
https://www.codementor.io/@anananet/how-i-use-python-to-get-salesforce-data-12f9ul7i8g
Hope this will resolve your query.
Thank you
Piyush
