konaguru – Page 2

Do it with SOQL

October 19, 2018October 24, 2018 konaguru Leave a comment

Deleting User Trace Logs

If you go to User Debug Log, you may see many user trace logs created by a user. Deleting one at a time is time-consuming. An easy solution is to execute below SOQL in Developer console and deleting them ( you can select multiple rows and can delete in one shot )

SELECT Id, CreatedDate, CreatedById, ExpirationDate, TracedEntityId, ApexCode, 
ApexProfiling, Callout, Database, System, Validation, Visualforce, Workflow 
FROM TraceFlag

SELECT Id, CreatedDate, CreatedById, ExpirationDate, TracedEntityId, ApexCode,

ApexProfiling, Callout, Database, System, Validation, Visualforce, Workflow

FROM TraceFlag

Mass Delete Attachments

Though Data loader is one option to do it, you can also use Developer console Query editor to mass delete attachments ( execute the query with appropriate constraints and select the rows you want to delete and hit delete button )

select id from Attachment limit 10

1	select id from Attachment limit 10

Bulk Delete ApexLogs

Its very painful to use Salesforce provided ‘Delete All’ logs button as it on;t deletes log files displayed in that page. Quick way of deleting log files using SOQL is executing below SOQL in developer console and use ‘Delete’ button

select id from ApexLog

1	select id from ApexLog

Salesforce Certified Identity and Access Management – Spring ’18 Release Exam

July 31, 2018July 31, 2018 konaguru Leave a comment

An administrator resets a user password in Salesforce.

Which attribute will be updated with the “True” value in the Identity URL or UserInfo endpoint?

A.		email_verified
B.		password_updated
C.		password_reset
D.		active

Universal Containers (UC) uses Salesforce for all of its internal users. Recently UC started getting a lot of complaints from users regarding locked user accounts due to users not being able to reset their passwords.

What is the recommended solution a Salesforce adminisrator can follow to solve this problem?

A.		Implement a third-party Identity Provider to centralize user management and authentication policies.
B.		Modify password policies and set Password Expires to “Never Expires” so that users can log in without any interruption.
C.		Configure social media authentication provider to allow users to log in via their social media credentials.
D.		Enable two-factor authentication using Lightning Login to allow users to log in without their passwords.

Universal Containers uses Customer Community for its customers and wants to make sure that there is an extra layer of security to avoid unauthorized access.

What is the recommended way of enabling two-factor authentication for external users?

A.		Update external user profile to allow users to verify their identity and avoid unauthorized access.
B.		Use an AppExchange application to implement two-factor authentication for external users.
C.		Use dynamic login on the customer community to allow customers to verify their identity.
D.		Use custom login flows to implement two-factor authentication for external users.

Universal Containers (UC) uses an external website to allow its customers to perform self-service functions. The website doesn’t support autentication through SAML or OpenID Connect. UC has decided to impement Salesforce and authenticate its users via Salesforce.

What is the recommended solution to allow users to authenticate via Salesforce on the external website?

A.		Configure a connected app in Salesforce and use username-password flow to allow customer to authenticate on the website.
B.		Configure Salesforce as a Service Provider, and implement custom federation services using existing Identity Store.
C.		Configure Customer Community identity providers, and use Embedded Login to allow customers to authenticate on the website using configured identity providers.
D.		Migrate the website to Customer Community to allow a seamless experience and set existing passwords as their customer community user passwords.

Universal Containers (UC) uses Customer Community to allow its customers to register and perform self-service functions. Due to the growth of the business and the customer base, UC wants to deliver a different experience to its customers based on runtime circumstances.

What is the secure and recommended way of enabling this?

A.		Develop Lightning components to deliver different experience to customers using their information stored in Salesforce.
B.		Use custom login flows to deliver different experiences by extracting the source from the URL where the customer is visiting from.
C.		Use an AppExchange product to customize the Customer Community login experience and deliver a personalized experience to customers
D.		Enable dynamic login experience by adding expid request parameter in the client configuraiton SSO initialization URL.

Best Salesforce tools

April 8, 2018October 20, 2018 konaguru Leave a comment

SOQL Query Builder

SQOL Builder tool built by Jitedra Zaa helps you to get to the place where you can generate your queries, execute your queries in a jiffy

https://soqlbuilder.herokuapp.com/

How to create and insert data into Big Objects

February 14, 2018March 3, 2018 konaguru Leave a comment

Use Case:

Company A stores credit card transaction data in Salesforce. Data is stored as Person Accounts all the transaction data is stored in the person account. Number of transactions can grow to more than 10 million to 100 million depends upon the member base of the Company A

Solution:

Say for instance we are interested in

Capturing transaction data under person account
Processing transaction data for further processing ( like the redemption of the user acquired commissions )
Letting Customer support team filter the transaction data
Running reports on transaction data

Why can’t we use Salesforce provided Big Objects to attain above functionality. Wait.. before we design the solution let’s understand the Big Object limitations

You can’t create Big Objects using Salesforce Setup, instead use Salesforce Metadata API to create these objects
No triggers can be implemented on Big Objects
No Page Layouts
Querying data using SOQL is comes with limitation, you can query data on Index fields
You can’t design Workflows, Process Builders etc
You can’t run reports on the Transaction data

Instead of looking into the negativities of the Big Objects I looked into the beauty that can bring with these limitations. I trust Salesforce Architect team designed few of these limitations on purpose due to its multi-tenant architecture. Designing triggers, querying data on non-index fields, running reports , designing workflows, process builders all have a risk when not properly handled by an architect/developer when doing things.

