Skip to content
Datamapper, Omnistudio, Salesforce

List Merge using Datamapper Formula

November 16, 2024

Suppose we have 2 lists in our output json but we want it to be combine in single list. In that case we have LISTMERGE function that we can use in datamapper formula field. 

Lets understand this with example Look at bellow json, we have 2 lists Contacts and Address.

Now, requirement is we have to merge both lists into one based on Id. For this I have used Transform type data mapper using below formula.

After using above formula output json is shown below.

Keep Reading

Related Articles and Resources

How to Train an AI Agent to Troubleshoot OmniScript Failures?
January 21, 2026

How to Train an AI Agent to Troubleshoot OmniScript Failures?

Your OmniScript is running smoothly in production. Users...

Getting Started with Salesforce FlexCards: A Beginner’s Guide
July 5, 2025

Getting Started with Salesforce FlexCards: A Beginner’s Guide

Salesforce OmniStudio offers a range of tools that allow...

Introduction to Salesforce Financial Services Cloud
October 3, 2025

Introduction to Salesforce Financial Services Cloud

In this article you will get an Introduction to Salesforce...

Revenue Cloud Advanced for Subscription Businesses: Real Use Cases
January 7, 2026

Revenue Cloud Advanced for Subscription Businesses: Real Use Cases

Picture this: It’s month-end, and your finance team...

Salesforce Spring ’26 Release: Upgrade Smart, Don’t Just Upgrade Hard
November 28, 2025

Salesforce Spring ’26 Release: Upgrade Smart, Don’t Just Upgrade Hard

Salesforce Spring ’26 Release: Key updates, behavior...

Batch Apex in Salesforce – Best Practices, Use cases, Feature, Comparison etc.
October 9, 2025

Batch Apex in Salesforce – Best Practices, Use cases, Feature, Comparison etc.

In this blog, we are going to discuss Batch Apex in...