Resources For IT Professionals
Page Details
  • First published by (fMicrosoft Partne)
  • When: 15 Jun 2012 4:25 AM
  • Last revision by (fMicrosoft Partne)
  • When: 6 Sep 2013 2:14 AM
  • Revisions: 28
  • Comments: 13
Options

Revision #20

Wiki  >  TechNet Articles  >  BizTalk: List of Custom Functoids  >  Revision #20
BizTalk: List of Custom Functoids
You are currently reviewing an older revision of this page.
Go to current version

Table of Contents



Resources

Custom Functoids

This list is intended to be a knowledge base of all Custom Functoids that are available:

Name Description
eliasen.eu.BizTalk.Functoids
  • Add Carriage Return and Line Feed - This functoid adds Carriage Return (0x0D) and/or Line Feed (0x0A) to a string.
  • Convert First Letter to Uppercase - This functoid converts a string into the same string, with all words inside the string having been converted to lowercase with a capital first letter.
  • CSV Extract - This functoid extracts a certain substring from a string separated given a separator and a position.
  • Cumulative Comma - This functoid creates a comma separated list of values based on a reoccurring element.
  • Date Converter - This functoid converts a string representing a datetime from one format to another format, completely customizable
  • If Then Else - This functoid helps you deal with the If-Then-Else issue in maps.
  • New GUID - This functoid returns a newly generated and unique GUID.
  • Read Application Config - This functoid reads a value from BizTalk's app.config file.
  • String Replace - This functoid replaces a string inside another string with a third string. It simply uses the String.Replace method in .NET 2.0.
BizTalk Map Extension Utility Pack
also available here: 2010 | 2006
  • Convert to epoch date (unix) format - This functoid allows you to convert a traditional date (Human Readable Date) into a unix date (Epoch Date).
  • Convert from epoch date (unix) format - This functoid allows you to convert a unix date (Epoch Date) into a traditional date (Human Readable Date).
  • Convert datetime format: This functoid allows you to convert datetime format
  • Password Generator - Use this functoid to build a random password.
  • Guid Generator - This functoid allows you to generate a new Guid.
  • Tiny Id Generator - This functoid allows you to generate a new Tiny Id.
  • Base64 Encoder - This functoid allows you to decode Base64-encoded text strings.
  • Base64 Decoder - This functoid allows you to convert string object into base64 encoded string.
  • BTSNTSvc Config Get: This functoid allows you to get configuration parameters from BTSNTsvc.exe.config. If there is no section specified, the functoid reads from the AppSettings.
  • System Environment Variable Get: This functoid allows you to get configuration parameters from machine System Environment Variable.
  • Custom Config Get: This functoid allows you to get configuration parameters from a custom configuration file.
  • Windows Registry Config Get: This functoid allows you to get configuration parameters from Windows Registry.
  • SSO Config Get: This functoid allows you to get configuration parameters from SSO Database.
  • CRM Lookup: This functoid allows you to retrieve a value from CRM lookup field.
  • String Constant - This functoid allows you to set constant values (strings) inside de maps.
  • String ToTitleCase - This functoid allows you to Converts the specified string to title case (except for words that are entirely in uppercase, which are considered to be acronyms)
  • String Advance Compare - This functoid allows you to compare two specified String objects, ignoring or honoring their case, and returns an boolean that indicates if they are equal or not.
  • String Replace - This functoid returns a new string in which all occurrences of a specified string (second parameter) found in the first string are replaced with another specified string (third parameter).
  • String Normalize - This functoid allows you to normalize the text. It will remove two or more consecutive spaces and replace them with a single space, remove two or more consecutive newlines and replace them with a single newline and “condense” multiple tabs into one.
  • String PadLeft - This functoid allows you to set a new string that right-aligns the characters in this instance by padding them on the left with a specified Unicode character, for a specified total length.
  • String PadRight - This functoid allows you to set a new string that left-aligns the characters in this string by padding them on the right with a specified Unicode character, for a specified total length.
BizTalk Functoids Library
  • ConvertDate - convert a date from one pattern to another.
RestFunctoids
  • REST Consume - This functoid consumes a REST service and returns its response.
  • XPath Extractor - This functoid extracts a part from a XML document.
My Functoids - Will upload somewhere soon
  • Pad - Add a repeating character before or after a value to a specified length (e.g. add leading zeros).
  • Truncate - Set max length. Trims any subsequent characters.
  • Replace Carriage Returns and line feeds.
Packed Decimal Converter Functoid
  • Double to Packed Packed Decimal - Convert from double to Packed Decimals.
  • Packed Decimal to Double - Convert from Packed Decimals to Double.
Encryption Functoid
  • DecryptionFunctoid
Currency Converter Functoid
  • Currency converter
Database lookup functoid with caching
  • ActionQuery - execute a stored procedure and return a single value.
  • ExecuteQuery - execute queries from the database. Each query will only be executed once.
  • ExtractData - is used to extract the appropriate column value from a recordset returned by the Execute Query functoid.
DBFunktoids
DBFunktoids for BizTalk Server 2010 here.
  • Stored Procedure Runner - executes SQL Server stored procedures
  • Value Extractor - retrieves a value corresponding to a column name from the first row of records returned by the stored procedure
  • Error Extractor - retrieves a value corresponding to a column name from the first row of records returned by the stored procedure
ContextAccessor Functoids
  • Get Message Context Property values. (2 different functoids depending on whether the map is called from an orchestration or a port.)
EventLog Functoid
  • Will write to eventlog any output of string data type. It takes up 1 parameter and will return 1 parameter. It will return the same string after writing to eventlog.

See Also

Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki

Revert to this revision