def delete_salesforce_object(self, object_type: str, object_id: str) -> bool:
"""Delete Salesfoce object by type and id.
:param object_type: Salesforce object type
:param object_id: Salesforce object id
:return: True if successful
"""
self._require_authentication()
salesforce_object = SFType(object_type, self.session_id, self.instance)
result_code = salesforce_object.delete(object_id)
return result_code == 204
def unregister(push_topic_id,access_token,instance,version=None):
defaults = PushTopic._default_topic_properties()
version = version or defaults['ApiVersion']
object_name = 'PushTopic'
instance = instance.replace('https://','').replace('http://','')
sf_object = SFType(object_name=object_name,
session_id=access_token,
sf_instance=instance,
sf_version=version)
return sf_object.delete(record_id=push_topic_id)
"""
# Import Dependencies
from simple_salesforce import Salesforce, SFType, SalesforceLogin
from pandas import DataFrame, read_csv
import json
from pprint import pprint as pp
login = json.load(open('login.json'))
username = login['username']
password = login['password']
token = login['token']
session_id, instance = SalesforceLogin(username=username,
password=password,
security_token=token)
sOpportunity = SFType(object_name='opportunity',
session_id=session_id,
sf_instance=instance)
data = dict(Name='Test Opportunity MG',
StageName='Prospecting',
CloseDate='2020-07-15',
Amount='10000.00',
Type='New Customer')
rec = sOpportunity.update(record_id='0063h000007nGmIAAU', data=data)
rec = sOpportunity.delete(record_id='0063h000007nGmIAAU')
print(rec)
print('-'.center(20, '-'))
print('Conatct ID: {0}'.format(accountID))
print('Project ID: {0}'.format(contactID))
"""
Update the existing records
"""
update_data = {}
update_data['AccountNumber'] = 1293012931
update_data['CustomerPriority__c'] = 'Medium'
accounts__c.update(response.get('id'), update_data)
"""
Delete Records
"""
account.delete('0xxxxxxxxxxxxx') # xxxxx is id
"""
Upsert records inserting new fields in the exiting records without using account id and using existing field names
"""
update_data['Name'] = 'Account_Fightclub'
externalid = 'AnnualRevenue/{0}'.format(10000)
update_data['AccountNumber'] = update_data['AccountNumber'] + 20000000
response = accounts__c.upsert(data=update_data)
"""
Using Bulk API to create records in Salesforce
"""
## Bulk query can be used for retreving vast records such as 50000
output = sf2.bulk.Account.query("SELECT Id, Name from Account LIMIT 5")
pd.DataFrame(output)
## Loading csv into salesforce object
