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

Loop Block in Integration Procedure?
November 22, 2024

Loop Block in Integration Procedure?

A Loop block is a group element in an Integration,...

How to Pass List/Obj to Integration Procedure from FlexCard?
November 10, 2024

How to Pass List/Obj to Integration Procedure from FlexCard?

Passing Input to a Integration Procedure, the syntax is...

SetUp Rules in Salesforce Revenue Cloud Advanced (RCA)
October 2, 2025

SetUp Rules in Salesforce Revenue Cloud Advanced (RCA)

If you’ve ever wrestled with product bundles, discounts,...

try-catch block in Integration Procedure
November 25, 2024

try-catch block in Integration Procedure

Integration Procedures (IP) in Salesforce OmniStudio, a-...

Pricing Management in Salesforce: Configuring, Controlling, and Optimizing Your Revenue Model
December 17, 2025

Pricing Management in Salesforce: Configuring, Controlling, and Optimizing Your Revenue Model

Pricing management in Salesforce is the backbone of every...

Lightning Web Components (LWC) Tutorial: A Beginner-to-Advanced Guide
September 18, 2025

Lightning Web Components (LWC) Tutorial: A Beginner-to-Advanced Guide

This LWC tutorial is designed to walk you through what...