simple-salesforce

import os from simple_salesforce import Salesforce # It's highly recommended to use environment variables for credentials USERNAME = os.environ.get('SF_USERNAME', 'your_username@example.com') PASSWORD = os.environ.get('SF_PASSWORD', 'your_password') SECURITY_TOKEN = os.environ.get('SF_SECURITY_TOKEN', 'your_security_token') # Optional: for sandbox use domain='test' # For specific API versions, use sf_version='X.Y' try: sf = Salesforce( username=USERNAME, password=PASSWORD, security_token=SECURITY_TOKEN, # domain='test' # Uncomment for sandbox # sf_version='59.0' # Uncomment for a specific API version ) print(f"Successfully connected to Salesforce instance: {sf.instance_url}") # Example: Query Account records query_result = sf.query("SELECT Id, Name FROM Account LIMIT 5") print("\nFirst 5 Account Names:") for record in query_result['records']: print(f" - {record['Name']} (Id: {record['Id']})") # Example: Create a new Account (replace with unique name for testing) new_account_name = "Test Account from simple-salesforce_" + str(os.urandom(4).hex()) new_account = {'Name': new_account_name} create_result = sf.Account.create(new_account) print(f"\nCreated Account: {new_account_name} with Id: {create_result['id']}") # Example: Delete the created Account (cleanup) delete_result = sf.Account.delete(create_result['id']) print(f"Deleted Account with Id: {create_result['id']}") except Exception as e: print(f"An error occurred: {e}") print("Please ensure your SF_USERNAME, SF_PASSWORD, and SF_SECURITY_TOKEN environment variables are set correctly.")