[SalesForce] To call an external URL from salesforce

I have a requirement where I need to send the Opportunity Information along with the Account fields to an External HTTP URL as JSON whenever the Opp stage is updated to Closed-won. As a response I receive an AccounId which I need to map it to the field on Account Object

I came across the below approaches:

Apex trigger that uses @future method with POST method(but it has limitation like 10 callouts).
Outbound Workflow (but not able to use SOAP since they are looking for a JSON format)
Custom Button on Opp that calls an Integration apex class through POST method I can send the Opp Info to External URL and receive the response.
Streaming API(Read not a great approach)

Can you pls suggest the best method that works for my real time push to the external URL.

Best Answer

Apex Trigger

This can be done with @future as long as the receiver can handle a JSON object as a list and not just a single post.

If the receiving service cannot handle a JSON Object as a list then you will have to look at NON real time (batch, etc) or implement a transaction control object to process the records in "near real time" one at a time

The problem with any "near real time" option is the decision to send every change or just the current state at the time the data is sent.

Outbound Workflow

Not really an option UNLESS you build a custom rest service to receive the SOAP payload and then pass it on to the service. May be an option as this will work on the individual records. You will have to worry about API call limits, etc

Custom Button on Opp

May be a great choice as by design this will be a one for one call and can be implemented by simply redirecting to a visual force page that does the work then takes the user back to the opp. Or simply a web service method that does the callout without much control with regards to displaying a progress, status that something is happening, etc. Since it requires a user to click on a button you will not have multiple records in the same transaction and the data is only sent when processes dictate. Cons - Users forgetting to send the information. you can make up for this by implementing a batch process to "sweep" the system for records that were modified and not sent, gather them up, and send one at a time. It all depends on how critical it is to have them sent real time and the impact the possibility of the user forgetting would be

Streaming API

Not really possible as an external service cannot "Listen" to SF for events (AFAIK) Someone please correct me if I am wrong..

Related Solutions

[SalesForce] How to query to Session Id to call the REST API in salesforce from third party applications

Your (presumably external to Salesforce) application will need to obtain the session ID by first authenticating with Salesforce. Once the authentication is complete you will be returned a session ID (AKA an access token) that can then be included in the request to your REST API. See e.g. Understanding Authentication.

Getting the authentication logic right is typically trickier than implementing the REST API. Plan for this to take several hours of research followed by probably rather more hours of configuration/coding/testing.

[SalesForce] the maximum number of records which can be insterted in Apex REST calling a POST method

Even if you consider best case scenario with following points: 1) you have no trigger in place, no workflows, no additional processing 2) you are just dumping data in target object - no query

Then also you will not be able to insert more than 10k records. Not just in APi but in UI or any other synchronous process.

whatever way you try in synchronous execution we can not insert more than 10k rows.

Here is code to prove my point.

Map<Integer,list<Task>> mapOfList = new Map<Integer,list<Task>>();
List<Task> tasklist = new List<Task>();
For(integer i =0; i<100;i++){
    For(integer j =0; j<9999; j++){ // 10k tasks
        Task t = New Task(Subject = 'Test task', priority = 'Low', status = 'In Progress' );                
        tasklist.add(t);
    }    
    mapOfList.put(i,tasklist);
}

For(Integer i : mapOfList.keyset() ){
    insert mapOfList.get(i);
    System.debug('insert ' +  i);
}

System.debug('Final Heap Size: ' +  Limits.getHeapSize());
System.debug('Final Cpu Time(): ' +  Limits.getCpuTime());

Note following things:
1) We can hold 10k * 100 = 1000K rows in HEAP using map of list and apex wont complain
2) There is not any CUP intensive operation so CPU time limit wont come in picture (DB time is calculated separably)
3) There are no SQL queries
4) Total # DML statements(insert in out case) are less than 150

Ref: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm

Best Answer

Related Solutions

[SalesForce] How to query to Session Id to call the REST API in salesforce from third party applications

[SalesForce] the maximum number of records which can be insterted in Apex REST calling a POST method

Related Topic