org.mule.modules

mule-module-ms-dynamics-crm-ondemand

config

Namespace	http://www.mulesoft.org/schema/mule/dynamicscrm
Schema Location	http://www.mulesoft.org/schema/mule/dynamicscrm/current/mule-dynamicscrm.xsd (View Schema)
Schema Version	1.4
Minimum Mule Version	3.2

Module Overview

Microsoft Dynamics CRM 2011 Ondemand version

This connector allow the integration with MS Dynamics CRM 2011 Ondemand version.

The service of MS Dynamics CRM provide a few operations that are extensible for all the entities (default and custom) created. A list of the default entities can be found in the MSDN documentation link: "http://msdn.microsoft.com/en-us/library/bb959317.aspx

The connector uses Windows Live ID for Authentication.

To use this connector you need a Windows Live ID Account and a Microsoft Dynamics CRM (2011) Online Account

Summary

Configuration
<dynamicscrm:config> Configure an instance of this module

Message Processors
<dynamicscrm:associate> Associate a set of entities
<dynamicscrm:create> Create entity
<dynamicscrm:delete> Delete entity
<dynamicscrm:disassociate> Disassociate a set of entities
<dynamicscrm:execute> Execute a business logic method
<dynamicscrm:retrieve> Retrieve entity
<dynamicscrm:retrieve-multiple-by-attributes> Retrieve multiple entities by attributes values and sorting options
<dynamicscrm:retrieve-multiple-by-query> Retrieve multiple entities by a query described by and XML The definition of the Microsoft XML Query Language can be found in the Schema Definition in this link: http://msdn.microsoft.com/en-us/library/bb930489.aspx The aggregation examples can be found in this link: http://msdn.microsoft.com/en-us/library/gg309565.aspx
<dynamicscrm:update> Update entity

Configuration

To use the this module within a flow the namespace to the module must be included. The resulting flow will look similar to the following:

<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:dynamicscrm="http://www.mulesoft.org/schema/mule/dynamicscrm"
      xsi:schemaLocation="
               http://www.mulesoft.org/schema/mule/core
               http://www.mulesoft.org/schema/mule/core/current/mule.xsd
               http://www.mulesoft.org/schema/mule/dynamicscrm
               http://www.mulesoft.org/schema/mule/dynamicscrm/current/mule-dynamicscrm.xsd">

      <!-- here goes your flows and configuration elements -->

</mule>

Connection Pool

This connector offers automatic connection management via the use of a connection pool. The pool will act a storage mechanism for all the connections that are in-use by the user of this connector.

Prior to execution of a processor, the connector will attempt to lookup an already established connection and if one doesn't exists it will create one. That lookup mechanism is done in the connection pool via the use of connection variables declared as keys.

The user of the connector can configure the pool by adding a connection-pooling-profile to the connector configuration like this:

    <dynamicscrm:connection-pooling-profile maxActive="10" maxIdle="10"
                             exhaustedAction="WHEN_EXHAUSTED_GROW" maxWait="120" minEvictionMillis="60000" evictionCheckIntervalMillis="30000"/>

The following is a list of connection attributes, each connection attribute can be configured at the config element level or they can also be added to each processor. If they are used at the processor level they get the benefit of full expression resolution.

Connection Attributes
Name	Default Value	Description	Java Type	MIME Type	Encoding
config-ref		Optional. Specify which configuration to use.
username		The username in user@email.com format	String	/	UTF-8
password		The password for the user	String	/	UTF-8
organizationServiceUrl		The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Reconnection Strategies

Reconnection Strategies specify how a connector behaves when its connection fails. You can control how Mule attempts to reconnect by specifying a number of criteria:

The type of exception
Number and frequency of reconnection attempts
The notifications generated, and more

With a reconnection strategy, you can better control the behavior of a failed connection, by configuring it, for example, to re-attempt the connection only once every 15 minutes, and to give up after 30 attempts. You can also send an automatic notification to your IT administrator whenever this reconnection strategy goes into effect. You can even define a strategy that attempts to reconnect only during business hours. Such a setting can prove useful if your server is frequently shut down for nightly maintenance.

Configuration

A reconnection strategy that allows the user to configure how many times a reconnection should be attempted and how long to wait between attempts.

    <dynamicscrm:config>
         <reconnect count="5" frequency="1000"/>
    </dynamicscrm:config>

Reconnect Attributes
Name	Default Value	Description
frequency	2000	Optional. How often (in ms) to reconnect
count	2	Optional. How many reconnection attempts to make

For more information about reconnection strategies in Mule, or even how to write your own custom reconnection strategy please check this section.

Message Processors

<dynamicscrm:associate>

Associate a set of entities

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
entityName	Logical name of entity	String	/	UTF-8
entityId	Guid of entity in string form	String	/	UTF-8
relationshipEntityRoleIsReferenced	If the role of the entity is "Referenced" (true) of "Referencing" (false)	Boolean	/
relationshipSchemaName	The type of relationship	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Default Value	Description	Java Type
<dynamicscrm:related-entities-attributes>		List of the attributes of related entities	List<Map<String, Object>>

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceAssociateOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:create>

Create entity

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
logicalName	A logical name	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Default Value	Description	Java Type
<dynamicscrm:entity>		An entity object represented as a map	Map<String, Object>

Returns

