# 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 |
---|---|

Advanced 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 Used to convert to and from ASCII, and between numeric bases. |
ASCII to Character, Character to ASCII, Hexadecimal, Octal |

Cumulative Used to perform mathematical operations in looping records, such as averages and concatenation. |
Cumulative Average, Cumulative Concatenate, Cumulative Maximum, Cumulative Minimum, Cumulative Sum |

Database 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 |

Logical 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 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 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 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

The purpose of a functoid is usually obvious from its name.

Note

All functoids included with Microsoft BizTalk Server are inline C#, except for the **Database** functoids.