Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Functoid Reference

[Unless specifically noted, the content in this topic applies to BizTalk Server 2013 and 2013 R2.]

BizTalk Mapper provides an extensive set of functoids that can be used in maps to perform a variety of operations on data that is being transformed from a source instance message to a destination instance message. This section provides reference information about the BizTalk Mapper functoids.

Because Microsoft BizTalk Server uses the underlying functionality of the .NET Framework, the results produced by some functoids vary from the equivalent functoids in previous versions of BizTalk Server. You should test your maps thoroughly to ensure you are getting the results you expect.

Whenever an input parameter to a functoid is not valid, a default value is passed to the functoid in its place. For numeric input parameters, the default value is zero (0). For all other input parameters, the default value is blank.

The above doesn’t apply to all the functoids. For instance, the default value is applied to functoids like MathAdd, but not applied to functoids like MathSqrt or GetCummulativeAvg.

If a functoid connects to a Record node in the destination schema, that node should have its Mixed property set to True for the output document to be valid against the schema. This is because the functoid writes data into the corresponding element. The Mixed property may be set to False if the Content Type is SimpleContent.

The following table shows the categories into which these functoids have been divided.


Functoid Category Description

Advanced Functoids Reference

Use Advanced functoids to create various types of data manipulation, such as implementing custom script, value mapping, and managing and extracting data from looping records.

Conversion Functoids Reference

Use Conversion functoids to convert characters to and from their numeric representation, and to convert numbers from one base to another.

Cumulative Functoids Reference

Use Cumulative functoids to perform various types of accumulation operations for values that occur multiple times within an instance message.

Database Functoids Reference

Use Database functoids to look up data from a database and to perform simple cross-referencing operations (sometimes called ID mapping).

Date and Time Functoids Reference

Use Date and Time functoids to add date, time, date and time, or add days to a specified date, in output data.

Logical Functoids Reference

Use Logical functoids to conditionally control the behavior of other functoids and to determine whether particular output data is created.

Mathematical Functoids Reference

Use Mathematical functoids to perform specific numeric calculations such as addition, multiplication, and division.

Scientific Functoids Reference

Use Scientific functoids to perform specific scientific calculations such as logarithmic, exponential, and trigonometric functions.

String Functoids Reference

Use the String functoids to manipulate data strings by using well-known string functions such as concatenation, length, find, and trim.

© 2014 Microsoft Corporation. All rights reserved.

Community Additions

© 2015 Microsoft