BizTalk functoids are divided into categories according to their intended use. For example, database functoids are designed for extracting data from a database at run time, mathematical functoids are used to perform mathematical operations, and so on. In BizTalk Mapper, functoids appear by category in the Visual Studio Toolbox.
Categories & description
The following table shows the functoid categories, briefly describes the category, and shows the list of functoids in each category, including links to their corresponding reference pages.
|Functoids in category|
Primarily used with looping records. Also used for running arbitrary script or compiled code.
|Assert, Index, Iteration, Looping, Mass Copy, Nil Value, Record Count, Scripting, Table Extractor, Table Looping, Value Mapping, Value Mapping (Flattening)|
Used to convert to and from ASCII, and between numeric bases.
|ASCII to Character, Character to ASCII, Hexadecimal, Octal|
Used to perform mathematical operations in looping records, such as averages and concatenation.
|Cumulative Average, Cumulative Concatenate, Cumulative Maximum, Cumulative Minimum, Cumulative Sum|
Used to extract data from a database and use it in destination instance messages.
|Database Lookup, Error Return, Format Message, Get Application ID, Get Application Value, Get Common ID, Get Common Value, Remove Application ID, Set Common ID, Value Extractor|
|Date and Time
Used to retrieve the current date and time, and to calculate delta times.
|Add Days, Date, Date and Time, Time|
Used to perform a variety of logical operations, such as greater than and logical existence.
|Equal, Greater Than, Greater Than or Equal To, IsNil, Less Than, Less Than or Equal To, Logical AND, Logical Date, Logical Existence, Logical Numeric, Logical NOT, Logical OR, Logical String, Not Equal|
Used to perform a variety of mathematical operations, such as addition and multiplication.
|Absolute Value, Addition, Division, Integer, Maximum Value, Minimum Value, Modulo, Multiplication, Round, Square Root, Subtraction|
Used to perform a variety of scientific operations, such as logarithms and trigonometry.
|10^n, Arc Tangent, Base-Specified Logarithm, Common Logarithm, Cosine, Natural Exponential Function, Natural Logarithm, Sine, Tangent, X^Y|
Used to perform a variety of string functions, such as trimming and concatenation.
|Lowercase, Size, String Concatenate, String Extract, String Find, String Left, String Left Trim, String Right, String Right Trim, Uppercase|
The purpose of a functoid is usually obvious from its name.
All functoids included with Microsoft BizTalk Server are inline C#, except for the Database functoids.