Questions tagged [simple-salesforce]

Use this tag for questions concerning simple-salesforce: A very simple Salesforce.com REST API client for Python.

Reference:

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…
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…
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
1
2 3
9 10