SivaAPSFDC

  13 DataRaptor Load / Post | “Is Lookup” Explained | Avoid Manual Search in OmniStudio DRPInsertContactBasedAccNumber

  12 DataRaptor Load | Insert Contact with Related Account | Salesforce OmniStudio | Add Related Link DRPContactAccountInsert ========================================================================== Insert Multiple contacts with one related account =================================================================== create multiple contacts with multiple unique related accounts

 11 DataRaptor Load/Post Explained | Insert, Update & Upsert - Single & Multiple Records | OmniStudio DRLInsertContact PhoneVar LastNameVar From below we can see to insert multiple Contacts Insert process In DataRaptor/Data Mapper in salesfroce Omniscript ======================================================================= How to Upsert records ========================================================================== How to Update ?

 10 DataRaptor Extract use case - Customer 360 view | Account, Contacts, Cases & Opps in OmniStudio DREAccountView OppList:Name Opportunity:Name AccList:Name Account:Name AccList:Industry Account:Industry ConList:Name Contact:Name ConList:Email Contact:Email CaseList:CaseNumber Case:CaseNumber CaseList:Status Case:Status OppList:StageName Opportunity:StageName

 9. Salesforce OmniStudio: Count Opportunities by Stage | FILTER + LISTSIZE + IF + ISBLANK Explained DREOppCountAccount AccNameVar

8.  Real Use Case: Calculate Account Age with DataRaptor Extract (AGE Function Explained) OmniStudio   DREFetchAccountDetails - DR Name AccountNameVar

  SELECT Id, Name, ( SELECT Id, FirstName, LastName, Email FROM Contacts) FROM Account WHERE Name = :accountName Real time use case on Data Raptor Extract Learning from this ex : How to extract data and use different functions in "formulas" section in DR Functions used: IF, LISTSIZE, ISBLANK Ex 1: Extract contact details for provided account name and display the number of contacts for provided account if exists, else display the flag value as "false" {To understand, first will show incorrect approach and then will explain correct way so hold on till end }

2. Data Raptor Extract To extract data from - multiple Salesforce objects + can use 'formulas' section Use Case 1. Use case: Show all contacts under one Account. 2. Use case: Show all contacts and all the Opportunities of one Account.   2. Data Raptor Extract Interview Questions: 1. Application need to display count of all opportunities stagewise for given account, which Data Raptor can be used? 2. Which Data Raptor can be used to fetch data from Account, Contact and Opportunity? 3. When can we not used Data Raptor Turbo Extract?