DataMapper Load in Salesforce OmniStudio

When working with OmniStudio (formerly Vlocity), DataRaptors play a crucial role in extracting, transforming, and loading data efficiently. One of the most important components of DataRaptors is the DataMapper Load feature, which helps map input data to Salesforce objects and fields.

In this blog, we'll explore what DataMapper Load is, why it's useful, and how to configure it with a simple example.

---

What is DataMapper Load?

DataMapper Load is a functionality within DataRaptor Load that enables you to:

• Map input JSON data to Salesforce objects and fields

• Transform data before saving it to Salesforce

• Perform Create, Update, Upsert, or Delete operations on records

It acts as a bridge between external data and Salesforce, ensuring the right data is stored in the right place.

---

Example: Creating an Account Record using DataMapper Load

Let's say you are building an OmniScript to capture customer details and save them as an Account record in Salesforce. Here’s how you can use DataMapper Load to achieve this.

Step 1: Create a DataRaptor Load

1. Navigate to OmniStudio → DataRaptors → New DataRaptor

2. Select Type as "Load" and click Next

3. Provide a Name (e.g., DR_Load_CreateAccount) and save

Step 2: Configure DataMapper Load

1. In the Extract JSON Path section, define the input JSON structure:

{

  "AccountName": "Tech Solutions",

  "Phone": "1234567890",

  "Industry": "Technology"

}

2. In the Mapping Tab, map the input fields to Salesforce object fields:

Input JSON Path	Salesforce Field	Action
AccountName	Account.Name	Insert
Phone	Account.Phone	Insert
Industry	Account.Industry	Insert

Step 3: Test and Deploy

• Click Preview and pass the sample JSON to verify the mapping.

• If everything looks good, save and deploy the DataRaptor.

When to Use DataMapper Load?

• When you need to save data from an OmniScript to Salesforce

• When mapping external data from APIs or integrations into Salesforce objects

• When performing bulk updates on records

Conclusion

DataMapper Load is a powerful feature of DataRaptor Load that simplifies data mapping and processing in Salesforce OmniStudio. With a well-configured DataRaptor Load, you can efficiently store customer data without writing complex Apex code.

Would you like to explore more advanced use cases, such as handling multiple objects in a single DataRaptor Load? Let me know in the comments.