Create an Advanced List Merge Example (Managed Package)

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.

Managed Package app icon 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. 

  1. Create a Basic List Merge Example.
  2. Clone the GetBirthdates Omnistudio Data Mapper and name it GetBirthdates2. On the Output tab, change the Output JSON Path values from contact:firstName to contact:FN and from contact:lastName to contact:LN.
  3. In the Integration Procedure, in the DRExtractBirthdates component, change the Data Mapper Interface to GetBirthdates2.
  4. 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:contact

    firstName

    1

    DRExtractBirthdates:contact

    FN

    1

    DRExtractAddresses:contact

    lastName

    2

    DRExtractBirthdates:contact

    LN

    2

  5. 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"
        }
      ]
    }