Sales Force Integration


Problem:
I need to connect to Sales Force REST API and fetch data for another application

Solution:

1. Create a new remote access application in Sales Force
2. Create OAuth token and secret from Sales Force
3. Use the token and secret in your application

The http://wiki.developerforce.com/page/Getting_Started_with_the_Force.com_REST_API 
provides how this is done but its not the latest and things have changed a lot.

 1. Create a new remote access application in Sales Force
        Log in to Salesforce.com with your developer account, 
        navigate to Setup ➤ Develop ➤ Remote Access, 
        Click New to create a new remote access application
    Once you click Remote Access it will say 
    Remote Access Objects have been moved to Applications. 
    You'll be redirected to that page in five seconds, or you can click Take Me There to go now. 
    Then you will be forwarded to Create -> Apps section
2. Go to Connected Apps and create new
    Fill in the App details and Check the OAuth Enable
3. Add Access Rights - Full or selected and Save
4. You will be displayed with the App details that you created with a section called
   "API (Enable OAuth Settings) which will contain the Consumer Key and the Consumer Secret to    use (You can make use of the call back url or ignore it)

Note: When IP range is entered for the profile to restrict access by IP range then Token is not available for the account to be used at login by the API - IP Restrictions are added to the Login IP Ranges
Missing Reset Security Token option
https://help.salesforce.com/HTViewSolution?id=000182450


Comments

Post a Comment

Popular posts from this blog

API design best practices

API Design summary 1. Use two base URLs per resource 2. Keep verbs out of your base URLs 3. Use HTTP verbs to operate on the collections and elements 4. Be consistent either use plural nouns or singular nouns 5. Use concreate names rather than abstract names     An intuitive API uses plural rather than singular nouns, and concrete rather than abstract names 6. keep your API intuitive by simplifying the associations between resources, and sweeping parameters and other complexities under the rug of the HTTP question mark. Handling errors Errors boil down to Everything worked - ok The application did something wrong – client error The API did something wrong – server error In summary, be verbose and use plain language descriptions. Add as many hints as your API team can think of about what's causing an error. eg: HTTP Status Code: 401 {"status" : "401", "message":"Authenticate","code": 20003, "...
Read more

DB Connection Issues

1. Application gives "1c86bdf0 SharedPool I J2CA0086W: Shareable connection MCWrapper id 686bbdf9 Managed connection com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6156bdf9 State:STATE_TRAN_WRAPPER_INUSE" message when trying to do a db update within loop which is querying a view and carrying out some operations. In IBM this problem is documented under the topic " Application hangs with prior J2CA0086W warning messages" The solutions are  1. The application must be modified to use serial reuse or 2. The connection pool can be changed to unshareable. Shareable connections are not allowed within a local transaction containment boundary. The above scenario suggests a possible problem in the application logic and how it is using the connection code. The J2CA0086 message is telling you that your application is using a shared connection in a LocalTransaction. Since the connection is enlisted in a Local Transaction, and not a Global Transaction, di...
Read more

Reading Excel Sheet on client side and processing it

Image
If you ever want to process excel sheets on the client side (on the browser) then this will be useful for you.  This uses  http://oss.sheetjs.com  coed and the source files are in ( https://github.com/SheetJS/js-xls ,  https://github.com/SheetJS/js-xlsx ) it is licensed under Apache Licence, Version 2.0 (refer attached licence in the libraries in github) Steps to Follow, JS Files required: Copy the code for following files and make corresponding files locally, or download them from github,                 https://raw.github.com/SheetJS/js-xlsx/master/xlsx.js                 https://raw.github.com/SheetJS/js-xls/master/xls.js                 http://stuk.github.io/jszip/ We will be taking some javascript already in oss.sheetjs.com for our example particularly on the main page of oss.sheetjs.com. Sample Excel Sheet: Our exce...
Read more