Interface Services: Support for app variables in field mappings

All interface service definitions contain mappings which define the process to map the data source columns to entity properties. This new feature adds support for application variables in place of column names in that mapping. This provides greater flexibility in the standard content, providing extensibility without having to duplicate complete interface service definitions and the related downstream configuration.

An application variable can be defined in the standard content with a default value. An alternate source field can be used by adding an override value in the application variable, only if the alternate source is available in the same source table or interface query.

The application variable value is replaced when the interface service is executed. When the resulting field value is empty, this field is excluded from processing. This may lead to an execution error if the field is required.

The feature is added to these Data Entities of Database Interface Type:

  • Code List
  • Calendar
  • Market Intelligence
  • Planning Engine
  • Scenario Value
  • Transactional Data

This feature is added to SCV Table Data Entity of CSV and Excel Interface Types.

There are no interface services using this feature delivered as part of the standard content.

Note: By default, the new validation rule is enabled. A new role or privilege is not required to access this feature.