Business Integration Solutions documentation

About: Expression functions mapping

With function expression-to-field mapping, you can run a function from Microsoft Dynamics 365 Business Central to calculate values.

Usage

Use an expression function when you want to manipulate, calculate, or enrich the data being imported or exported. You can use the Expression Wizard to map the arguments of a function with appropriate values. You can use expression functions both when importing and when exporting data from Microsoft Dynamics 365 Business Central.

Concept

An expression function calls Microsoft Dynamics 365 Business Central functions during mapping. Each function can have its own set of arguments. These functions are available to users via expressions. There is virtually no limit on how often you can use a function in a single expression.

Codeunit:11070243.XUPPERCASE(Codeunit:11070243.XLOWERCASE(Codeunit:11070243.XUPPERCASE(Codeunit:11070243.XCOMPANYNAME())))

Registering

To use functions in the Expression Wizard, register the functions in the Function Library. This is explained in Expression Function. The function library contains the collection of standard functions and you can easily extend it with custom functions.

Standard expression functions

Business Integration Solutions includes standard functions. Some products may add their own additional set. These are registered during product installation.

For a list of all standard functions, see Expression Function.