我正在尝试将Salesforce数据加载到Python dataframe中,以便我们可以在那里进行所有操作。 simple_salesforce适用,但有一个限制是我们达到了2,000个限制:
据说,salesforce-bulk(https://pypi.python.org/pypi/salesforce-bulk/1.0.7)可以绕过这个限制,但我无法进一步操作:
from simple_salesforce import Salesforce as s
eatpies = sf.query('Select Id from Case')
attrs = ['Id']
records = eatpies['records']
data = {}
for rec in records:
for k in attrs:
data.setdefault(k, []).append(rec[k])
dframe = pd.DataFrame(data)
print(dframe)
据说,salesforce-bulk(https://pypi.python.org/pypi/salesforce-bulk/1.0.7)可以绕过这个限制,但我无法进一步操作:
job = bulk.create_query_job("Case", contentType='CSV')
batch = bulk.query('select Id, type from Case')
TypeError Traceback (most recent call last)
<ipython-input-13-076e14bf245d> in <module>()
----> 1 batch = bulk.query('select Id, type from Case')
TypeError: query() missing 1 required positional argument: 'soql'
请帮忙,谢谢!如果可以用Simple-Salesforce解决Salesforce的限制问题,那就太好了,但我在Google上找不到任何解决方案。