Hi tjn11,
I don't know if it is a big help, but here is my solution how i connect to salesforce via OAuth and then manage objects via the REST API.
(You can find a lot of information about OAuth and salesforce here)
First you have to authenticate yourself on the authorization server with your "Consumer Key" and your "Redirect URI" (both have to be absolutely identical with the values in the Remote Access definition).
I developed an excel integration, so in my implementation it looked like this:
var authURI = new StringBuilder();
authURI.Append(salesforceAuthorizationEndpoint);
authURI.Append("response_type=code");
authURI.Append("&client_id=" + consumerKey);
authURI.Append("&redirect_uri=" + redirectUri);
Globals.WorksheetFunctions.requestBrowser.Navigate(authURI.ToString());After calling this address in the browser you see the salesforce login page, where you log in with your sf credentials.
If the authentication was successfull, you will be redirected to your redirect uri with additional informationen added as key value pairs in the uri.
First you have to retrieve the authorization code from the uri.
With this and some other values you generate a post request:
(If you don't know how to peform a webrequest see this page)
To do so, I did something like this:
var sb = new StringBuilder();
keyValues.Add("code", authorizationCode);
keyValues.Add("grant_type", "authorization_code");
keyValues.Add("client_id", ConsumerKey);
keyValues.Add("client_secret", ConsumerSecret);
keyValues.Add("redirect_uri", redirectUri);
foreach (KeyValuePair<string, string> pair in keyValues)
sb.AppendFormat("{0}={1}&", pair.Key, pair.Value);In the Response Stream you get a lot of information, e.g. "access_token" and "instance_url".
With this information you can manage objects in salesforce.
As an example the next code snippet shows the way how you perform an upsert for a user object.
User/Username/test@yourwebsite.com/", instance_name);
This will be your Request Uri and don't forget to add the header attribute (key: "Authorization", value: "Bearer " + access_token).
The data in the request body has to be in JSON format (see JSON website).
Inform yourself about the required fields before you do that and watch the repsonse/exception after your request for good error handling.
It is also possible to do a SOQL request:
In this case you just have to use the same uri start, but append "query/":
var requestUri = string.Format("{0}/services/data/v26.0/query/?q={1}, instance_name, soqlQuery)and the SOQL statement, where spaces are replaced by the '+' symbol.
I hope this will help you a bit.
Salesforce.com Certified Administrator
