方法不使用类中的SFType

2024-09-28 20:55:30 发布

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

我有一个小类,可以帮助我提取salesforceobject数据帧和列。我对simple_salesforce软件包中的SFType有问题。我试图从某个salesforce对象的dataframe中检索列标题。以下是我的课程片段:

from simple_salesforce import Salesforce
from simple_salesforce import SFType
import pandas as pd
import numpy as np

class SfData:
    def __init__(self,user,pw,token,obj):
        self.user = user
        self.pw = pw
        self.token = token
        self.sf = Salesforce(username = self.user,password = self.pw, security_token=self.token)
        self.obj = obj

    def retrieve_columns(self):
        df = SFType(self.obj, self.sf.session_id, self.sf.sf_instance)
        col_names = [x['name'] for x in self.sf.df.describe()['fields']]
        return col_names

调用该类后,调用该方法时出现以下错误:

test.SfData(myuser,mypw,mytoken,"Account")
test.retrieve_columns()

Resource df Not Found. Response content: [{'errorCode': 'NOT_FOUND', 'message': 'The requested resource does not exist'}]

Tags: fromimportselftokenobjdfassf
1条回答
网友
1楼 · 发布于 2024-09-28 20:55:30

我不需要使用我的凭据来调用方法“descripe”,而是:

df = SFType(self.obj, self.sf.session_id, self.sf.sf_instance)
data = df.describe()
columns = [x['name'] for x in data['fields']]
return columns

相关问题 更多 >