BizTalk Mapper Extensions UtilityPack: CRM Functoids for BizTalk Server 2020

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.

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2020

Where to download?

You can download this functoid along with all the existing one on the BizTalk Mapper Extensions UtilityPack  here:

BizTalk Mapper Extensions UtilityPack GitHub RepositoryBizTalk Mapper Extensions UtilityPack
GitHub

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top