Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
You can use the mapping expression built-in the Web Mapper to map source layout elements to the destination layout elements. These mapping functions are listed as:
All these mapping expression comprise of sub-functions using which you can map elements.
Steps to map elements using Mapping Expression
Adeptia Connect offers you two kind of interfaces (textual and graphical) to create and use mapping rules while mapping the source and destination elements. The interfaces are known as "Textual Rule" and "Graphical Rule". The graphical interface makes it easy for you to see the graphical representation of elements and allows you to perform mapping by connecting source element to any target element or to any mapping functions. Applying mapping rule is also very convenient as you can see the functions graphically and use the context menu options to connect to both source and target elements.
This section guides you on how to use the Graphical rule option while mapping the elements and also introduces the different components of this option.
Table of Contents | ||
---|---|---|
|
Elements of Graphical Rule
The Mapping Expression area has a floating menu that contains two options for you to switch between the Graphical and Textual rule. You can drag this floating menu anywhere in the Mapping Expression area.
Graphical elements are components which are used to represent any source, destination, mapping function, or parameter elements visually in Mapping Expression area. The following types of annotations describe the type, behavior, and functioning of the graphical interface and their elements.
- Floating Menu
- Inputs
- Label
- Element type
- Context Menu
Image Added
Floating Menu
Floating menu contains two options for you to switch between the Graphical and Textual rule. You can drag this floating menu anywhere in the Mapping Expression areaInputs
The number of inputs a mapping function or a target element can have. Also, you can drag a line from input element to this section to use that as an input in this mapping function or target element.
Label
The name of the element.
Element type
Type of element being used in the mapping rule. The following list explains the types of elements:
Element type | Description |
---|---|
f(x) | A mapping function, variable, custom method, key function, context variable, connection variable, etc. |
S | A source element. |
D | A destination element. |
T | An XSL Template. |
VM | A Value Map. |
C | A Constant value. |
Context Menu
Context Menu options are used to perform the following actions:
Image Added
- To draw the connecting lines to map an element to another element(s).
- To remove the field/function from the Mapping.
- To go into More menu option. It contains the following action items:
- Information option to know the details about the element.
- Remove Mapping option to remove the mapping from the element.
- Add As Local Variable option to add the element's syntax/expression as a local variable.
Applying mapping functions using Graphical Rule
Mapping Expression tab gives you two interfaces, Textual and Graphical, to perform the mapping. By default, the Graphical Rule is active.
Tip |
---|
For quick understanding, you can take a look at this video explaining the concept discussed herein. |
Image Added
Note |
---|
You can switch to the Textual Rule interface by clicking the Textual Rule Image Added icon in the floating menu. A warning message is displayed asking for your confirmation, click Yes to switch to Textual Rule. To perform mapping in Textual Rule interface, refer to this document. |
You can use the option, Graphical Rule, available under the Mapping Expression tab in the web mapper.
- Ensure that the source and destination layouts are loaded and all their elements are listed under their respective nodes.
- Click Mapping Expression tab from Mapping Functional Panel.
Select a destination element which you want to map.
- Click the desired mapping expression. This displays a list of sub-functions associated with the selected mapping expression.
- Select the
Tip Until you select a destination element first, the Mapping Expression tab will remain grayed out. Click Mapping Expression tab at the left bottom of the screen.
The destination element that you have selected will be visible in the mapping expression area.- Double-click a source element that you want to map to the destination element.
Click a mapping function that you want to use and select the desired sub-function and use it to map the source and destination elements. For example, using you can use the Concat sub-function.
Note You can also add a parameter in the mapping expression area by double-clicking the parameter's name in the Parameters panel. Click String mapping function and select Concat sub-function.
The syntax for the Concat sub-function is displayed
Once you have all the corresponding graphical elements (source elements, destination element, and mapping sub function) available in the mapping expression area, do the following:
Area.Tip You can drag and reposition the graphical mapping elements anywhere in the Mapping Expression
Image RemovedThis syntax has two parameters. Double-click a source element that you want to set as the first parameter. This displays the selected source element in the syntax.
Similarly, double-click another source element as the second parameter. This is displayed in the syntax.- This maps elements using the concat sub-function. A line is displayed between the source and target panels showing the mapping of the source element to the target element.
- Once you have performed the mapping activity, click Save button to save the mapping.
Image Removed
You can indent the textual rule content as per your requirement.
For details on using these mapping functions, refer to the section Using Mapping Functions.
While mapping elements, certain suffixes are displayed next to source and destination elements in the Source and destination Panels.
(C)
destination element can be cloned to create another destination element.
(CM)
Comments have been added for the destination element.
(F)
For Each property has been applied for the destination element.
(LV)
A local variable has been declared to the destination element.
Suffix
Description
area. - Click each of the source elements and select the Image Added icon from the Context Menu to connect the source with the respective Inputs of Concat sub-function.
Click the Concat sub-function and select the Image Added icon from the Context Menu to connect with the destination element.
The source elements are now mapped to the destination element using Concat sub-function and the mapping is visible in the mapping panel.
Image AddedTip You can reposition the entire mapping within the Mapping Expression area by clicking anywhere and moving the cursor.
You will be notified of an error message in the Comments section if the mapping function and destination element do not have the proper mapping.
Anchor | ||||
---|---|---|---|---|
|
Multimedia | ||||||
---|---|---|---|---|---|---|
|
Color coding of connecting lines
The color of the connecting lines depend upon the following three factors:
Color | Description |
---|---|
Green | Lines connecting two elements will be green in color if the both elements are visible in the current space of Mapping Expression area. |
Gray | Lines connecting two elements will be gray in color if any of the two elements is not visible in current space of Mapping Expression area. |
Orange | Lines connecting two elements will be orange in color if any of the elements is selected. |
Note |
---|
You can scroll up and down to view the hidden fields/elements in the Mapping Expression area. |
Adding a constant
You can add a Constant while mapping the source and destination elements. This option is visible only when you are applying the graphical mapping rule.
Perform the following steps to add a Constant:
- Click Image Added button located at the bottom of the Mapping Expression window.
A graphical notation for the Constant will be added to the Mapping Expression area. - Double-click the Constant notation.
Add Constant window appears. - Enter a constant value in the Constant Value field.
- Select the Add Quotes check box if the value is String type.
- Click Ok.
- Click the Constant notation and select the Image Added icon from the Context Menu to connect with the destination element.
Using Lookup mapping function for a reference field in target layout
When the destination element of target layout is a reference field, the Mapping Expression feature gives you an additional option of Lookup Mapping on the floating menu.
Lookup mapping function is used to set the dynamic value for the reference field by searching a value in the source field that matches the corresponding record of a destination field. For example, if you know the Account name at the source and do not know its respective ID, you may use the Lookup function and find it.
The Lookup function is supported for the following business applications:
- BigCommerce
- FreshBooks
- Magento
- QuickBooks
- Salesforce
- Service Now
- Xero
- Zendesk
Perform the following steps to use the Lookup mapping function:
- Select the reference field element for which you want to use Lookup mapping function.
Click Mapping Expression tab at the left bottom of the screen.
The Lookup option will be become available on the floating menu and you get options in the mapping expression area to choose the reference account.- Select the Lookup option.
Image Added - Perform the following steps to define the criteria based on which the reference field value will be fetched:
- Select the destination field for which you want to match value at source from the Target Field.
Select Equals operator from the Condition.
Note You will find other operators in case of Service Now application only. Depending on the selected Target Field type (integer, boolean, string, date/time, reference, and GUID) the operators will differ. Select the source field that should match the value of the selected destination field from the Source Field.
Note You can select multiple fields if you have selected is one of or is not one of operator in the Condition drop-down list. You can select two fields only if you have selected between operator in the Condition drop-down list.
Panel | ||||
---|---|---|---|---|
| ||||
What's newBest practicesTraining guidesFrequently asked questionsAdeptia Connect APIsAdeptia security report |