For the managed package runtime, the next Integration Procedure is a modified version of the previous example. Instead of matching list items using Id fields, it uses the Advanced Merge feature to match first and last names.
This information is for Omnistudio for Managed Packages. For Omnistudio on standard runtime, see Omnistudio Help.
To download a data pack of this example for Omnistudio for Managed Packages, click here.
- Create a Basic List Merge Example.
-
Clone the GetBirthdates Omnistudio Data Mapper and name it GetBirthdates2. On the Output tab,
change the Output JSON Path values from
contact:firstNametocontact:FNand fromcontact:lastNametocontact:LN. -
In the Integration Procedure, in the DRExtractBirthdates component, change the
Data Mapper Interface to
GetBirthdates2. -
In the Integration Procedure, in the List Merge Action, check Advanced Merge and add the
following rows to the Advanced Merge Map table:
List Key
Matching Path
Matching Group
DRExtractAddresses:contactfirstName1DRExtractBirthdates:contactFN1DRExtractAddresses:contactlastName2DRExtractBirthdates:contactLN2 -
On the Preview tab, click Execute. The output should look
something like this:
{ "contactMerge": [ { "LN": "Jones", "FN": "Cathy", "birthdate": "1975-10-03", "street": "300 Broadway", "state": "FL", "city": "Orlando", "lastName": "Jones", "id": "0036100001E5xrWAAR", "firstName": "Cathy" }, { "LN": "Jones", "FN": "Doug", "birthdate": "1976-10-04", "street": "400 Washington Blvd", "state": "AZ", "city": "Phoenix", "lastName": "Jones", "id": "0036100001E5xrvAAB", "firstName": "Doug" }, { "LN": "Smith", "FN": "Albert", "birthdate": "1973-10-01", "street": "100 Main Street", "state": "CA", "city": "San Francisco", "lastName": "Smith", "id": "0036100001E5xqnAAB", "firstName": "Albert" }, { "LN": "Smith", "FN": "Ben", "birthdate": "1974-10-02", "street": "200 Second Street", "state": "OR", "city": "Portland", "lastName": "Smith", "id": "0036100001E5xr2AAB", "firstName": "Ben" } ] }