Map information from one module to another in ÃÛ¶¹ÊÓƵ Workfront Fusion
Mapping is the process of assigning a module’s outputs, structured into items, to another module’s input fields.
The mapping panel displays when you click a field where you want to insert a value outputted from a preceding module in a scenario. Within a module, in any field that is available for mapping, you can create a formula using any combination of functions and mapped items from the mapping panel with static text that you type. These elements can be nested inside each other.
Access requirements
You must have the following access to use the functionality in this article:
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.
Bundles and items
The operation of a module produces zero, one, or more bundles as its output. A bundle consists of one or more items.
To explore the output of a module:
-
Click Run once to execute the module.
-
Click the bubble above the module.
A log containing all of the module’s phases displays. You can find the bundle or bundles outputted by a module’s operation phase under the Output heading. Each bundle contains its items and each item’s values.
Date, Email ID (UID), size, and so on.
Map an item
After you have created a sequence of modules by linking two or more of them, each module can process values of items outputted by the modules that precede it.
To assign the items to a module’s input fields:
-
Click on the module that should process the output of the preceding module or modules.
-
In the Module settings panel that displays, click a field where you want to use the value of an item outputted from a preceding module(s).
The mapping panel opens.
-
Click an item from the mapping panel to insert it into the field.
-
(Optional) To search for a particular field in the mapping panel, click the mapping panel search bar and type in the term you want to search for. Click the field when it appears in the list.
Search results contain the search term and are not case sensitive.
For more information, see Configure a module’s settings in ÃÛ¶¹ÊÓƵ Workfront Fusion.
Formulas
You can map multiple items into a field, combine them with literals (fixed values), and employ Operators and Functions to build complex formulas:
You can find the functions and operators in the mapping panel under one of its tabs.
The first tab
The other tabs contain the following types of functions:
-
General functions
-
Math functions
-
Text and binary functions
-
Date and time
-
Functions for working with arrays
For more information on mapping items using functions, see Map items using functions in ÃÛ¶¹ÊÓƵ Workfront Fusion.
Collections
Some items can contain multiple values of various types. These are collection type items.
You can identify a collection type item by the small black rectangle displayed to the right of the item’s label and its automatically expanded list of sub-items:
For more information about collections, see Item data types in ÃÛ¶¹ÊÓƵ Workfront Fusion
Arrays
Some items can contain multiple elements of the same type. These are array type items.
You can identify an array type item by the square brackets at the end of the item’s label. Click the small black rectangle to the right of the item’s label to reveal the element’s items:
For more information about arrays, see Item data types in ÃÛ¶¹ÊÓƵ Workfront Fusion
Map an array’s first element
If you map an array’s Recipient name item, it displays in the field like this:
The number in the square brackets is an index that determines which element of the array will be used. It is set to 1 by default.
Map an array’s n-th element
If you want to access another element, click on the square brackets and edit the index value:
Map an array’s element with a given key
Some arrays contain several collections with key and value items. These are typically various metadata, attributes, and so on.
The following example shows the output of the Jira App.
In this example, we get a file name from an array of attachments for the specific attachment with an ID of 10108.
The output from Jira looks like this:
The typical requirement is to look up an element by its given key value and obtain the corresponding value from the value item. This can be achieved with a formula employing a combination of the map() and get() functions.
The following is a detailed breakdown of the formula:
-
The first parameter of the
map()function is the whole array item. -
The second parameter is the raw name of the value item. To obtain the raw name, hover over the item in the mapping panel:
note note NOTE All parameters are case sensitive. Even though in this particular example the item’s label differs from its raw name only in capitalization, it is necessary to use the raw name, which is all lowercase value in contrast to the label Value. -
The 3rd parameter is the raw name of the key item:
-
The 4th parameter is the given key value.
Because the map() function returns an array (as there could be more elements with the given key value), it is necessary to apply the get() function to get its first element:
-
The 1st parameter of the
get()function is the result of themap()function. -
The 2nd parameter is the element’s index - one.
For more information about the map() function, see Array functions in ÃÛ¶¹ÊÓƵ Workfront Fusion.
For more information about the get() function, see General functions in ÃÛ¶¹ÊÓƵ Workfront Fusion.
Converting elements to a series of bundles
Arrays can be converted to a series of bundles using the Iterator module. For more information, see Iterator module in ÃÛ¶¹ÊÓƵ Workfront Fusion.
Troubleshooting
Missing items in the mapping panel
For each module, the mapping panel displays all output items, listed by the author of the module. In some cases, this list might be incomplete for various reasons, and some items might be missing. Workfront Fusion can auto-discover the missing output items when you run the module in the scenario editor. The exact procedure differs slightly depending on the module’s type:
Instant trigger
-
Right-click the module, then click Run this module only in the menu that displays.
If there are no queued webhooks, the module waits for a new webhook to process.
-
Generate a webhook.
For example, the webhook module Slack >Listen for new events (which watches for new channel messages in a channel) sends a message to the channel.
-
When the module finishes running, click the bubble above the module to explore its full output.
The mapping panel will contains all the items that were discovered in the module’s output.
Polling trigger
-
Right-click the module, then click Run this module only in the menu that displays.
-
If there is no output, click Choose where to start and adjust the settings.
-
If there is no event to be processed, create one and go back to step 2.
For example, the webhook module Gmail >Watch emails sends an email to the folder that the module is watching.
-
When the module finishes running, click the bubble above the module to explore its full output.
The mapping panel now contains all of the items that were discovered in the module’s output.
Other modules
You may choose to execute:
-
The whole scenario (or just the part containing the module)
If your scenario starts with a trigger, refer to the Instant trigger or Polling trigger section above.
-
Just the single module
If you choose to execute just the single module:
-
Right-click the module, then click Run this module only in the menu that displays…
-
Provide sample values for the input items, then click OK .
-
When the module finishes running, click the bubble above the module to explore its full output.
The mapping panel now contains all of the items that were discovered in the module’s output.