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 (SuiteProjects Pro fields), OA_CUSTOM_FIELDS (SuiteProjects Pro 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 SuiteProjects Pro 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 SuiteProjects Pro 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 (SuiteProjects Pro fields initial-only), OA_CUSTOM_FIELDS_INITIAL_ONLY (SuiteProjects Pro custom fields initial-only), OA_FIELDS_GROUP_BY (SuiteProjects Pro fields group by), and OA_FIELDS_SORT_BY (SuiteProjects Pro fields group by).