15 OmniStudio DataRaptor Transform Explained with Real use case (part of Mini Project)

-

15 OmniStudio DataRaptor Transform Explained with Real use case (part of Mini Project)








DRTInsuranceView

Input JSON : 
{
  "input": {
    "customer": {
      "customerID": "C-101",
      "name": "John Doe",
      "DOB": "1990-05-15",
      "language": "English",
      "VIPflag": true
    },
    "policies": [
      {
        "policyID": "P-501",
        "customerID": "C-101",
        "type": "Health",
        "premium": 15000
      },
      {
        "policyID": "P-502",
        "customerID": "C-101",
        "type": "Auto",
        "premium": 12000
      }
    ],
    "claims": [
      {
        "claimID": "CL-901",
        "policyID": "P-501",
        "status": "Approved",
        "amount": 50000
      },
      {
        "claimID": "CL-902",
        "policyID": "P-502",
        "status": "Pending",
        "amount": 25000
      }
    ],
    "payment": [
      {
        "paymentID": "PAY-001",
        "claimID": "CL-901",
        "date": "2026-03-10",
        "amount": 30000
      },
      {
        "paymentID": "PAY-002",
        "claimID": "CL-901",
        "date": "2026-04-12",
        "amount": 20000
      }
    ]
  }
}

OutPut JSON Structure :

{
  "customer360": {
    "customerID": "C-101",
    "name": "John Doe",
    "age": 36,
    "totalPremiumPaid": 27000,
    "totalClaim": 75000,
    "totalApprovedPaid": 50000,
    "outstandingAmount": 25000,
    "riskFlag": "high outstanding",
    "priorityLevel": "gold",
    "policies": [
      {
        "policyID": "P-501",
        "type": "Health",
        "premium": 15000,
        "claims": [
          {
            "claimID": "CL-901",
            "status": "Approved",
            "amount": 50000,
            "payment": [
              {
                "paymentID": "PAY-001",
                "date": "2026-03-10",
                "amount": 30000
              },
              {
                "paymentID": "PAY-002",
                "date": "2026-04-12",
                "amount": 20000
              }
            ]
          }
        ]
      },
      {
        "policyID": "P-502",
        "type": "Auto",
        "premium": 12000,
        "claims": [
          {
            "claimID": "CL-902",
            "status": "Pending",
            "amount": 25000,
            "payment": []
          }
        ]
      }
    ]
  }
}

=====================================================

Input JSON PathOutput JSON Path
input:customer:customerIDcustomer360:customerID
input:customer:namecustomer360:name
input:policies:policyIDcustomer360:policies:policyID
input:policies:typecustomer360:policies:type
input:policies:premiumcustomer360:policies:premium
input:claims:claimIDcustomer360:policies:claims:claimID
input:claims:statuscustomer360:policies:claims:status
input:claims:amountcustomer360:policies:claims:amount
input:payment:paymentIDcustomer360:policies:claims:payment:paymentID
input:payment:datecustomer360:policies:claims:payment:date
input:payment:amountcustomer360:policies:claims:payment:amount
2. Formula & Transform Tab Mappings
For calculated fields, copy the expression into the Formula column and map its result to the corresponding target path in the Output JSON Path column (10:58).
Formula ExpressionOutput JSON Path
AGE(input:customer:DOB)customer360:age
SUM(input:policies:premium)customer360:totalPremiumPaid
SUM(input:claims:amount)customer360:totalClaim
SUM(input:payment:amount)customer360:totalApprovedPaid
customer360:totalClaim - customer360:totalApprovedPaidcustomer360:outstandingAmount
IF(customer360:outstandingAmount > 10000, "high outstanding", "normal amount")customer360:riskFlag
IF(input:customer:VIPflag == true, "gold", "normal")customer360:priorityLevel

====================================

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