BizTalk Mapper Extensions UtilityPack: CRM Functoids for BizTalk Server 2020

This post was originally published here

Another day and another blog post about BizTalk Mapper Extensions UtilityPack project migration. Today we will focus on another set of libraries available for BizTalk Server 2020: CRM Functoids created a few years ago by Salvatore Pellitteri.

CRM Functoids

This functoids allow you to Integrate Directly with the Dynamics CRM SOAP API, avoiding the use of inline XSLT Call template script function.

MSCRM requires that different data types are specified in a different way. For this reason, we provide a set of functoid each for a specific data type.

This project includes the following Custom Functoids:

MSCRM Map Helper Base Types Functoid: Use this functoid when you want map CRM base data types such as xs:string, xs:int, and so on.
- The functoid takes three mandatory input parameters:
  - Source Field: Link from source schema field value.
  - Target Field Name: CRM target field name.
  - Target Field Type: CRM target field type (Example: “xs:dateTime”).
- The output of this functoid should be linked to:
  - ///entity/Attributes/KeyValuePairOfstringanyType/key.
MSCRM Map Helper GUID Functoid: Use this functoid when you want map CRM GUID type.
- The functoid takes two mandatory input parameters:
  - Source Field: Link from source schema field value.
  - Target Field Name: CRM target field name
- The output of this functoid should be linked to:
  - ///entity/Attributes/KeyValuePairOfstringanyType/key
- You may use this functoid in combination with CRM Lookup functoid, where first find for entity GUID and then use the result to map to the destination schema.
MSCRM Map Helper Money Functoid: Use this functoid when you want map CRM money type.
- The functoid takes two mandatory input parameters:
  - Source Field: Link from source schema field value.
  - Target Field Name: CRM target field name.
- The output of this functoid should be linked to:
  - ///entity/Attributes/KeyValuePairOfstringanyType/key
MSCRM Map Helper Option Value Functoid: Use this functoid when you want map CRM option value type.
- The functoid takes two mandatory input parameters:
  - Source Field: Link from source schema field value.
  - Target Field Name: CRM target field name.
- The output of this functoid should be linked to:
  - ///entity/Attributes/KeyValuePairOfstringanyType/key
MSCRM Map Helper References Functoid: Use this functoid when you want map CRM reference type.
- The functoid takes three mandatory input parameters:
  - Source Field: Link from source schema field value.
  - Target Field Name: CRM target field name.
  - Entity Name: CRM referenced entity.
- The output of this functoid should be linked to:
  - ///entity/Attributes/KeyValuePairOfstringanyType/key

How to use it

You need to use these functoids in two steps:

First Step: specify the CRM Entity Name on the LogicalName element.

Second Step: define the Key values

BizTalk Mapper Extensions UtilityPack

BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities.