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. 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.
|
Functoid category
Category description
|
Functoids in category
|
|
Advanced (Advanced Functoids Reference)
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)
|
|
Conversion (Conversion Functoids Reference)
Used to convert to and from ASCII, and between numeric bases.
|
ASCII to Character, Character to ASCII, Hexadecimal, Octal
|
|
Cumulative (Cumulative Functoids Reference)
Used to perform mathematical operations in looping records, such as averages and concatenation.
|
Cumulative Average, Cumulative Concatenate, Cumulative Maximum, Cumulative Minimum, Cumulative Sum
|
|
Database (Database Functoids Reference)
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 (Date and Time Functoids Reference)
Used to retrieve the current date and time, and to calculate delta times.
|
Add Days, Date, Date and Time, Time
|
|
Logical (Logical Functoids Reference)
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
|
|
Mathematical (Mathematical Functoids Reference)
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
|
|
Scientific (Scientific Functoids Reference)
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
|
|
String (String Functoids Reference)
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
|
Note 