Skip to content

Instantly share code, notes, and snippets.

@tzmfreedom

tzmfreedom/get_record.vba

Created September 13, 2014 13:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tzmfreedom/6fd3ca8dbfb7b41ab00f to your computer and use it in GitHub Desktop.
Save tzmfreedom/6fd3ca8dbfb7b41ab00f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_record.vba
Dim objXmlHttp As Object
Set objXmlHttp = createObject("MSXML2.XMLHTTP")
objXmlHttp.Open "GET", "https://***.salesforce.com/services/data/v30.0/query/?q=SELECT id FROM Account")
Call objXmlHttp.setRequestHeader("Content-Type", "application/json")
Call objXmlHttp.setRequestHeader("Authorization", "Bearer " + sessionId)
Call objXmlHttp.setRequestHeader("Accept", "application/xml")
objXmlHttp.send
CallRestApi = objXmlHttp.responseText
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment