Python Simple Salesforce选择所有字段

2024-06-01 13:30:25 发布

您现在位置:Python中文网/ 问答频道 /正文

我使用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")

Tags: 字符串fromimportfalse列表usernameaccountpassword