Advanced Mappings for Custom Export Workflows

You can set up advanced mappings for custom export workflows. For more information about advanced mappings, see Using the Advanced Tag Notation and Advanced Mapping and Filter Notation Reference.

Note the following differences between advanced mappings for custom export workflows and for other integration workflows:

The following field declarations are not required: OA_FIELDS (OpenAir fields), OA_CUSTOM_FIELDS (OpenAir custom fields), NS_FIELDS (NetSuite fields), and NS_CUSTOM_FIELDS ( NetSuite custom fields). You can use them but they will be ignored.

For example:
- Value to value (from schema) mapping — Advanced mapping is not required as you should be able to select the NetSuite field from the dropdown options on the Mapping tab. However, you could use the equivalent advanced mapping.
```
title   name 
```
- Value to value (lookup) mapping — You can specify the lookup in the same way as for standard workflows but the field declaration is not required.
```
company lookup=project_id:lookup_table=project:lookup_by=id:lookup_return=netsuite_project_id 
```
- Value to value (list map) — You can use the mapping table in the same way as for standard workflows but the field declaration is not required. In the following example, if the project_id value is 126 on the OpenAir record, company is set to 4971 in NetSuite.
```
<company project_id>
   '126' '4971'
   '127' '4970'
</company> 
```
- Value to value (IF condition) — You can use the IF condition in the same way as for standard workflows but the field declaration is not required. In the following example, if the project_id value is 126 on the OpenAir record, company is set to 4971 in NetSuite.
```
IF <<END
IF (project_id='126') THEN company '4971'
IF (project_id='127') THEN company '4970' ELSE company '4972'
END 
```
The following field declarations are not supported currently: OA_FIELDS_INITIAL_ONLY (OpenAir fields initial-only), OA_CUSTOM_FIELDS_INITIAL_ONLY (OpenAir custom fields initial-only), OA_FIELDS_GROUP_BY (OpenAir fields group by), and OA_FIELDS_SORT_BY (OpenAir fields group by).