rforcecom.query <-
function(session, soqlQuery){
# Load packages
require(XML)
require(RCurl)
# Retrieve XML via REST API
h <- basicHeaderGatherer()
t <- basicTextGatherer()
endpointPath <- rforcecom.api.getSoqlEndpoint(session['apiVersion'])
URL <- paste(session['instanceURL'], endpointPath, curlEscape(soqlQuery), sep="")
OAuthString <- paste("OAuth", session['sessionID'])
httpHeader <- c("Authorization"=OAuthString, "Accept"="application/xml")
curlPerform(url=URL, httpheader=httpHeader, headerfunction = h$update, writefunction = t$update, ssl.verifypeer=F)
# BEGIN DEBUG
if(exists("rforcecom.debug") && rforcecom.debug){ message(URL) }
if(exists("rforcecom.debug") && rforcecom.debug){ message(t$value()) }
# END DEBUG
# Parse XML
x.root <- xmlRoot(xmlTreeParse(t$value(), asText=T))
# Check whether it success
errorcode <- NA
errormessage <- NA
try(errorcode <- iconv(xmlValue(x.root[['Error']][['errorCode']]), from="UTF-8", to=""), TRUE)
try(errormessage <- iconv(xmlValue(x.root[['Error']][['message']]), from="UTF-8", to=""), TRUE)
if(!is.na(errorcode) && !is.na(errormessage)){
stop(paste(errorcode, errormessage, sep=": "))
}
# Convert XML to data frame
xns <- getNodeSet(xmlParse(t$value()),'//records')
xdf <- xmlToDataFrame(xns)
xdf.iconv <- data.frame(lapply(xdf, iconv, from="UTF-8", to=""))
return(data.frame(xdf.iconv))
}
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.