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.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 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
35 views

Upserting records via Simple_Salesforce API on a field with Master-Detail relationship

I'm trying to use Python's simple_salesforce library to upsert on an object called Member Plan that has a required field called MemberId which is a Master-Detail relationship with the Account object. ...
0
votes
1answer
23 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 ...
0
votes
0answers
9 views

Python Simple-Salesforce Package: How to execute a method in an apex class [duplicate]

I have an apex class with a method in it which will insert content into ContentVersion and ContentDocumentLink. public Class ContentUtils { public Static void createContent(ContentVersion cv, Id ...
1
vote
1answer
27 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
25 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
49 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
48 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
198 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
232 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 ...
1
vote
1answer
159 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
151 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
634 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
550 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
827 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
435 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 ...
1
vote
1answer
144 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
877 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
335 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
443 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
2k 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 ...