Questions tagged [simple-salesforce]
simple-salesforce is a basic Salesforce.com REST API client built for Python 2.6, 2.7, 3.3, 3.4, 3.5, and 3.6.
32
questions
1
vote
1answer
39 views
Python Simple-Salesforce - Import related records with an external ID
Some time ago I've started to use Python with Pandas and Simple-Salesforce to make data migration to Salesforce orgs.
I want to insert Account records and Contact records that have lookup to Account ...
0
votes
1answer
36 views
How to upload products to opportunity using simple_salesforce
OK, I can be more specific now.
Tried now to simply create new opportunity line items, however, I get this error message:
esponse content: [{'message': "Error: You can't select products until you'...
1
vote
1answer
52 views
Simple Salesforce Query issues involving Malformed requests
I have a malformed query problem when using simple salesforce for my AWS python Lambda.
The query uses the AccountContactRelation object.
When an event is dropped into an AWS S3 bucket for taxonomy ...
0
votes
0answers
10 views
lightning:unsavedChanges not works with console application
lightning:unsavedChanges not works while doing tab switch in console application.
It works fine on tab switching in standard application.
Any thoughts?
1
vote
1answer
203 views
Python Simple Salesforce - Upsert to CampaignMembers Object
I am trying to find an automated way to add contacts & leads to existing campaigns by using simple salesforce to upsert records to the CampaignMembers object. I have a CSV file with CampaignId and ...
0
votes
1answer
68 views
Execute Anonymous via Simple_Salesforce throwing EOF exception
I'm attempting to execute a simple anonymous Apex script via Python with the simple_salesforce library.
from simple_salesforce import Salesforce
sf = Salesforce(instance=scratch_org_instance, ...
1
vote
1answer
766 views
REST API: Error 'METHOD_NOT_ALLOWED' - PATCH
I am trying to upload new records by calling a REST API but am getting the following error.
simple_salesforce.exceptions.SalesforceGeneralError: Error Code 405. Response content: [{'errorCode': '...
2
votes
1answer
573 views
Object of type datetime is not JSON serializable
I'm new using Simple_Salesforce for Python and I'm trying to update a record of "Account" and one of the values that I need to update is a Date/Time value, but I'm receiving the error: "...
0
votes
1answer
37 views
Is there any way to cache the salesforce data using "simple_salesforce" python library
In my python application, I used "simple_salesforce" library to fetch data from salesforce. Instead of hitting an API every time I would expect salesforce to return data from cache instead ...
0
votes
1answer
891 views
Using simple-salesforce with oAuth
I have a need to query salesforce data through a django app. I am currently using simple-salesforce to do this on our QA salesforce using a username, password and a security token. Now that I am ...
0
votes
1answer
126 views
simple_salesforce python how to rewrite this using bind variables
revenue = sf.query("SELECT Id, Name, Net_Revenue__c, Price__c, Credits__c, Gross_Revenue__c, Account__r.Name \
FROM Revenue__c WHERE Account__r.Id = '"+accountId+"' and MonthYear__c ...
1
vote
1answer
571 views
Dynamic simple_salesforce query with list of ids
This 2nd format_soql is not working. I have tried replacing the single quotes to double quotes as per the format defined here: https://github.com/simple-salesforce/simple-salesforce#queries
query1 = &...
0
votes
1answer
36 views
Where can I view attachments that I've uploaded to salesforce using a REST api?
response = requests.post('https://%s.salesforce.com/services/data/v29.0/sobjects/Attachment/' % instance,
headers = { 'Content-Type': 'application/json', 'Authorization': 'Bearer %s' % sessionId },...
0
votes
1answer
531 views
Error Salesforce data query - [{'message': 'INVALID_HEADER_TYPE', 'errorCode': 'INVALID_AUTH_HEADER'}]
I am trying the get data from Salesforce using simple_salesforce python package.
But I am getting Response content: [{'message': 'INVALID_HEADER_TYPE', 'errorCode': 'INVALID_AUTH_HEADER'}] when I ...
0
votes
1answer
32 views
Is ActivityDate a known bug with bulk API loading tasks?
I've been fighting Salesforce all morning with a data load via the Python simple_salesforce package (so yes, the bug could be there, rather than there being an issue in the Bulk API).
If I run this ...
1
vote
1answer
503 views
passing a variable in SOQL select statement with python and simple-salesforce
I am trying to pass a variable into SOQL statement, I am using simple_salesforce library. I only need to grab the data when CreateDate of the Opportunity is > than yesterday, yesterday's date is saved ...
0
votes
1answer
529 views
Python with Simple Salesforce dynamic SOQL query issue: ERROR at Row:1:Column:98\nline 1:98 no viable alternative at character '\\'",
I have to retrieved data from a SOSL query using simple saleforce with no issues. This query will search for duplicate leads or contacts in Salesforce and then
get the multiple records retrieved and ...
0
votes
1answer
270 views
Python: ContentVersion.VersionData throwing Incorrect padding while decoding to base64 string
I have the following Python code using Simple_Salesforce module:
def get_email_template(sf, agreement_id):
email_templates = sf.query(f"""
SELECT VersionData, Title, PathOnClient
...
0
votes
0answers
126 views
simple_salesforce bulk insert - Duplicate Id error
I am using the Python package simple_salesforce to bulk insert instances of a custom object. The custom object has Account Id as a foreign key, which I am inserting during the bulk insert.
I'm seeing ...
0
votes
1answer
698 views
simple_salesforce - Cannot bulk insert more than 10 records at a time [closed]
I am using the simple_salesforce Python package. I tried bulk inserting 100 records using bulk.insert(), and did so without any errors. However, when I checked how many records were present after, ...
0
votes
1answer
669 views
SalesForce Bulk API response to Pandas DataFrame [closed]
I'm a beginner with the Salesforce API and recently, I've been trying make bulk API requests and convert the response into a pandas DataFrame, however, the results I'm having a tough time with are ...
2
votes
1answer
539 views
How to use simple salesforce (python library for salesforce) to add ShippingAddress field?
I have tried to upsert an account with ShippingAddress using simple salesforce However, I am getting the error:
[{u'errorCode': u'JSON_PARSER_ERROR', u'message': u'Cannot deserialize instance of ...
0
votes
0answers
408 views
simple_salesforce Custom Domain
I am having some trouble using simple_salesforce to login using my username, password, security token. My companies SF instance is on a custom domain (I do not use login.salesforce.com and instead I ...
0
votes
1answer
2k views
simple_salesforce Run Report
I have a simple Salesforce report that returns basic information about some opportunities such as opportunity id, owner, end date.
I found the simple_salesforce Python module and I am trying to ...
2
votes
1answer
1k views
Unable to fetch complete records from bulk query batch result
I am using simple-salesforce python library using REST to call bulk services which is working fine till calling but for large dataset library continuously poll the batch status and spit all result (in ...
0
votes
1answer
2k views
Getting error in Python when login to Salesforce
I am using simple-salesforce 0.74.2 for connecting to Salesforce by using below code,
from simple_salesforce import Salesforce,SalesforceLogin
sf = Salesforce(instance_url='https://xxxxx-xxx.my....
1
vote
1answer
730 views
How to Query for logged in username [Python:SimpleSalesforce]?
Tried to do
user=sf.query("SELECT Id, Name FROM User WHERE Id = :UserInfo.getUserId()"
but getting error:
content = [{u'errorCode': u'MALFORMED_QUERY', u'message': u'\nSELECT Id, Name from User ...
2
votes
1answer
523 views
Salesforce Report - Column list
I am trying to see if I can fetch all columns in Reports object.
I have the before
import pandas as pd
from simple_salesforce import Salesforce
sf_data_cursor = Salesforce(username='mail@mail.com', ...
0
votes
1answer
2k views
Python Simple Salesforce and salesforce rest authentication errors
An absolute python newbie & trying to establish a connection between python & salesforce.
Followed this documentation - https://pypi.org/project/simple-salesforce/ and we have a python script ...
0
votes
2answers
631 views
Simple-Salesforce API object agnostic
Trying to figure out a way if I can use this API to get retrieve data if I only have the ID (don’t know if it is a task or a contact, etc.)
I think no but just want to confirm.
1
vote
1answer
725 views
REST Upload attachments - Json Deserialization failed on token 'null'
I'm using simple-salesforce to migrate attachments from one org to another. I'm encoding with base64 but am getting this error:
SalesforceMalformedRequest: Malformed request
https://my_org.my....
4
votes
1answer
3k views
Error "Bind variables only allowed in Apex code" simple_salesforce (Python)
Not sure if this belongs here or in StackOverflow, seems 50/50.
I am trying to figure out how to build a dynamic query using simple_salesforce and there is no problem using a completely static query ...