Creating Big Object

Field Name	Type	Length	Index
Transaction Date	Date		Index
Transaction Amount	Number	5,2
Merchant Name	Text	50	Index
Transaction Location	Text	25
CustomerId	Lookup(Account)

Big Object can’t be created from Salesforce setup. In order to create Big Object you have to use Salesforce Metadata API. Let’s create a package and deploy to Salesforce using workbench.

Create file : Customer_Transaction__B.object

<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
   <deploymentStatus>Deployed</deploymentStatus>
   <fields>
      <fullName>Transaction_No__c</fullName>
      <label>Transaction No</label>
      <length>9</length>
      <required>true</required>
      <type>Text</type>
   </fields>
   <fields>
      <fullName>Transaction_Date__c</fullName>
      <label>Transaction Date</label>
      <required>true</required>
      <type>DateTime</type>
   </fields>
   <fields>
      <fullName>Transaction_Amount__c</fullName>
      <label>Transaction Amount</label>
      <scale>9</scale>
      <precision>11</precision>
      <required>false</required>
      <type>Number</type>
   </fields>
   <fields>
      <fullName>Merchant_Name__c</fullName>
      <label>Merchant Name</label>
      <length>30</length>
      <required>false</required>
      <type>Text</type>
   </fields>
   <indexes>
      <type>PRIMARY</type>
      <fullName>Transaction_No_idx_c</fullName>
      <fields>
         <name>Transaction_No__c</name>
         <sortDirection>DESC</sortDirection>
      </fields>
<fields>
         <name>Transaction_Date__c</name>
         <sortDirection>DESC</sortDirection>
      </fields>
   </indexes>
   <label>Transaction</label>
   <pluralLabel>Transactions</pluralLabel>
</CustomObject>

<deploymentStatus>Deployed</deploymentStatus>

<fullName>Transaction_No__c</fullName>

<label>Transaction No</label>

</fields>

<fullName>Transaction_Date__c</fullName>

<label>Transaction Date</label>

<type>DateTime</type>

</fields>

<fullName>Transaction_Amount__c</fullName>

<label>Transaction Amount</label>

<required>false</required>

<type>Number</type>

</fields>

<fullName>Merchant_Name__c</fullName>

<label>Merchant Name</label>

<required>false</required>

</fields>

<type>PRIMARY</type>

<fullName>Transaction_No_idx_c</fullName>

<name>Transaction_No__c</name>

</fields>

<name>Transaction_Date__c</name>

</fields>

</indexes>

<label>Transaction</label>

<pluralLabel>Transactions</pluralLabel>

</CustomObject>

Step #2 : Create Permission set

Customer_Transaction.permissionset

<PermissionSet xmlns="http://soap.sforce.com/2006/04/metadata">
<description>Transaction Big Object PermissionSet</description>
<hasActivationRequired>false</hasActivationRequired>
<label>Transaction Big Object PermissionSet</label>
<fieldPermissions>
  <editable>true</editable>
  <field>Customer_Transaction__b.Transaction_Amount__c</field>
  <readable>true</readable>
</fieldPermissions>
<fieldPermissions>
  <editable>true</editable>
  <field>Customer_Transaction__b.Merchant_Name__c</field>
  <readable>true</readable>
</fieldPermissions>
</PermissionSet>

<description>Transaction Big Object PermissionSet</description>

<hasActivationRequired>false</hasActivationRequired>

<label>Transaction Big Object PermissionSet</label>

<field>Customer_Transaction__b.Transaction_Amount__c</field>

</fieldPermissions>

<field>Customer_Transaction__b.Merchant_Name__c</field>

</fieldPermissions>

</PermissionSet>

Step #3 : Create Package.xml file

<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
 <members>*</members>
 <name>CustomObject</name>
</types>
<types>
 <members>*</members>
 <name>PermissionSet</name>
</types>
<version>40.0</version>
</Package>

<types>

<name>CustomObject</name>

</types>

<types>

<name>PermissionSet</name>

</types>

</Package>

Step #4 : Create zip file for deployment

Customer_Transaction__B.object, package.xml, Customer_Transaction.permissionset

Download zip file customer_transaction

Step #5: use workbench to deploy the code

Upload zip file and click Next , follow the instruction to deploy the code

Step #6 : Use Bulk Api Java Code for data Migration into Big Object

/* Author : Rangesh Kona
*/
import java.io.*;
import java.util.*;

import com.sforce.async.*;
import com.sforce.soap.partner.PartnerConnection;
import com.sforce.ws.ConnectionException;
import com.sforce.ws.ConnectorConfig;


public class BulkLoadBigObject {

   public static void main(String[] args) throws AsyncApiException, ConnectionException, IOException {

	BulkLoadBigObject bo = new BulkLoadBigObject();
	bo.createRecords("RK_CLOUD__Customer_Interaction__b", "rangeshsecure@gmail.com","Ritman$1234", "customerInteraction.csv");
   }

   public void createRecords(String sobjectType, String userName, String password, String sampleFileName) 
		throws ConnectionException, IOException, AsyncApiException { 
	
	// get SFDC connection using partner WSDL 
	BulkConnection 		connection  = getBulkConnection(userName, password);

	// Create Job
	JobInfo 		job = createJob(sobjectType, connection);


	// Create Batch
	BatchInfo 		batchInfo  = createBatchFromCSVFile(connection, job, sampleFileName);
	
	// Close Job
 	closeJob(connection, job.getId());	
	
	// Await Completion
	awaitCompletion(connection, job, batchInfo); 

	// Check Results
	checkResults(connection, job, batchInfo);
   }