Return Type	Description
String	The GUID of the created entity.

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceCreateOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:delete>

Delete entity

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
logicalName	Logical name of the entity to be updated	String	/	UTF-8
guid	The guid of the entity to be retrieved	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceDeleteOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:disassociate>

Disassociate a set of entities

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
entityName	Logical name of entity	String	/	UTF-8
entityId	Guid of entity in string form	String	/	UTF-8
relationshipEntityRoleIsReferenced	If the role of the entity is "Referenced" (true) of "Referencing" (false)	Boolean	/
relationshipSchemaName	The type of relationship	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Default Value	Description	Java Type
<dynamicscrm:related-entities-attributes>		List of the attributes of related entities	List<Map<String, Object>>

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceDisassociateOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:execute>

Execute a business logic method

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
requestName	Logical name of request to be made	String	/	UTF-8
requestGuid	Optional. The guid of the request to me made	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Default Value	Description	Java Type
<dynamicscrm:request-parameters>		A collection of parameters to the request in Map form	Map<String, Object>

Returns

Return Type	Description
Map<String, Object>	organization response to execute request

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceExecuteOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:retrieve>

Retrieve entity

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
logicalName	Name od the entity to be retrieved	String	/	UTF-8
guid	The guid of the entity to be retrieved	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Default Value	Description	Java Type
<dynamicscrm:attributes>		Attributes that will be retrieved from the entity specified	List<String>

Returns

Return Type	Description
Map<String, Object>	attributes of specified entity in Map form

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceRetrieveOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:retrieve-multiple-by-attributes>

Retrieve multiple entities by attributes values and sorting options

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
entityName	Name of the entity type	String	/	UTF-8
count	Optional. Number of rows to retrieve	Integer	/
pageNumber	Optional. Number of page to retrieve	Integer	/
pagingCookie	Optional. Paging cookie	String	/	UTF-8
returnTotalRecordCount	Optional. If total record count should be returned	Boolean	/
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Description	Java Type
<dynamicscrm:columns>	Columns to retrieve	List<String>
<dynamicscrm:attributes>	Attributes to filter by	List<String>
<dynamicscrm:values>	Values of the attributes	List<String>
<dynamicscrm:orders>	Optional. Ordering fields, key is the name, value is "Ascending" or "Descending"	Map<String, String>

Returns

Return Type	Description
List<Map<String, Object>>	entities retrieved

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceRetrieveMultipleOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:retrieve-multiple-by-query>

Retrieve multiple entities by a query described by and XML

The definition of the Microsoft XML Query Language can be found in the Schema Definition in this link: http://msdn.microsoft.com/en-us/library/bb930489.aspx

The aggregation examples can be found in this link: http://msdn.microsoft.com/en-us/library/gg309565.aspx

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
queryXml	Query XML	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Returns

Return Type	Description
List<Map<String, Object>>	entities retrieved

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceRetrieveMultipleOrganizationServiceFaultFaultFaultMessage

<dynamicscrm:update>

Update entity

XML Sample

INCLUDE_ERROR

Attributes

Name	Description	Java Type	MIME Type	Encoding
config-ref	Optional. Specify which configuration to use.
logicalName	Logical name of the entity to be updated	String	/	UTF-8
guid	The guid of the entity to be retrieved	String	/	UTF-8
Connection Parameters This are only required if you didn't specified them at the configuration element. They are also useful for overriding the values of the configurations or even if you need to extract them from the Mule message since they support expression evaluation.
username	Optional. The username in user@email.com format	String	/	UTF-8
password	Optional. The password for the user	String	/	UTF-8
organizationServiceUrl	Optional. The organization Url. This can be found inside the Dynamics CRM system. For more detail where to find this parameter check this link	String	/	UTF-8

Child Elements

Name	Default Value	Description	Java Type
<dynamicscrm:attributes-to-update>		The attributes that will be updated, in Map form	Map<String, Object>

Exception Payloads

Payload Class	Description
ConnectionException	If the credentials has expired. This will generate a reconnection attempt
IOrganizationServiceRetrieveOrganizationServiceFaultFaultFaultMessage
IOrganizationServiceUpdateOrganizationServiceFaultFaultFaultMessage

mule-module-ms-dynamics-crm-ondemand

Module Overview

Summary

Configuration

Connection Pool

Reconnection Strategies

Configuration

Message Processors

<dynamicscrm:associate>

XML Sample

Attributes

Child Elements

Exception Payloads

<dynamicscrm:create>

XML Sample

Attributes

Child Elements

Returns

Exception Payloads

<dynamicscrm:delete>

XML Sample

Attributes

Exception Payloads

<dynamicscrm:disassociate>

XML Sample

Attributes

Child Elements

Exception Payloads

<dynamicscrm:execute>

XML Sample

Attributes

Child Elements

Returns

Exception Payloads

<dynamicscrm:retrieve>

XML Sample

Attributes

Child Elements

Returns

Exception Payloads

<dynamicscrm:retrieve-multiple-by-attributes>

XML Sample

Attributes

Child Elements

Returns

Exception Payloads

<dynamicscrm:retrieve-multiple-by-query>

XML Sample

Attributes

Returns

Exception Payloads

<dynamicscrm:update>

XML Sample

Attributes

Child Elements

Exception Payloads

Message Sources

Transformers