• Home
/
• Working in m3ter - User Guides
/
• Integrations
/
• Setting Up and Managing Native and Notification Integrations

Creating and Managing Transformations

You can create Transformations to support your m3ter integrations. Transformations allow you to customize the conversion of data as it flows into or out of the m3ter system via integrations. A Transformation defines a one-way data mapping from one specific data type to another.

This topic explains how to create and manage Transformations:

• Creating Transformations

• Reviewing and Managing Transformations

• Exporting and Importing Transformation Output Fields

Creating Transformations

In the Console, you can quickly create any Transformations you need to support your m3ter integrations.

To create a Transformation:

1. Select Integrations:

The Integrations page opens.

2. On the sidebar, select Transformations:

The Transformations page opens and lists any existing Transformations.

3. Select Create transformation. The Create page opens.

4. Enter the Transformation details:

• Name. (Required)

• Description. (Required)

5. Enter the Transformation settings:

• Input system. Select the input system. (Required)

• Input table. Select the table in the selected input system. (Required)

• Output system. Select the output system. (Required)

• Output table. Select the table in the selected output system. (Required)

In this example, a Transformation defines that m3ter Account entities will be mapped to NetSuite Customer objects.

6. To define output fields for the Transformation, on the Output fields panel select Add output field. The panel adjusts and you can enter the details of an output field.

Three types of Transformation method are available for defining output fields:

• Static value. The defined field is set on the destination object with the same value.

• Field lookup. A direct mapping from the source object into the destination field. (Default)

• Calculation. For more advanced scenarios, you can leverage m3ter’s Calculation Syntax to set values at runtime.

For the current example, we'll use the Field lookup method to define how two values will be determined for the output fields:

• Enter a Field key value, and then use the Input field drop-down list to select the field on the entity, which in the current example is the m3ter Account entity:

• Repeat for any other Field value transformations:

• For the current example, we'll also add a Static value transformation:

7. On the Output fields panel, select Preview output. A Transformation output preview modal opens:

You can use this to:

• Review and edit the Input data JSON for the Output fields you've defined.

• Select Generate output and review the Output that will result from the Transformation:

8. When you are happy with the generated Output, close the Transformation output preview modal.

9. Select Create transformation. The Transformation details page opens:

Note that you can:

• Select to expand and review the Output fields you've set up for the Transformation.

• Use the Export button to open and copy the Transformation's output fields for importing into other Transformations.

11. If you return to the Transformations page, your new Transformation will be listed there.

Reviewing and Managing Transformations

From the Transformations page, you can quickly review the details of a Transformations and edit or delete it.

To review and manage Transformations:

1. Open the Integrations section and select Transformations. The Transformations page opens.

2. If you want to view the details of a Transformation, select the Name hotlink text:

The Transformation details page opens.

3. Select to expand the details and view the Output fields defined for the Transformation:

4. If you want to update the Transformation, select Edit. Make any required changes on the Edit page and select Update transformation.

5. If you want to delete a Transformation, return the Transformations page and select the Delete icon:

A confirmation dialog appears:

6. Select Delete to confirm the delete action.

Exporting and Importing Transformation Output Fields

When you have set up a Transformation, you might want to re-use the output fields of the Transformation for other Transformations. You can also do this in cases where the Transformations belong to different Organizations.

To export and import Transformation output fields:

1. Open the Transformation details page of the existing Transformation whose output fields you want to re-use.

2. Select Export. An Export transformation modal opens:

3. Select Copy. The output fields are copied to your clipboard.

4. Open the Create/Edit page of the Transformation you want to re-use the output fields for.

5. On the Output fields panel, select Import. An Import transformation modal opens.

6. Paste the copied output fields into the modal and select Submit:

7. The imported fields are added to the Output fields panel.

• Note that if you've already added output fields to the Transformation, these will be overwritten by the imported fields and you'll have to add them again after importing.

8. Select Create/Update transformation. The Transformation details page opens:

Next: Creating and Managing Integration Credentials

Additional Support