	private void checkResults(BulkConnection connection, JobInfo job,
                                BatchInfo batchInfo)
                throws AsyncApiException, IOException {
                CSVReader rdr = new CSVReader(connection.getBatchResultStream (job.getId(), batchInfo.getId()));
                List<String> resultHeader = rdr.nextRecord();
                int resultCols = resultHeader.size();
                List<String> row;

                while((row = rdr.nextRecord()) != null) {
                   Map<String, String> resultInfo = new HashMap<String, String>();
                   for(int i = 0; i<resultCols;i++) {
                      resultInfo.put(resultHeader.get(i), row.get(i));
                }
                boolean success = Boolean.valueOf(resultInfo.get("Success"));
                boolean created = Boolean.valueOf(resultInfo.get("Created"));
                String id = resultInfo.get("Id");
                String error = resultInfo.get("Error");
                if (success && created ) {
                   System.out.println("Created row with id " + id );
                }
                else if (!success) {
                   System.out.println("Failed with error: " + error);
                }
                }
          }


  private void awaitCompletion(BulkConnection connection, JobInfo job, BatchInfo batchInfo) throws AsyncApiException {

	long sleepTime = 0L;
	Set<String> incomplete = new HashSet<String>();
	incomplete.add(batchInfo.getId());
	while (!incomplete.isEmpty()) {
	   try {
	      Thread.sleep(sleepTime);
	   }
	   catch(InterruptedException e) {}
	   System.out.println("Awaiting results...." + incomplete.size());
	   sleepTime = 10000L;
	   BatchInfo[] statusList = connection.getBatchInfoList(job.getId()).getBatchInfo();
	   for(BatchInfo b : statusList) {
		if(b.getState() == BatchStateEnum.Completed || b.getState() == BatchStateEnum.Failed) {
		   if (incomplete.remove(b.getId())) {
                       System.out.println("Batch Status : \n" + b);
                   }
		}	
           }

	}
  } 
 

  private void closeJob(BulkConnection connection, String jobId) throws AsyncApiException {
	JobInfo job = new JobInfo();
	job.setId(jobId);
	job.setState(JobStateEnum.Closed);
	connection.updateJob(job);
  }



  private BatchInfo createBatchFromCSVFile(BulkConnection connection, JobInfo jobInfo, String sampleFileName) throws IOException, AsyncApiException {


	FileInputStream tmpInputStream	= new FileInputStream(sampleFileName);
 
	BatchInfo batchInfo;

	try {
	    batchInfo = connection.createBatchFromStream(jobInfo, tmpInputStream);
	    System.out.println("Batch Info " + batchInfo);
	}
	finally {
	    tmpInputStream.close();
	}
	return batchInfo;
  }

   private JobInfo createJob(String sobjectType, BulkConnection connection) throws AsyncApiException {

	JobInfo job = new JobInfo();
	job.setObject(sobjectType);
	job.setOperation(OperationEnum.insert);
	job.setContentType(ContentType.CSV);
	job = connection.createJob(job);
	System.out.println("Created Job " + job );
	return job;

   }

