Advertisement
Guest User

Untitled

a guest
May 6th, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. {"errorCode":"118","message":"The request body is empty"}
  2.  
  3. import json, requests
  4.  
  5.  
  6. consumer_key = "3MVG9ZL0ppGP5UrB2Sh2lonpKJkgWlzWSQqTZLng6f1WdxYWnxj6DsERseHPRiJi5DFjiZBjUTO6RBuPgBZ1G"
  7. consumer_secret = "xxxx"
  8. username = "xxxx"
  9. password = "xxxx"
  10.  
  11. payload = {
  12. 'grant_type': 'password',
  13. 'client_id': consumer_key,
  14. 'client_secret': consumer_secret,
  15. 'username': username,
  16. 'password': password
  17. }
  18.  
  19. r = requests.post("https://login.salesforce.com/services/oauth2/token",
  20. headers={"Content-Type":"application/x-www-form-urlencoded"},
  21. data=payload)
  22.  
  23.  
  24. print r.content
  25. body = json.loads(r.content)
  26. token = body["access_token"]
  27. saqlquery = "q = load "0Fb28000000PBfqCAG/0Fc28000000Ag0nCAC;";q = group q by 'Name';q = foreach q generate 'Name' as 'Name', sum('Amount') as 'sum_Amount';}"
  28. url = body["instance_url"] + "/services/data/v36.0/wave/query"
  29.  
  30. r = requests.post(url, headers = {"Authorization":"Bearer " + token}, data = {"query":saqlquery});
  31.  
  32. print r.content
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement