DataRaptor/Data Mapper Extract | Salesforce OmniStudio | SFI

-

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?

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