   private BulkConnection getBulkConnection(String userName, String password) throws ConnectionException, AsyncApiException {

   	ConnectorConfig partnerConfig = new ConnectorConfig();
	partnerConfig.setUsername(userName);
	partnerConfig.setPassword(password);
	partnerConfig.setAuthEndpoint("https://rangesh-dev-ed.my.salesforce.com/services/Soap/u/41.0");
	new PartnerConnection(partnerConfig);
	ConnectorConfig config = new ConnectorConfig();
	config.setSessionId(partnerConfig.getSessionId());
	String soapEndpoint	= partnerConfig.getServiceEndpoint();
	String apiVersion	= "41.0";
	String restEndpoint    = soapEndpoint.substring(0, soapEndpoint.indexOf("Soap/")) + "async/" + apiVersion;
	config.setRestEndpoint(restEndpoint);
	config.setCompression(true);
	config.setTraceMessage(false);
	BulkConnection connection = new BulkConnection(config);
	return connection;
	
   }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

/* Author : Rangesh Kona

import java.io.*;

import java.util.*;

import com.sforce.async.*;

import com.sforce.soap.partner.PartnerConnection;

import com.sforce.ws.ConnectionException;

import com.sforce.ws.ConnectorConfig;

public class BulkLoadBigObject {

public static void main(String[] args) throws AsyncApiException, ConnectionException, IOException {

BulkLoadBigObject bo = new BulkLoadBigObject();

bo.createRecords("RK_CLOUD__Customer_Interaction__b", "rangeshsecure@gmail.com","Ritman$1234", "customerInteraction.csv");

}

public void createRecords(String sobjectType, String userName, String password, String sampleFileName)

throws ConnectionException, IOException, AsyncApiException {

// get SFDC connection using partner WSDL

BulkConnection connection = getBulkConnection(userName, password);

// Create Job

JobInfo job = createJob(sobjectType, connection);

// Create Batch

BatchInfo batchInfo = createBatchFromCSVFile(connection, job, sampleFileName);

// Close Job

closeJob(connection, job.getId());

// Await Completion

awaitCompletion(connection, job, batchInfo);

// Check Results

checkResults(connection, job, batchInfo);

}

private void checkResults(BulkConnection connection, JobInfo job,

BatchInfo batchInfo)

throws AsyncApiException, IOException {

CSVReader rdr = new CSVReader(connection.getBatchResultStream (job.getId(), batchInfo.getId()));

List<String> resultHeader = rdr.nextRecord();

int resultCols = resultHeader.size();

List<String> row;

while((row = rdr.nextRecord()) != null) {

Map<String, String> resultInfo = new HashMap<String, String>();

for(int i = 0; i<resultCols;i++) {

resultInfo.put(resultHeader.get(i), row.get(i));

}

boolean success = Boolean.valueOf(resultInfo.get("Success"));

boolean created = Boolean.valueOf(resultInfo.get("Created"));

String id = resultInfo.get("Id");

String error = resultInfo.get("Error");

if (success && created ) {

System.out.println("Created row with id " + id );

}

else if (!success) {

System.out.println("Failed with error: " + error);

}

private void awaitCompletion(BulkConnection connection, JobInfo job, BatchInfo batchInfo) throws AsyncApiException {

long sleepTime = 0L;

Set<String> incomplete = new HashSet<String>();

incomplete.add(batchInfo.getId());

while (!incomplete.isEmpty()) {

try {

Thread.sleep(sleepTime);

}

catch(InterruptedException e) {}

System.out.println("Awaiting results...." + incomplete.size());

sleepTime = 10000L;

BatchInfo[] statusList = connection.getBatchInfoList(job.getId()).getBatchInfo();

for(BatchInfo b : statusList) {

if(b.getState() == BatchStateEnum.Completed || b.getState() == BatchStateEnum.Failed) {

if (incomplete.remove(b.getId())) {

System.out.println("Batch Status : \n" + b);

}

private void closeJob(BulkConnection connection, String jobId) throws AsyncApiException {

JobInfo job = new JobInfo();

job.setId(jobId);

job.setState(JobStateEnum.Closed);

connection.updateJob(job);

}

private BatchInfo createBatchFromCSVFile(BulkConnection connection, JobInfo jobInfo, String sampleFileName) throws IOException, AsyncApiException {

FileInputStream tmpInputStream = new FileInputStream(sampleFileName);

BatchInfo batchInfo;

try {

batchInfo = connection.createBatchFromStream(jobInfo, tmpInputStream);

System.out.println("Batch Info " + batchInfo);

}

finally {

tmpInputStream.close();

}

return batchInfo;

}

private JobInfo createJob(String sobjectType, BulkConnection connection) throws AsyncApiException {

JobInfo job = new JobInfo();

job.setObject(sobjectType);

job.setOperation(OperationEnum.insert);

job.setContentType(ContentType.CSV);

job = connection.createJob(job);

System.out.println("Created Job " + job );

return job;

}

private BulkConnection getBulkConnection(String userName, String password) throws ConnectionException, AsyncApiException {

ConnectorConfig partnerConfig = new ConnectorConfig();

partnerConfig.setUsername(userName);

partnerConfig.setPassword(password);

partnerConfig.setAuthEndpoint("https://rangesh-dev-ed.my.salesforce.com/services/Soap/u/41.0");

new PartnerConnection(partnerConfig);

ConnectorConfig config = new ConnectorConfig();

config.setSessionId(partnerConfig.getSessionId());

String soapEndpoint = partnerConfig.getServiceEndpoint();

String apiVersion = "41.0";

String restEndpoint = soapEndpoint.substring(0, soapEndpoint.indexOf("Soap/")) + "async/" + apiVersion;

config.setRestEndpoint(restEndpoint);

config.setCompression(true);

config.setTraceMessage(false);

BulkConnection connection = new BulkConnection(config);

return connection;

}

Poovar islands , Kerala

February 5, 2018February 5, 2018 konaguru Leave a comment

Poovar islands

Heroku postgres Integration with Force.com

February 5, 2018February 5, 2018 konaguru Leave a comment

Go to heroku Dashboard

Click ‘New’ to create Application

Create App

Enter App name: sfdc-heroku-integration

click ‘Create app’ button to continue

Click on App icon and select Elements

Select Heroku Postgres on the Heroku Elements page

Click on ‘Install Heroku Postgres’ and continue

Select your app name to install Postgres

select the free version and click on Provision button

You will landup on the below page after successfully installing Postgres on the Heroku platform

Installing Heroku Connect

Heroku connect helps you to synchronize data to Salesforce

Select app name to install Heroku Connect, in our case app name is sfdc-heroku-integration

Click on Provision button to continue

After successful installation, you will be landed on to the below page

Configuring Heroku Connect to Sync data from Salesforce

Click on Heroku Connect from Dashboard->App->Resources section

Click ‘Setup Connection’

Enter schema name and click Next

Click ‘Authorize’ and continue

Select your Salesforce org to install, After successful installatoin, you will see below screen

Synchronize Salesforce object data into Heroku Postgres

Click ‘Create Mapping’

select Objects you want to synchronize

Select Object Fields you want to Synchronize, you can also set Poll Frequency ( minimum poll frequency set at 10 minutes )

After you complete the setup you will see below screen. We can clearly see number of fields, number of records that are inserted into Postgres DB

Salesforce to Salesforce Integration using REST Webservice

February 2, 2018February 4, 2018 konaguru Leave a comment

Use Case:

An organization has two salesforce org ( Sales Org and R&D Org ). Sales Org user wants to create a support request in R&D org for a Sales Org opportunity. R&D org team has special skills to work on those Support Requests. Sales Org user is willing to share some of the opportunity field data and restrict sharing access to only for the opportunities that have Support Requests. Sales Org User is also interested to know the status and owner of the Support Request. R&D Org users should be able to run reports on Case/Support Request/Opportunity(Sales Org) data

Solution:

Providing a button on Opportunity UI to create a support request. Invoking a Visualforce page and using a controller class system can call Webservice on R&D Org to create a Case. Whenever a Support Request is created checkbox is updated in opportunity object, based on the checkbox opportunity information is shared with an integration user. Salesforce lightning connect is used to integrate Sales Org & R-&-D org. Check out my blog post on lightning connect. R&D Org can call webservice on Sales Org to update Support Request Owner and Status details in Sales Org system.

Implementation:

Below flow gives a top view of how the integration/data flow between the systems.

Step #1: Authentication

Sales Org calls Webservice on R&D Org

R&D Org authenticates Sales Org call

R&D lets Sales Org create Case after authentication

Salesforce configuration details:

Configure Connected App in R&D Org

Configure Authentical Provider in Sales Org

Configure Named Credentials in Sales Org

Use Named Credentials in Webservice Callout script

Follow blog post ‘How to configure Named Credentials‘

Step #2: Creating Webservice on R&D Org

@RestResource(urlMapping='/CaseSupportRequest/*')
global with sharing class CreateSalesSupportRequest {

    @HttpPost
    global static ID createCase() {
        
        String subject;
        String status;
        String origin;
        String priority;
        String Opportunity;
        String Service_Request_Type;
        Integer CPU_Count;
        String Support_Request;
        
        String jsonString = RestContext.request.requestBody.toString();
        JSonParser parser = JSON.createParser(jsonString);
        while (parser.nextToken() != null) {
            if (parser.getCurrentToken() == JSONToken.START_ARRAY)  {
                while(parser.nextToken() != null ) {
                    if (parser.getCurrentToken() == JSONToken.START_OBJECT) {
						caseobj co 				= 	(caseobj) parser.readValueAs(caseobj.class);
                        subject					=	co.Subject;
                        Opportunity				=	co.Opportunity;
                        Service_Request_Type  	= co.Service_Request_Type;
                        CPU_Count 				= co.CPU_Count;
                        Support_Request 		= co.Support_Request;
                        
                    }
                }
            }
              
        }
        
        System.debug('subject ' + subject);
        System.debug('Status ' + Status);
        Case thisCase = new Case(Subject=subject, Status='New', Origin='Email', Priority='Important',SMG_Opportunity__c=Opportunity, Service_Request_Type__c=Service_Request_Type,CPU_Count__C=CPU_Count,Support_Request__C=Support_Request  );
        insert thisCase;
        return thisCase.Id;
    }
    
       


public class caseobj {
        public String Subject;
        public String Opportunity;
        public String Service_Request_Type;
        public Integer CPU_Count;
    	public String Support_Request;
   
        public caseobj (String subject, String Opportunity, String Service_Request_Type, Integer CPU_Count, String Support_Request) {
            Subject 				= this.subject;
            Opportunity  			= this.Opportunity;
            Service_Request_Type  	= this.Service_Request_Type;
            CPU_Count 				= this.CPU_Count;
            Support_Request 		= this.Support_Request;
        }
    }
    
}

@RestResource(urlMapping='/CaseSupportRequest/*')

global with sharing class CreateSalesSupportRequest {

@HttpPost

global static ID createCase() {

String subject;

String status;

String origin;

String priority;

String Opportunity;

String Service_Request_Type;

Integer CPU_Count;

String Support_Request;

String jsonString = RestContext.request.requestBody.toString();

JSonParser parser = JSON.createParser(jsonString);

while (parser.nextToken() != null) {

if (parser.getCurrentToken() == JSONToken.START_ARRAY) {

while(parser.nextToken() != null ) {

if (parser.getCurrentToken() == JSONToken.START_OBJECT) {

caseobj co = (caseobj) parser.readValueAs(caseobj.class);

subject = co.Subject;

Opportunity = co.Opportunity;

Service_Request_Type = co.Service_Request_Type;

CPU_Count = co.CPU_Count;

Support_Request = co.Support_Request;

}

System.debug('subject ' + subject);

System.debug('Status ' + Status);

Case thisCase = new Case(Subject=subject, Status='New', Origin='Email', Priority='Important',SMG_Opportunity__c=Opportunity, Service_Request_Type__c=Service_Request_Type,CPU_Count__C=CPU_Count,Support_Request__C=Support_Request );

insert thisCase;

return thisCase.Id;

}

public class caseobj {

public String Subject;

public String Opportunity;

public String Service_Request_Type;

public Integer CPU_Count;

public String Support_Request;

public caseobj (String subject, String Opportunity, String Service_Request_Type, Integer CPU_Count, String Support_Request) {

Subject = this.subject;

Opportunity = this.Opportunity;

Service_Request_Type = this.Service_Request_Type;

CPU_Count = this.CPU_Count;

Support_Request = this.Support_Request;

}

Step #3: Controller class to create call R&D Webservice from Sales Org

public class CreateSSRController {
    
    public String Subject{get;set;}
    public String created_record_id{get;set;}
    public String opportunity_id {get;set;}
    public String opportunity_name {get;set;}
    
    public String description{get;set;}
    public String Service_Request_Type{get;set;}
    public Date Deadline{get;set;}
    
    public Integer CPU_Count{get;set;}
    public ID support_request_id{get;set;}
    
    public void create_SSR_in_DRD() {
               
         // Id support_record_id = Insert_Support_Request_Record();
        
        HttpRequest request = new HttpRequest();
        request.setEndpoint('callout:DRDConnect/services/apexrest/CaseSupportRequest/');
        request.setMethod('POST');
        request.setHeader('Content-Type', 'application/json;charset=UTF-8');
        String json_string = '{"caseobj":[ {"Support_Request":"' + support_request_id + '" , "Subject": "' + description + '", "Service_Request_Type": "' + Service_Request_Type + '", "Opportunity": "' + opportunity_id + '", "CPU_Count": '+ CPU_Count + '}]}'; 
        request.setBody(json_string);
        
        Http http = new Http();
        HTTPResponse response = http.send(request);
        System.debug(response.getBody());
 
        created_record_id = response.getBody();
        created_record_id =  created_record_id.removeStart('"');
        created_record_id =  created_record_id.removeEnd('"');
        
        System.debug('Record ID ' + created_record_id + ' ' );
        
    }
    
    public PageReference  Insert_Support_Request_Record() {
        
        Support_Request__c support_request_record = new Support_Request__c(Description__C=description,Opportunity__c=opportunity_id, Service_Request_Type__C=Service_Request_Type, CPU_Count__C=CPU_Count, DRD_Case__c=created_record_id);
        insert support_request_record;
        support_request_id = support_request_record.ID;
        
        return null;        
        
    }
    
    
    public CreateSSRController() {
        
        opportunity_id = ApexPages.currentPage().getParameters().get('id');
        if(opportunity_id == null) {
            opportunity_id = '0066A000002ZgZ2';
        }
        Opportunity opty = [select Id, name, account.Name  from Opportunity where Id = :opportunity_id];
        opportunity_name = opty.Name;
        opportunity_id = opty.Id;
        
    }
    
    // display picklist value in VF Page
    public List<SelectOption> getService_Request_Type_Picklist_Values()
    {
        List<SelectOption> options = new List<SelectOption>();
        
        Schema.DescribeFieldResult fieldResult =
            Support_Request__c.Service_Request_Type__c.getDescribe();
        List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
        
        for( Schema.PicklistEntry f : ple)
        {
            options.add(new SelectOption(f.getLabel(), f.getValue()));
        }       
        return options;
    }
    
}

public class CreateSSRController {

public String Subject{get;set;}

public String created_record_id{get;set;}

public String opportunity_id {get;set;}

public String opportunity_name {get;set;}

public String description{get;set;}

public String Service_Request_Type{get;set;}

public Date Deadline{get;set;}

public Integer CPU_Count{get;set;}

public ID support_request_id{get;set;}

public void create_SSR_in_DRD() {

// Id support_record_id = Insert_Support_Request_Record();

HttpRequest request = new HttpRequest();

request.setEndpoint('callout:DRDConnect/services/apexrest/CaseSupportRequest/');

request.setMethod('POST');

request.setHeader('Content-Type', 'application/json;charset=UTF-8');

String json_string = '{"caseobj":[ {"Support_Request":"' + support_request_id + '" , "Subject": "' + description + '", "Service_Request_Type": "' + Service_Request_Type + '", "Opportunity": "' + opportunity_id + '", "CPU_Count": '+ CPU_Count + '}]}';

request.setBody(json_string);

Http http = new Http();

HTTPResponse response = http.send(request);

System.debug(response.getBody());

created_record_id = response.getBody();

created_record_id = created_record_id.removeStart('"');

created_record_id = created_record_id.removeEnd('"');

System.debug('Record ID ' + created_record_id + ' ' );

}

public PageReference Insert_Support_Request_Record() {

Support_Request__c support_request_record = new Support_Request__c(Description__C=description,Opportunity__c=opportunity_id, Service_Request_Type__C=Service_Request_Type, CPU_Count__C=CPU_Count, DRD_Case__c=created_record_id);

insert support_request_record;

support_request_id = support_request_record.ID;

return null;

}

public CreateSSRController() {

opportunity_id = ApexPages.currentPage().getParameters().get('id');

if(opportunity_id == null) {

opportunity_id = '0066A000002ZgZ2';

}

Opportunity opty = [select Id, name, account.Name from Opportunity where Id = :opportunity_id];

opportunity_name = opty.Name;

opportunity_id = opty.Id;

}

// display picklist value in VF Page

public List<SelectOption> getService_Request_Type_Picklist_Values()

{

List<SelectOption> options = new List<SelectOption>();

Schema.DescribeFieldResult fieldResult =

Support_Request__c.Service_Request_Type__c.getDescribe();

List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();

for( Schema.PicklistEntry f : ple)

{

options.add(new SelectOption(f.getLabel(), f.getValue()));

}

return options;

}

Step #4: VF Page to create Support Request

<apex:page controller="CreateSSRController" id="createssrpage" >
    <script>
    jQuery(function() {
        jQuery("[id='{!$Component.datepicker}']").datepicker();
    });
    </script>
    <apex:form id="createssrform">
        <apex:pageBlock title="Create Sales Support Request" >
            <apex:Messages ></apex:Messages>
            <apex:pageBlockSection columns="1" >
                
                <apex:pageBlockSectionItem >
                    <apex:outputLabel value="Opportunity Name"></apex:outputLabel>
                    <apex:outputText value="{!opportunity_name}"></apex:outputText>
                 </apex:pageBlockSectionItem>
                
                <apex:pageBlockSectionItem >
                    <apex:outputLabel value="Service Request Type"></apex:outputLabel>
                    <apex:selectList id="countries" value="{!Service_Request_Type}" size="1" required="true">
                        <apex:selectOptions value="{!Service_Request_Type_Picklist_Values}"/>
                    </apex:selectList>
                </apex:pageBlockSectionItem>
                
                <apex:pageBlockSectionItem >
                    <apex:outputLabel value="CPU Count"></apex:outputLabel>
                    <apex:inputText value="{!CPU_Count}"></apex:inputText> 
                </apex:pageBlockSectionItem>
                
              <apex:pageBlockSectionItem >
                    <apex:outputLabel value="Description"></apex:outputLabel>
                    <apex:inputTextarea rows="10" cols="100" value="{!description}" id="description" label="description" />
                </apex:pageBlockSectionItem>
           </apex:pageBlockSection>
            
            <apex:outputPanel id="msg">
                <apex:pageMessages />
            </apex:outputPanel>
            
            <apex:actionFunction action="{!Insert_Support_Request_Record}" name="InsertRecord_JS" Rerender="statuses" status="Status1" oncomplete="CallWebService_JS();"/>
            <apex:actionFunction action="{!create_SSR_in_DRD}" name="CallWebService_JS" status="Status2" reRender="statuses, msg"/>
            <apex:outputPanel id="statuses">
                <apex:actionStatus id="Status1" startText="...Inserting Record Into DB..." />
                <apex:actionStatus id="Status2" startText="...Calling Web Service..." />
            </apex:outputPanel>
            
            <div><input name="DoAction" class="btn" type="button" value="Create DRD Request" onclick="InsertRecord_JS();return false;"/></div>
           <apex:outputText value="{!created_record_id}"></apex:outputText>
            
            
            
        </apex:pageBlock>
    </apex:form>
</apex:page>

<apex:page controller="CreateSSRController" id="createssrpage" >

jQuery(function() {

jQuery("[id='{!$Component.datepicker}']").datepicker();

});

</script>

<apex:form id="createssrform">

<apex:pageBlock title="Create Sales Support Request" >

<apex:Messages ></apex:Messages>

<apex:pageBlockSection columns="1" >

<apex:pageBlockSectionItem >

<apex:outputLabel value="Opportunity Name"></apex:outputLabel>

<apex:outputText value="{!opportunity_name}"></apex:outputText>

</apex:pageBlockSectionItem>

<apex:pageBlockSectionItem >

<apex:outputLabel value="Service Request Type"></apex:outputLabel>

<apex:selectList id="countries" value="{!Service_Request_Type}" size="1" required="true">

<apex:selectOptions value="{!Service_Request_Type_Picklist_Values}"/>

</apex:selectList>

</apex:pageBlockSectionItem>

<apex:pageBlockSectionItem >

<apex:outputLabel value="CPU Count"></apex:outputLabel>

<apex:inputText value="{!CPU_Count}"></apex:inputText>

</apex:pageBlockSectionItem>

<apex:pageBlockSectionItem >

<apex:outputLabel value="Description"></apex:outputLabel>

<apex:inputTextarea rows="10" cols="100" value="{!description}" id="description" label="description" />

</apex:pageBlockSectionItem>

</apex:pageBlockSection>

<apex:outputPanel id="msg">

<apex:pageMessages />

</apex:outputPanel>

<apex:actionFunction action="{!Insert_Support_Request_Record}" name="InsertRecord_JS" Rerender="statuses" status="Status1" oncomplete="CallWebService_JS();"/>

<apex:actionFunction action="{!create_SSR_in_DRD}" name="CallWebService_JS" status="Status2" reRender="statuses, msg"/>

<apex:outputPanel id="statuses">

<apex:actionStatus id="Status1" startText="...Inserting Record Into DB..." />

<apex:actionStatus id="Status2" startText="...Calling Web Service..." />

</apex:outputPanel>

<apex:outputText value="{!created_record_id}"></apex:outputText>

</apex:pageBlock>

</apex:form>

</apex:page>

Step #5 : Create Support Request button configuration on Opportunity Page

go to Setup->Opportunity->Buttons to create Button

Step : #6: Add button to Layout

Sample @future code – ready to process when resources are available

February 2, 2018February 2, 2018 konaguru Leave a comment

public class AccountProcessor {
        
 	@future
        public static void countContacts(Set setId) {
            
            List lstAccount = [select id, Number_of_Contacts__C, (select id from contacts) from account where id in :setId ];
            
            for (Account acc: lstAccount) {
                
                List lstCon = acc.contacts;
                acc.Number_of_contacts__C = lstCon.size();
                
            }
            update lstAccount;
        }
}

public class AccountProcessor {

@future

public static void countContacts(Set setId) {

List lstAccount = [select id, Number_of_Contacts__C, (select id from contacts) from account where id in :setId ];

for (Account acc: lstAccount) {

List lstCon = acc.contacts;

acc.Number_of_contacts__C = lstCon.size();

}

update lstAccount;

}

When to use?
Long-running processes or external calls
When it’s not batchable

Advantages:
Asynchronous process without concurrent limit
Easier and quicker to implement as opposed to batch

Disadvantages:
Parameters passed in can be only of primitive types
Can’t chain @future methods
Difficult to access job id

Batchable code to update Contact address with Account Address

February 2, 2018February 2, 2018 konaguru Leave a comment

Simple code to write Batchable code in Apex

/* update Contact Billing Address with Account Billing Address */

global class UpdateContactAddress implements Database.Batchable, Database.Stateful {
    
    global Integer recordsProcessed = 0;
    
    global Database.QueryLocator start(Database.BatchableContext bc ) {
        
        return Database.getQueryLocator(
            'SELECT ID, BillingStreet, BillingCity, BillingState, ' +
            'BillingPostalCode, (SELECT ID, MailingStreet, MailingCity, ' +
            'MailingState, MailingPostalCode FROM Contacts) FROM Account ' + 
            'Where BillingCountry = \'USA\''
        );
    }
    
    global void execute(Database.BatchableContext bc, List scope ) {
        
        // Process each batch of records
        List contacts = new List();
        
        for (Account account: scope) {
            
            for (Contact contact : account.contacts ) {
                
                contact.MailingStreet = account.BillingStreet;
                contact.MailingCity		= account.BillingCity;
                contact.MailingState	= account.BillingState;
                contact.MailingPostalCode	= account.BillingPostalCode;
                // add contact to the list to be updated
                contacts.add(contact);
                // increment the instance member counter
                recordsProcessed = recordsProcessed + 1;
                
            }
        }
        update contacts;   
    }
    
    global void finish(Database.BatchableContext bc) {
        
        System.debug(recordsProcessed + ' records processed. Shazam !! ');
        AsyncApexJob job = [Select ID, status, NumberOfErrors, JobItemsProcessed, TotalJobItems, CreatedBy.Email FROM AsyncApexJob
                            WHERE ID = :bc.getJobId()];
        
    }
}

/* update Contact Billing Address with Account Billing Address */

global class UpdateContactAddress implements Database.Batchable, Database.Stateful {

global Integer recordsProcessed = 0;

global Database.QueryLocator start(Database.BatchableContext bc ) {

return Database.getQueryLocator(

'SELECT ID, BillingStreet, BillingCity, BillingState, ' +

'BillingPostalCode, (SELECT ID, MailingStreet, MailingCity, ' +

'MailingState, MailingPostalCode FROM Contacts) FROM Account ' +

'Where BillingCountry = \'USA\''

);

}

global void execute(Database.BatchableContext bc, List scope ) {

// Process each batch of records

List contacts = new List();

for (Account account: scope) {

for (Contact contact : account.contacts ) {

contact.MailingStreet = account.BillingStreet;

contact.MailingCity = account.BillingCity;

contact.MailingState = account.BillingState;

contact.MailingPostalCode = account.BillingPostalCode;

// add contact to the list to be updated

contacts.add(contact);

// increment the instance member counter

recordsProcessed = recordsProcessed + 1;

}

update contacts;

}

global void finish(Database.BatchableContext bc) {

System.debug(recordsProcessed + ' records processed. Shazam !! ');

AsyncApexJob job = [Select ID, status, NumberOfErrors, JobItemsProcessed, TotalJobItems, CreatedBy.Email FROM AsyncApexJob

WHERE ID = :bc.getJobId()];

}

Advantages of Batchable Apex:

Can process millions of records using Batchable approach

Can schedule a job to run at a Particular time

Advantages of Batchable Apex:

Can process millions of records using Batchable approach

Can schedule a job to run at a Particular time

Disadvantages:

Only 5 concurrent jobs are allowed

It's difficult to troubleshoot

Execution depends on the server resources availability

@future methods are not allowed

...

Disadvantages:

Only 5 concurrent jobs are allowed

It's difficult to troubleshoot

Execution depends on the server resources availability

@future methods are not allowed

...

References: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_interface_database_batchable.htm

A simple Webservice callout script

February 1, 2018February 1, 2018 konaguru Leave a comment



		
		
			
			

			
			public class WeatherCallout {

    public static HttpResponse makeGetCallout() { 
        Http http = new Http();
        HttpRequest request = new HttpRequest();
        request.setEndpoint('http://api.openweathermap.org/data/2.5/weather?q=Bangalore,IN&appid=0b25f3800cd38ba852567039d1d364d4');
        request.setMethod('GET');
        HttpResponse response = http.send(request);
        // if the request is successful, parse the JSON response
        if (response.getStatusCode() == 200 ) {
            System.debug('Response Code Details ' + response.getBody() );
            Map<String, Object> m =(Map<String, Object>) JSON.deserializeUntyped(response.getBody());
          	Map<String, Object> dim =    (Map<String, Object>)m.get('main');
            Decimal temp_str = (Decimal) dim.get('temp');
            Decimal  temp_f = temp_str*9/5 - 459.67;
            Decimal  temp_c = temp_str - 273.15;
                 System.debug('Celcius  ' + temp_c);
            System.debug('Fahrenheit  ' + temp_f);
            
        }
        return response;
    }   
}
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
				
						public class WeatherCallout {
 
    public static HttpResponse makeGetCallout() { 
        Http http = new Http();
        HttpRequest request = new HttpRequest();
        request.setEndpoint('http://api.openweathermap.org/data/2.5/weather?q=Bangalore,IN&appid=0b25f3800cd38ba852567039d1d364d4');
        request.setMethod('GET');
        HttpResponse response = http.send(request);
        // if the request is successful, parse the JSON response
        if (response.getStatusCode() == 200 ) {
            System.debug('Response Code Details ' + response.getBody() );
            Map<String, Object> m =(Map<String, Object>) JSON.deserializeUntyped(response.getBody());
          	Map<String, Object> dim =    (Map<String, Object>)m.get('main');
            Decimal temp_str = (Decimal) dim.get('temp');
            Decimal  temp_f = temp_str*9/5 - 459.67;
            Decimal  temp_c = temp_str - 273.15;
                 System.debug('Celcius  ' + temp_c);
            System.debug('Fahrenheit  ' + temp_f);
            
        }
        return response;
    }   
}