Using the Advanced Tag Notation
You can use the OpenAir NetSuite Connector advanced tag notation for your field mapping definitions.
To view or enter a field mapping definition using the advanced tag notation, click the Advanced icon next to the source dropdown field on the relevant field mapping row. For advanced tag notation reference, see Advanced Mapping and Filter Notation Reference.
Integration point tags are not required, as the advanced mapping is set in the context of the integration workflow and mapping group.
Review the following guidelines
-
You should contact your OpenAir Professional Services representative if you need to make changes to your integration configuration and field mapping definitions.
-
For advanced mapping usage and best practice guidelines, see Advanced Field Mapping Definition.
-
Familiarize yourself with the NetSuite and OpenAir technical documentation before attempting to set field mapping definitions using the advanced notation — See Schema Reference Documentation.
Examples of Advanced Mappings
Value to value (fixed)
![Mapping a fixed value ="1" to the OpenAir field User.primary_filter_set](img/NetSuiteIntegration/Value_to_value_fixed.png)
Value to value (from schema)
![Mapping the NetSuite field Employee.lastName to the OpenAir field User.last](img/NetSuiteIntegration/value_to_value_from_schema.png)
Value to value (macros)
![Setting the OpenAir custom field User.hire_date__c to today's date using the macro _TODAY.](img/NetSuiteIntegration/value_to_value_macros.png)
Value to value (lookup)
![Advanced field mapping definition using lookup](img/NetSuiteIntegration/value_to_value_lookup.png)
Value to value (list map)
![Advanced field mapping definition using a value to value list.](img/NetSuiteIntegration/value_to_value_list_map.png)
Values to values (conditional branching / IF ... THEN)
There cannot be more than one conditional branching block on the same mapping group tab. Include all conditional branching (IF ... THEN ...
) mapping definitions on the same mapping definition row. Leave the destination field empty on that row.
![Advanced field mapping definition using conditional branching](img/NetSuiteIntegration/values_to_values_all_if_definitions.png)
Mapping an initial-only checkbox in a row
To define an “Initial Only” checkbox in a field mapping row, you must define it using either an OA_FIELDS_INITIAL_ONLY or NS_FIELDS_INITIAL_ONLY tag in the advanced mapping window, as shown below:
![Advanced field mapping definition declaring the field conditionally as initial only.](img/NetSuiteIntegration/InitialOnlyCheckBoxUseCase.png)