def bulk(self):
if self._bulk is None:
self._bulk = salesforce_bulk.SalesforceBulk(
sessionId=self.connection.session_id,
host=urlparse(self.connection.bulk_url).hostname)
return self._bulk
def __init__(self, sf):
self._sf = sf
self._bulk = salesforce_bulk.SalesforceBulk(
sessionId=self._sf.session_id,
host=urlparse(self._sf.bulk_url).hostname,
API_version=constants.API_VERSION,
)
def SF_Dataframe(query_list, object_list):
bulk = sf.SalesforceBulk(username=username,
password=password,
security_token=security_token)
def Run_SF_Query(query, object_name):
job_id = bulk.create_query_job(object_name=object_name)
batch_id = bulk.query(job_id=job_id, soql=query)
bulk.close_job(job_id)
while not bulk.is_batch_done(batch_id):
sleep(1)
results = bulk.get_all_results_for_query_batch(batch_id)
for result in results:
df = pd.read_csv(result)
break
return df
dfs = []
for query, obj in zip(query_list, object_list):
df = Run_SF_Query(query, obj)
df.drop_duplicates(inplace=True)
dfs.append(df)
return dfs
def __init__(self, sf, api_version):
self._sf = sf
self._bulk = salesforce_bulk.SalesforceBulk(
sessionId=self._sf.session_id,
host=urlparse(self._sf.bulk_url).hostname,
API_version=api_version,
)
self._describe_info = {}
self._field_maps = {}
self._key_prefix_map = None
def SF_Dataframe(self, query_list, object_list):
print('Establishing Connection to Salesforce')
try:
bulk = sf.SalesforceBulk(username=self.username,
password=self.password,
security_token=self.security_token)
except:
bulk = sf.SalesforceBulk(username=self.username,
password=self.password,
security_token=self.security_token)
print('Connection Established')
def Run_SF_Query(query, object_name):
job_id = bulk.create_query_job(object_name=object_name)
batch_id = bulk.query(job_id=job_id, soql=query)
bulk.close_job(job_id)
while not bulk.is_batch_done(batch_id):
sleep(1)
results = bulk.get_all_results_for_query_batch(batch_id)
for result in results:
df = pd.read_csv(result)
break
return df
dfs = []
for query, obj in zip(query_list, object_list):
df = Run_SF_Query(query, obj)
print('-------------------------------------------')
print('%s object has been queried.' % obj)
print('-------------------------------------------')
print()
df.drop_duplicates(inplace=True)
dfs.append(df)
return dfs