Functoid Categories

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.

Functoid category

Category description
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.

See Also

Basic Functoids
Advanced Functoids