7. Real time use case on Data Raptor Extract

-

 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 }












Comments

Post a Comment

Popular posts from this blog

Create the Callout Step in DRO - Salesfroce - Dynamic Revenue Orchestrator

-
Image
  To create "CallOut" action in DRO steps :  To create callout we need to create "Integration Definitions"  setup -> Integration Definitions on search -> create new -> Once you click on save it will redirect to this page Step1 : Create Class like  global with sharing class CustomFulfillmentProvider implements industriesintegrationfwk.ServiceIntegrationProvider {     // 1. Primary synchronous invocation logic     global industriesintegrationfwk.IntegrationCalloutResponse invokeMethod(String method, Map<String,Object> inputMap) {         industriesintegrationfwk.IntegrationCalloutResponse response = new industriesintegrationfwk.IntegrationCalloutResponse(true);                try {             // STEP A: Extract the Orchestration Record Context IDs from the framework map             String targetRecordId = ''; ...
Read more

Apex Triggers - 15 (Amazon Interview Question)

-
  1. Scenario Overview This automation solves an Amazon Interview Question based on a parent-child relationship between a parent object, Tax_Firm__c , and a child object, Employee__c . The parent features two currency fields: Max_Salary__c and Min_Salary__c . The system must dynamically recalculate and roll up the highest and lowest employee salary values to these parent fields whenever any child employee record is inserted, updated, deleted, or undeleted . Additionally, the solution handles the edge case where all related employees are deleted from a firm, safely resetting the parent summary values to zero instead of leaving stale metrics behind . or Show the Min & Max Salary of Employee records on the Parent Company record. 2. Apex Handler Class public class EmployeeTriggerHandler {     public static void updateSalaryRollups(List<Employee__c> newEmployees, List<Employee__c> oldEmployees, Map<Id, Employee__c> oldEmployeeMap) {     ...
Read more

Data Raptor/Data Mapper (Turbo Extract) - omniscript - salesfroce SFI -

-
Image
1. Data Raptor Turbo Extract To extract data from Single Salesforce object + fields from related objects Ex: Extract contact details along with associated Account where AccountId <> null SOQL: SELECT Id, Name, AccountId from Contact WHERE AccountId <> null Ex: Extract contact details along with associated Account where AccountId <> null AND contact email <> null Order the result in ASC / DESC order Limit the number of output records Use of Offset in data raptor  Create new Data Mapper / DataRaptor click on preview button Click on execute button to get output 1. But recomended use ''  as '$Vlocity.NULL'  in condition. it should contain single quotes. 2.  ORDER BY   ->  Name ASC...
Read more