public
Last active

Simple query against Force.com REST API in Python

  • Download Gist
restquery.py
Python
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
import os
import urllib
import urllib2
import json
import pprint
 
# Grab credentials from the environment
consumer_key = os.environ['CLIENT_ID']
consumer_secret = os.environ['CLIENT_SECRET']
username = os.environ['USERNAME']
password = os.environ['PASSWORD']
login_server = os.environ['LOGIN_SERVER']
 
# Do OAuth username/password
token_url = login_server+'/services/oauth2/token'
 
params = urllib.urlencode({
'grant_type': 'password',
'client_id': consumer_key,
'client_secret': consumer_secret,
'username': username,
'password': password
})
 
data = urllib2.urlopen(token_url, params).read()
oauth = json.loads(data)
pprint.pprint(oauth)
 
# Now do a query
params = urllib.urlencode({
'q': 'SELECT Name FROM Account'
})
 
query_url = oauth['instance_url']+'/services/data/v23.0/query?%s' % params
 
headers = {
'Authorization': 'OAuth '+oauth['access_token']
}
 
req = urllib2.Request(query_url, None, headers)
data = urllib2.urlopen(req).read()
result = json.loads(data)
pprint.pprint(result)

if i may ask, what is the login server? Is the instance server? Im getting 401s all over the place...

login_server is either https://login.salesforce.com or https://test.salesforce.com depending on whether you are using a production or sandbox instance.

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.