Create an Omnistudio Data Mapper Example with a Formula (Managed Package)

For the managed package runtime, the following example accepts a list of prices and uses a formula to compute the total price.

1. Go the Omnistudio Data Mapper Designer tab and click New. The Create dialog is displayed.
2. Specify a name for the Data Mapper and configure its settings as follows:

   • Interface Type: Transform

   • Input Type: JSON

   • Output Type: JSON

3. Click Save. The Data Mapper Interface page is displayed.
4. Go to the Formulas tab and click Add Formula.
5. In the Formula field, enter SUM(Products:Price).
6. In the Formula Result Path field, enter TotalPrice.
7. On the Transforms tab, expand the Input JSON pane and paste this JSON structure into it:

   {
       "CustomerName": "Bob Smith",
       "Products": [
           {
               "Name": "iPhone",
               "Price": 600
           },
           {
               "Name": "iPhone Case",
               "Price": 30
           },
           {
               "Name": "Ear Buds",
               "Price": 200
           }
       ]
   }

8. Expand the Expected JSON Output pane and paste this JSON structure into it:

   {
       "CustomerName": "Bob Smith",
       "TotalPrice": 830,
       "Products": [
           {
               "Name": "iPhone",
               "Price": 600
           },
           {
               "Name": "iPhone Case",
               "Price": 30
           },
           {
               "Name": "Ear Buds",
               "Price": 200
           }
       ]
   }

9. Click Quick Match. In the Quick Match window, click Auto Match, then click Save.
10. On the Preview tab, click Execute.

    If you have built the example correctly, the JSON structure in the Response pane matches the Expected JSON Output except for the order of the top-level nodes.

11. In the Input pane, change one or more of the prices, then click Execute again.

    Note how the TotalPrice value changes.