Create a Basic List Merge Example

In this example, the first Integration Procedure retrieves all Contacts with the same AccountId in two lists, one containing addresses, the other birthdates. It then merges the two lists into one.

1. Create the Data Mapper Extract that the DRExtractAddresses component calls. Name it GetAddresses and configure it with these settings:

   Extract	A Contact extract step set to contact AccountId = id
   Output	These mappings: contact:Id to contact:id contact:FirstName to contact:firstName contact:LastName to contact:lastName contact:MailingStreet to contact:street contact:MailingCity to contact:city contact:MailingState to contact:state

   If you aren't sure how to create a Data Mapper Extract, see the examples in Omnistudio Data Mapper Extract Examples.
2. Create the Data Mapper Extract that the DRExtractBirthdates component calls:
   1. Clone the GetAddresses Data Mapper and name the clone GetBirthdates.
   2. Go to the Create Mapping page, and delete the city, state, and street mappings. If you're using the designer on a managed package, go to the Output tab, and delete the city, state, and street mappings.
   3. Add a mapping from contact:Birthdate to contact:birthdate.
3. From the App Launcher, find and select Integration Procedures.
4. Click New.
5. Enter a unique name, type, and subtype for your Integration Procedure.
6. Enter a description for your Integration Procedure.
7. Save your changes. The Integration Procedure canvas opens.
8. Add the first Data Mapper Extract Action component:
   • To open the Elements panel, click +, select Data Mapper Extract, click , and select Details.
   • If you’re using the designer on a managed package, open the Available Components panel, and drag Data Mapper Extract Action to the Structure panel.
9. Enter DRExtractAddresses as the element name, and GetAddresses as the Data Mapper name.
10. Add the second Data Mapper Extract Action component below the first Data Mapper Extract Action component.
11. Enter DRExtractBirthdates as the element name, and GetBirthdates as the Data Mapper name.
12. Add a List Action component into the Structure panel below the second Data Mapper Extract Action component and configure it with these settings:

    Merge Lists Order	DRExtractAddresses:contact DRExtractBirthdates:contact
    Merge Fields	id
    Sort By	lastName firstName

13. Add a Response Action component into the Structure panel below other action components.
14. Enter ListAction1 in the Send JSON Path field, and contactMerge in the Send JSON Node field.
15. On the Preview tab, in the Input Parameters pane, click Add Key-Value Pair.
16. Enter id as the key and an Account Id from your org as the Value.
17. Click Execute.
    The output is similar to this example:

    {
      "contactMerge": [
        {
          "birthdate": "1975-10-03",
          "street": "300 Broadway",
          "state": "FL",
          "city": "Orlando",
          "lastName": "Jones",
          "id": "0036100001E5xrWAAR",
          "firstName": "Cathy"
        },
        {
          "birthdate": "1976-10-04",
          "street": "400 Washington Blvd",
          "state": "AZ",
          "city": "Phoenix",
          "lastName": "Jones",
          "id": "0036100001E5xrvAAB",
          "firstName": "Doug"
        },
        {
          "birthdate": "1973-10-01",
          "street": "100 Main Street",
          "state": "CA",
          "city": "San Francisco",
          "lastName": "Smith",
          "id": "0036100001E5xqnAAB",
          "firstName": "Albert"
        },
        {
          "birthdate": "1974-10-02",
          "street": "200 Second Street",
          "state": "OR",
          "city": "Portland",
          "lastName": "Smith",
          "id": "0036100001E5xr2AAB",
          "firstName": "Ben"
        }
      ]
    }