Questions tagged [beatbox]

Beatbox is a minimal dependency python library for accessing the salesforce.com web services API.

Beatbox is a minimal dependency python library for accessing the salesforce.com web services API.

Its primary dependency is on xmltramp, a xml parser library that exposes access to the xml document in an easy to use manner.

29 questions
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

Parse Salesforce report in Pandas DataFrame using Beatbox

Has anybody tried parsing SalesForce report into Pandas DataFrame using Beatbox? There are couple of examples on SO but none of them have provided comprehensive solution or at least what I have perceived it hasn't. #!/usr/bin/env python3 import…
r0xette
  • 898
  • 3
  • 11
  • 24
3
votes
1 answer

Uploading Attachments to Salesforce API via Beatbox, Python

I'm uploading documents to Salesforce using beatbox and python and the files are attaching correctly but the data contained within the files gets completely corrupted. def Send_File(): import beatbox svc = beatbox.Client() # instantiate the…
shartshooter
  • 1,761
  • 5
  • 19
  • 40
3
votes
1 answer

How to extract raw data from Salesforce using Beatbox python API

I am using the following code to extract data from Salesforce using beatbox python API. import beatbox sf_username = "xyz@salesforce.com" sf_password = "123" sf_api_token = "ABC" def extract(): sf_client = beatbox.PythonClient() password =…
Raj
  • 22,346
  • 14
  • 99
  • 142
2
votes
2 answers

How to create multiple records in Salesforce using simple_salesforce module

I am trying to load bulk data from csv file to Salesforce using python. when i am trying to create single record in Salesforce it's working fine from simple_salesforce import Salesforce from simple_salesforce import SFType sfdc =…
2
votes
1 answer

How to create a custom table in Salesforce using Beatbox or simple-salesforce?

We are currently evaluating Python bindings for Salesforce - in particular Beatbox and simple-salesforce. In both modules via are missing functionality to create new custom tables, drop a custom table and dropping all items of a custom tables…
user5638381
2
votes
1 answer

Beatbox/Python - Having issues updating multiple records in Salesforce

I've got beatbox working well with an SFDC developer account. I'm pushing to Salesforce to create custom objects but it's updating one at a time. Is there a way to push 200 changes at once to limit the amount of api calls i'm making? The script I…
shartshooter
  • 1,761
  • 5
  • 19
  • 40
1
vote
1 answer

beatbox: Update custom field of multiple records at Account object

I am passing dict of something like object_dict = {'Name': 'Sample Account', 'Type': 'Account', 'Id': '00001834fiBkAAO', 'score__c': '333'} and want to update only 1 custom field ('score__c') at Account object but I am confused with the…
Gagan
  • 1,775
  • 5
  • 31
  • 59
1
vote
2 answers

salesforce python Beatbox import error

I am trying to log in to salesforce.com's sandbox using a URL, ID and PASS. I want to use SOAP API for that. When I try to import beatbox in python3, it throws an ImportError exception. However, I can confirm that beatbox is installed in python3. So…
r0xette
  • 898
  • 3
  • 11
  • 24
1
vote
1 answer

SOQL IN query from Python

I'm wondering if anyone knows how to format an IN query using either beatbox or simple salesforce. Example: select id from lead where id in ('00Q3000000zLxkFEAS', '00Q3000000eODvUEAW') In simple salesforce I…
Daniel Dow
  • 487
  • 1
  • 7
  • 20
1
vote
1 answer

Beatbox: Possible to add condition to query when pulling SFDC data?

In Pandas, I want to pull Opportunity data with CreatedDate >= 1/1/2015. Currently, I am extracting all Opportunity data before filtering for CreatedDate. Is it possible to optimize this process by adding the CreatedDate condition to the…
Eric
  • 673
  • 1
  • 6
  • 12
1
vote
2 answers

Beatbox: How do I add a WHERE clause when pulling data from SFDC?

In Pandas, I am creating a dataframe that merges data from two different Beatbox queries. First, I pull all my Opportunity data, then I pull all my Account data, and then I merge. However I would like to optimize this process by only pulling data…
Eric
  • 673
  • 1
  • 6
  • 12
1
vote
1 answer

Python Beatbox to Salesforce Error Connecting to Salesforce

I just had my computer re-imaged and have Python 2.7.9 (64-bit) installed on my machine. Using PIP I have beatbox 32.1 installed. When I make the call to connect to Salesforce: sf_client.login(sf_username, sf_password) logging.info('Connected…
Steve I
  • 21
  • 5
1
vote
0 answers

Error connecting to SF object to get the ForecastingItem object description using beatbox - python

from a ubuntu machine I use beatbox python package to connect to SF and get the objects descriptions but can't manage to get access to the ForecastingItems object. I checked my privileges to access the object and I have full access as admin the…
mongotop
  • 7,114
  • 14
  • 51
  • 76
1
vote
2 answers

python salesforce beatbox: beatbox._beatbox.SoapFaultError: 'INVALID_FIELD'

I am using beatbox to connect to Salesforce from Python and it works fine until I try to add constraint with dates. When I add a CreatedDate constraint it fails saying File "/Library/Python/2.7/site-packages/beatbox/_beatbox.py", line 332, in…
daydreamer
  • 87,243
  • 191
  • 450
  • 722
1
2