Experience Salesforce
Upsert | APEX DML Standalone Statements
What You’ll Learn
- Upsert In Salesforce
Topics
- What Is DML In Salesforce?
- Insert | APEX DML Standalone Statements
- Update | APEX DML Standalone Statements
- Upsert | APEX DML Standalone Statements
- Delete | Apex DML Standalone Statement
- Undelete | Apex DML Standalone Statement
- Merge | APEX DML Standalone Statements
- APEX DML Statements Best Practices
- Database Class in APEX
- Empty Recycle Bin
- Count Query | Method in Apex Database Class
- Lead Conversion | Method in Apex Database Class
- Transaction Control and Rollback
- Database Class Method Result Object
Upsert In Salesforce
To create or update the existing data, you need to use an upsert statement.
Example
List < Contact > newConList = new List < Contact > ();
List < Contact > conList = [SELECT firstname, lastname FROM contact];
Integer i = 1;
for (Contact cc: conList) {
String s = cc.name;
if (s.conatins(‘Contact’)) {
cc.phone = ‘1234’;
} else {
Contact c1 = new Contact(lastname = ’Contact’ + i);
i++;
}
newConList.add(cc);
}
upsert newconList;
Need Extra Support? Our FREE study materials have got you covered.
Our expert-prepared study materials provide the answers you need. Clear your doubts and improve your skills with detailed notes from industry professionals.
