Python 3简单的Salesforce测试，用于查看对象是否存在以及是否包含数据

import requests

# Salesforce登录信息
username = 'your_username'
password = 'your_password'
security_token = 'your_security_token'

# Salesforce对象信息
object_name = 'Account'

# 构建API请求URL
base_url = 'https://your_salesforce_instance.salesforce.com'
api_url = f'{base_url}/services/data/v52.0/sobjects/{object_name}/describe'
headers = {
    'Authorization': f'Bearer {access_token}',
    'Content-Type': 'application/json'
}

# 发送API请求
response = requests.get(api_url, headers=headers)

# 解析API响应
if response.status_code == 200:
    object_info = response.json()
    if 'errorCode' in object_info:
        print(f"对象'{object_name}'不存在")
    else:
        print(f"对象'{object_name}'存在")
        if object_info['queryable']:
            # 查询对象数据
            query_url = f'{base_url}/services/data/v52.0/query?q=SELECT+Id+FROM+{object_name}+LIMIT+1'
            query_response = requests.get(query_url, headers=headers)
            query_result = query_response.json()
            if 'errorCode' in query_result:
                print(f"对象'{object_name}'不包含数据")
            else:
                print(f"对象'{object_name}'包含数据")
        else:
            print(f"对象'{object_name}'不可查询")
else:
    print(f"API请求失败：{response.text}")