JSON Integration and handling control characters in JSON Response

Below is the code which sends a Post Http Request and handles the Special or Control characters in Json response while parsing.

	String jsonStr = '';
	String url = 'https://www.xyz.com/test.cfm'; //Endpoint url
	String username = '<Username>';
	String password = '<Password>';
	HttpRequest req = new HttpRequest();
	req.setMethod('POST');
	req.setEndpoint(url);
	req.setHeader('Content-type', 'application/json;charset=UTF-8');
	Blob headerValue = Blob.valueOf(username + ':' + password);
	String authorizationHeader = 'BASIC ' + EncodingUtil.base64Encode(headerValue);
	req.setHeader('Authorization', authorizationHeader);
	Http http = new Http();
	HTTPResponse res = http.send(req);
	jsonStr = res.getBody();
	//Replace the control characters with space
	jsonStr = jsonStr.replaceAll('\\p{Cntrl}', '');
	JSONParser parser = JSON.createParser(newJsonStr);
	while (parser.nextToken() != null) {
	// Start at the array of invoices.
	if (parser.getCurrentToken() == JSONToken.START_ARRAY) {
	while (parser.nextToken() != null) {
	if (parser.getCurrentToken() == JSONToken.START_OBJECT) {
	<Your Parser logic>
	}
	}
	}
	}

view raw JSON Integration and handling control characters in Json hosted with ❤ by GitHub

Note:- While using the regex '\\p{Cntrl}' , if the length of the Json response is more than the limit then you may get Regex too complicated Error message in apex class. In this case you can apply regex on substring of a Json string and then join the substring back as shown below:-

Integer jsonlength = jsonStr.length();
    String newJsonstr = '';
    
    
    if(jsonlength > 100000)
    {
      Integer Quot = jsonlength/100000;
      Integer modcheck = math.mod(jsonlength,100000);
      
        
        for(Integer i = 0; i < Quot; i++)
           newJsonStr += jsonStr.substring(i * 100000,100000 * (i+1)).replaceAll('\\p{Cntrl}', '');
    
    if(modcheck > 0)
       newJsonStr += jsonStr.substring(jsonlength - modcheck,jsonlength).replaceAll('\\p{Cntrl}', '');
      
    }

Trigger to count the Number of Open Task in Opportunity

Below is one of the example code which helps to get the count of open Task in related Opportunity

	trigger OpenTaskCount on Task (after insert, after update, after delete, after undelete) {
	List<Task> taskList = (Trigger.isInsert|| Trigger.isUnDelete) ? Trigger.new : Trigger.old;
	List<Id> taskIds = new List<Id>();
	for (Task tsk : taskList) {
	taskIds.add(tsk.WhatID);
	}
	List<Opportunity> oppList = [
	select
	id,
	(select id, WhatID, IsClosed from Tasks),
	Open_Tasks__c,Total_Tasks__c
	from
	Opportunity
	where
	id in :taskIds];
	for (Opportunity opp : oppList) {
	Integer count = 0;
	for(Task tsk : opp.Tasks)
	{
	if(tsk.WhatId != null && !tsk.IsClosed)
	count += 1;
	}
	opp.Total_Tasks__c = opp.Tasks.size();
	opp.Open_Tasks__c = count;
	}
	update oppList;
	}

view raw OpenTaskCount hosted with ❤ by GitHub

Explanation of the Trigger

Code Block 1:-

trigger OpenTaskCount on Task (after insert, after update, after delete, after undelete) 

This Trigger fires on after insert, update, delete and undelete events on Task object
similarly, this trigger can be used on any child object:-

trigger <TriggerName> on ChildObject (after insert, after update, after delete, after undelete)

Code Block 2:-

List<Task> taskList = (Trigger.isInsert|| Trigger.isUnDelete) ? Trigger.new : Trigger.old;
 

If the event is "after Insert" or "after undelete", then the list takes the value Trigger.new or else it takes Trigger.Old
similarly,

List<ChildObject> lstChild = (Trigger.isInsert|| Trigger.isUnDelete) ? Trigger.new : Trigger.old;

Code Block 3:-

List<Id> taskIds = new List<Id>();
    for (Task tsk : taskList) {
        taskIds.add(tsk.WhatID);
    }

This above code helps to get the RelatedTo Id i.e The Opportunity Id to which this task belongs.
similarly, get the parent id by using the following

List<Id> ChildIds = new List();
    for (ChildObject chd : ChildList) {
        ChildIds.add(chd.ParentFieldname);
    }

Code Block 4:-

 List<Opportunity> oppList = [
            select
                id,
                (select id, WhatID, IsClosed from Tasks),
                 Open_Tasks__c,Total_Tasks__c
            from
                Opportunity
            where
                id in :taskIds];

The above code is the SubQuery which gives us the Number of task records present in that opportunity.
(select id, WhatID, IsClosed from Tasks) is the query which gives the task record and important to note here that "Tasks" is not the Object name, it is the Child Relationship Name.
To get that name, click on Relatedto field in object Task and check the ChildRelationship name.
similarly,

 
List<ParentObject> ParentList = [
            select
                id,
                (select FieldNames from ChildRelationshipName),
                
            from
                ParentObject
            where
                id in :ChildIds];
 

For Custom Object, append the ChildRelationshipName with "__r" i.e ChildRelationshipName__r

