Defining the functions

Simple mappings can copy data from a source field and place it in the target field. However, sometimes more complex transformations are required. All mappings have an add function icon which is used to define functions.

By default, when you register for a Cast Iron® Express® account, this function is disabled. To use this additional function, click Add-ons and select the Mapping Functions package. For more information, see Adding function to your Express account.

The Add function icon Add function icon can be clicked to open a list of available functions. The functions are group in to the following categories:
  • String
  • Mathematical
  • Boolean
  • Date
  • Utility
For more information about these functions, see the Glossary.

Procedure

Click the required function. A function box is inserted into the mapping.

Example

This example shows a simple String Length function.

Length function example

Also, the Result column on the right is updated to reflect the result of the function instead of a simple copy.

Some functions are more configurable and can accept multiple input fields. For example, the following screen capture shows a Concatenate function.

Concatenate function

Additional source fields can be connected to the anchor point on the left side of the function, as shown in the following screen capture.

Concatenate function with additional source fields

The Concatenate function also has configuration options which can be displayed by clicking the Edit icon Edit icon. You can change the order of the inputs and specify configuration options for the Concatenate function such as prefix, defaultDelimiter, and postfix.

Click Apply to save your changes. The Target Results column on the right is updated.

Restriction: If the result is too long to display on the screen, it is truncated. Click the truncated result to see the full result in a tooltip.



Feedback | Notices


Timestamp icon Last updated: Wednesday, December 16, 2015


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.api.omniapps.doc/integrations_DefiningTheFunctions.html