我使用Python Simple Salesforce通过SOQL查询数据。我知道SOQL语法不支持“SELECT*”,所以我想创建一个Python脚本来收集要插入SELECT语句的所有字段的字符串列表。下面是我对Account对象的描述:
from simple_salesforce import Salesforce
from simple_salesforce import SFType
#(credentials hidden)
sf = Salesforce(username=username, password=password,
security_token=security_token, sandbox=True,
client_id='mwheeler App')
desc = sf.Account.describe()
print(desc)
如何从下面显示的有序字典中将字段名提取到字符串列表中?
说明:
OrderedDict([('actionOverrides',[]),('Activateble',False),('childRelationships',[OrderedDict([('cascadeDelete',False),('childSObject','Account'),('DeprecatedHidden',False),('field','ParentId'),('junctionIdListNames',[]),('junctionReferenceTo',[]),('relationshipName','ChildAccounts'),('restrictedDelete',False]),OrderedDict([('cascadeDelete',True),('childSObject','AccountCleanInfo'),('deprecatedAndHidden',False),('field','AccountId')。。。。。。
我将使用字符串列表选择所有字段:
query = sf.query_all("SELECT string_list FROM Account")
目前没有回答
相关问题 更多 >
编程相关推荐