Code Block 5:-

 for (Opportunity opp : oppList) {
        Integer count = 0;
        for(Task tsk : opp.Tasks)
         {
           if(tsk.WhatId != null  && !tsk.IsClosed) 
           count += 1;
         }  
              
        opp.Total_Tasks__c = opp.Tasks.size();
        opp.Open_Tasks__c = count;
    }
    update oppList;  

The above code gives us the logic to rollup and count the Open Task.
similarly,

 for(Parentobject parent : ParentList) {
        Integer count = 0;
        for(Integer i =0;i < opp.ChildRelationshipName.size(); i++)
        {
         if(opp.ChildRelationshipName[i].FieldName != null  && !opp.ChildRelationshipName[i].IsClosed) 
          count = count + 1;
          
        }
        parent.FieldName = count;
    }
    update ParentList; 
 

Note:- So in any Case if you want to write a Trigger which updates the Parent object field, the above code can do the trick.

Send Template Email to Custom object email field

Well Recently I was figuring it out to send email to a custom object email field through the list view page custom button. On click of the button it should open a small panel to select the Email Template and send it to the selected email.

Hmm pretty cool panel. But how to do it?
This is how I started,

1) Create a global class as follows. (Note :- You need to replace the "Person_Detail__c" object with your custom object and the "Email__c" field with your custom email field)

	global class SendEmailHandler {
	webservice static boolean sendEmail(List<Id> personIds,string templateId)
	{
	//Get all the Persons record where Id in personIds and email not equal to null
	List<Person_Details__c> lstperson = [Select Id, Name, email__c from Person_Details__c where Id in :personIds and email__c != null];
	//Get the Contact Id to set it for setTargetObjectId of SingleEmailMessage
	List<Contact> lstContact = [Select Id from Contact limit 1];
	Messaging.SingleEmailMessage[] emailMessageList = new Messaging.SingleEmailMessage[]{};
	//Loop through the Person record and Fill the EmailMessage List
	for(Person_Details__c p : lstperson)
	{
	Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
	List<String> toaddress = new List<String>();
	toaddress.add(p.Email__c);
	mail.setToAddresses(toaddress);
	mail.setSenderDisplayName('MyCompanyName');
	mail.setTemplateID(templateId);
	mail.setTargetObjectId(lstContact[0].Id);
	mail.saveAsActivity = false;
	mail.setWhatId(p.Id);
	emailMessageList.add(mail);
	}
	//send the email with appropriate template to the person
	Messaging.sendEmail(emailMessageList);
	return true;
	}
	}

view raw SendEmailHandler hosted with ❤ by GitHub

2) Created a List View button named "Send Email" on your custom object with content source as "onclick Javascript" option

3) Below is the Javascript code for the button. (Note:- In my case I used "Person_Detail__c" as custom object. You need to use your custom object instead of "Person_Detail__c")

	{!REQUIRESCRIPT("/soap/ajax/19.0/connection.js")}
	{!REQUIRESCRIPT("/soap/ajax/19.0/apex.js")}
	{!REQUIRESCRIPT('//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js')}
	{!REQUIRESCRIPT('//ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js')}
	function appendTags(){
	if(jQuery('[id=start-theme-css]').length==0){
	jQuery('head').append(
	'<link ' +
	'id="start-theme-css"' +
	'rel="stylesheet"' +
	'href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/start/jquery-ui.min.css"' +
	'type="text/css" />'
	);
	jQuery('body').append(
	'<div id="dialog-confirm" title="Send Mass Email">' +
	'<p style="text-align:justify">' +
	'<img src="/s.gif" alt="Contact" class="pageTitleIcon" title="Contact" style="margin: 0 7px 30px 0"/>' +
	'Please select an email template to use.' +
	'<br/><br/>Email Template:<br/>' +
	'<select id="email-template" style="width:380px"></select>' +
	'</p>' +
	'</div>'
	);
	}
	}
	function createPopupWindow(){
	jQuery(function() {
	jQuery( "#dialog-confirm" ).dialog({
	resizable: false,
	width: 400,
	modal: true,
	show: {
	effect: "fade",
	duration: 500
	},
	hide: {
	effect: "fade",
	duration: 500
	},
	buttons: {
	"Send Mail":
	function() {
	sendMail();
	},
	Cancel:
	function() {
	jQuery( this ).dialog( "close" );
	}
	}
	});
	});
	}
	function fetchEmailTemplates(){
	var emailTemplates =
	sforce.connection.query(
	'SELECT Id, Name FROM EmailTemplate',
	{
	onSuccess:
	function(result){
	var records = result.getArray('records');
	var innerHtml = '<option value="">--Select--</option>';
	for(var i=0; i<records.length; i++)
	innerHtml +=
	'<option value="' + records[i].Id + '">' +
	records[i].Name +
	'</option>';
	jQuery('[id=email-template]').html(innerHtml);
	},
	onFailure:
	function(error){
	alert('An Error has Occurred. Error: ' + error);
	}
	}
	);
	}
	function sendMail(){
	var perIds = {!GETRECORDIDS( $ObjectType.Person_Details__c)};
	var templId = jQuery('[id=email-template]').val();
	var flag = sforce.apex.execute("SendEmailHandler", "sendEmail", {personIds:perIds,templateId:templId});
	if(flag)
	{
	jQuery("#dialog-confirm").dialog( "close" );
	alert('Your emails have been sent successfully');
	}
	}
	appendTags();
	fetchEmailTemplates();
	createPopupWindow();

view raw Send Mass Email hosted with ❤ by GitHub

That's it, now click on the "Send Email" button and send cool template emails to your recepients..