Use this tag for questions concerning simple-salesforce: A very simple Salesforce.com REST API client for Python.
Questions tagged [simple-salesforce]
147 questions
11
votes
3 answers
Python Simple Salesforce Select All Fields
I'm using Python Simple-Salesforce to query data via SOQL. I know that "SELECT *" is not supported in SOQL syntax, so I want to create a Python script to gather a string list of all fields to insert into the SELECT statement. Below is how I am…

mwhee
- 652
- 2
- 6
- 17
10
votes
2 answers
How to perform a JOIN in Salesforce (SOQL) - Simple Salesforce (Python Library)
I am using simpleSalesforce library for python to query SalesForce.
I am looking at two different object in SalesForce: Account and Opportunity (parent-child). There is an accountId inside the opportunity object.
I am trying to perform an inner join…

Dominik Sajovic
- 603
- 1
- 8
- 16
10
votes
8 answers
Python Simple Salesforce
I am trying to use simple_salesforce to query salesforce data with Python. I am using my username and password, which I am 100% sure is correct. I got the org ID from logging into Salesforce and looking at my company profile. It's only a 15-digit…

user2242044
- 8,803
- 25
- 97
- 164
6
votes
1 answer
How can one make Salesforce Bulk API calls via simple_salesforce?
I'm using the module simple-salesforce, and I'm not seeing anything in the docs about making bulk API calls. Anybody know how to do this?
https://github.com/simple-salesforce/simple-salesforce

flybonzai
- 3,763
- 11
- 38
- 72
5
votes
1 answer
Simple_Salesforce Dynamic bulk query
Dynamically add an object to the bulk query job for Simple_Salesforce.
I'm not sure how to pass a variable to sf.bulk."Object".query.
I would like to be able to pass an object say "Account" to the definition and it does the bulk query…

Bryan
- 77
- 1
- 8
5
votes
2 answers
Salesforce Data into Python (simple-Salesforce or salesforce-bulk)
I'm trying to load Salesforce data into a Python dataframe, so we can do all of our manipulations there. simple_salesforce worked with the caveat that we reached the 2,000 limit:
from simple_salesforce import Salesforce as s
eatpies =…

Marshall Gu
- 137
- 3
- 14
5
votes
2 answers
Upload multiple files using simple-salesforce python
I started learning SalesForce and developing apps using django.
I need assistance with uploading a file to salesforce, For that I read simple-salesforce and this that help to upload file using rest and SOAP api.
My question is how do I upload one or…

Jaymin Suthar
- 155
- 1
- 2
- 11
5
votes
1 answer
Accessing salesforce metadata using python simple-salesforce
When reading the simple-salesforce docs, it only shows accessing object metadata using hard-coded methods like such:
sf.Contact.metadata()
Is there no way to do something like this?
sf["Contact"].metadata()
I want to loop through a list of objects…

logeyg
- 549
- 2
- 8
- 31
4
votes
3 answers
Lambda function failing with /lib64/libc.so.6: version `GLIBC_2.18' not found
I am trying to create a layer of simple-salesforce (Python Library) in AWS lambda, and trying to use it (import it) from my python code. I am having windows machine.
Though I read that there might be issues due to compilation windows so I install…

Tanmay Bordekar
- 61
- 1
- 8
4
votes
4 answers
Cannot login to Salesforce Sandbox via python API
I am using the python3.7.2 module simple-salesforce==0.74.2 and I am having trouble trying to establish a connection to my salesforce sandbox. I can login to the salesforce production with the same credentials just fine like so:
from…

lollerskates
- 964
- 1
- 11
- 28
4
votes
2 answers
Salesforce bulk api using the python simplesalesforce package
I am using the simple-salesforce python package with python 3. According to the documentation, I should be able to bulk update records using this syntax:
data = [{'Id': '0000000000AAAAA', 'Email': 'examplenew@example.com'}, {'Id':'0000000000BBBBB',…

Maile Cupo
- 636
- 1
- 10
- 26
4
votes
2 answers
Fetch picklist values through SOQL query in Salesforce
I am using Djnago & Salesforce.
I establish connection between them through simple-salesforce
I have created a custom picklist on Contact Object of Salesforce.
I wont to fetch all the 20 values of my picklist & display in Django.
I am looking for…

Jeevan Bodas
- 148
- 5
- 13
4
votes
2 answers
How to get files from Salesforce using Python
I am using Python/Beatbox to access Salesforce cases.
service = beatbox.PythonClient() # instantiate the object
service.login(...) # login using your sf credentials
query_result = service.query("SELECT Id, AccountId, CaseNumber FROM Case WHERE…

user7233710
- 41
- 1
- 2
3
votes
2 answers
Python 3 Simple Salesforce Testing to see if an object exists and contains data
is there an easy way to test if an object exists and isn't empty using simple salesforce? I have some code that is working to fetch records and I need to ensure that the objects I am getting from a file generated by someone else exist and are not…

Shenanigator
- 1,036
- 12
- 45
3
votes
0 answers
SSL Error while using simple salesforce package in python
For the first time I am using the simple_salesforce package in python to connect to salesforce cloud.
Using the following code:
import os
import zipfile
import requests
import subprocess
from datetime import datetime
from bs4 import BeautifulSoup…

bivin
- 31
- 4