def searchContacts(search_string): sf = Salesforce(**settings.SF_AUTH) response = sf.search('''find {{{}}} in name fields returning contact({} where s360a__ContactCodes__c = 'Active Donor') limit 100 '''.format(search_string, comma_params)) return response['searchRecords']
from simple_salesforce import Salesforce import json sf = Salesforce(username='******', password='******', security_token='98U9HLBLiZuJ8iA4epRq0bQk') # sf.Contact.create({'LastName':'LongLegger','FirstName': 'Daddy','Email':'*****@*****.**'}) row0 = sf.query("SELECT Id, Email FROM Contact WHERE LastName = 'LongLegger'") print row0 print '\n' row1 = sf.query_all( "SELECT Id, FirstName,LastName, Email FROM Contact WHERE LastName ='LongLegger'" ) print row1 print '\n' row2 = sf.search("FIND {LongLegger}") print row2 print "Accounts" row3 = sf.query("SELECT Id, type FROM Account") cleanup = json.dumps(row3) print cleanup
from simple_salesforce import Salesforce import requests, pprint, json sf = Salesforce(instance='na34.salesforce.com',session_id='00D610000007TqI!AQ8AQPo0Ivk7phzkXCozLtdN7VpVozn_NT0omPmwghsRmqeyrbd.2bh5W1CIiCnagNQxrPayol4MXk6jnOTEwoHL.aRnnciR') #print (json.dumps(sf.Account.metadata(),indent=4)) print('*******************') res = (json.dumps(sf.search("FIND {Jones}"),indent=4)) for x in res["type"]: print rest[0] ''' for x in sf.Account.metadata()["Attributes"]: print x["label"] print ("Hello World") res = sf.search("FIND {Jones}") print (res) print ("************") for x in sf.describe()["sobjects"]: print x["label"] '''
# -*- coding: utf-8 -*- """ Created on Fri Nov 10 11:06:38 2017 @author: Chris.Cirelli """ from simple_salesforce import Salesforce Username_chris = '*****@*****.**' Password_chris = 'Work4starr!' Token_chris = 'TvzoSyEjnGTMPYQsBfWXKH6Z' sf = Salesforce(username=Username_chris, password=Password_chris, security_token=Token_chris) sf.search("FIND (Murphy)")