Microsoft Dynamics GP Connector - Mule 4

In Studio, create a Mule project.

Click the Exchange icon (X) in the upper-left of the Studio task bar.

In Exchange, click Login and supply your Anypoint Platform username and password.

In Exchange, search for "gp".

Select the connector and click Add to project.

Follow the prompts to install the connector.

In Studio, create a Mule project.

In the Mule Palette view, click (X) Search in Exchange.

In Add Modules to Project, type "gp" in the search field.

Click this connector’s name in Available modules.

Click Add.

Click Finish.

Drag the connector operation to the Studio Canvas (they are the same that are in Design Center).

Configure the global element for the connector (just like in Design Center):

From the Mule Palette drag an HTTP Listener element to the canvas and use the default configuration but with the path set to /createCustomer.

Drag a Transform Message element next to the HTTP Listener and add:

%dw 2.0
output application/xml
ns ns0 http://schemas.microsoft.com/dynamics/gp/2010/01
ns ns01 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.Common
ns ns02 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.GP
ns xsi http://www.w3.org/2001/XMLSchema-instance
---
{
	ns0#CreateCustomer: {
		ns0#customer: {
			ns02#Key: {
				ns02#Id: attributes.queryParams.customerKeyID
			},
			ns02#Name: attributes.queryParams.customerName
		},
		ns0#context: {
			ns01#OrganizationKey @(xsi#"type": "ns01:CompanyKey") : {
				ns01#Id: attributes.queryParams.companyKeyID
			}
		}
	}
}

Drag a Microsoft Dynamics GP connector next to the Transform Message.

Set its configuration and fill in the required fields, this applies to any other Dynamics GP connectors that are dragged into the flows.

Select the operation Create Entity. Pick the Customer entity from the drop-down list. Leave the Input Reference as it is.

Drag a Set Payload element next to the Connector and set its value to Success.

From the Mule Palette, drag an HTTP Listener element to the canvas and use the default configuration but with the path set to /getCustomer.

Drag a Transform Message element next to the HTTP Listener and add:

%dw 2.0
output application/xml
ns ns0 http://schemas.microsoft.com/dynamics/gp/2010/01
ns ns01 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.GP
ns ns02 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.Common
ns xsi http://www.w3.org/2001/XMLSchema-instance
---
{
	ns0#GetCustomerByKey: {
		ns0#key: {
			ns01#Id: attributes.queryParams.customerKeyID
		},
		ns0#context: {
			ns02#OrganizationKey @(xsi#"type": "ns02:CompanyKey") : {
				ns02#Id: attributes.queryParams.companyKeyID
			}
		}
	}
}

Drag a Microsoft Dynamics GP connector next to the Transform Message.

Select the operation Get Entity By Key. Pick the Customer entity from the drop-down list. Leave the Input Reference as it is.

Drag a Transform Message next to the connector and add:

%dw 2.0
output application/json
---
payload

From the Mule Palette, drag an HTTP Listener element to the canvas and use the default configuration but with the path set to /updateCustomer.

Drag a Transform Message element next to the HTTP Listener and add:

%dw 2.0
output application/xml
ns ns0 http://schemas.microsoft.com/dynamics/gp/2010/01
ns ns01 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.Common
ns ns02 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.GP
ns xsi http://www.w3.org/2001/XMLSchema-instance
---
{
	ns0#GetCustomerByKey: {
		ns0#key: {
			ns02#Id: attributes.queryParams.keyId
		},
		ns0#context: {
			ns01#OrganizationKey @(xsi#"type": "ns01:CompanyKey") : {
				ns01#Id: attributes.queryParams.companyKeyID
			}
		}
	}
}

Create a variable called 'updatedComment' on this Transform Message with this value:

%dw 2.0
output application/java
---
{
	comment1: payload.customer.comment1
}

Drag a Microsoft Dynamics GP connector next to the Transform Message.

Select the Get Entity By Key operation. Pick the Customer entity from the drop-down list. Leave the Input Reference as it is.

Drag a Transform Message element next to the Connector and add:

%dw 2.0
output application/java
---
%dw 2.0
output application/xml
ns ns0 http://schemas.microsoft.com/dynamics/gp/2010/01
ns ns01 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.Common
ns ns02 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.GP
ns xsi http://www.w3.org/2001/XMLSchema-instance
---
{
	ns0#UpdateCustomer: {
		ns0#customer: {
			ns02#Comment1: vars.comment1,
			ns02#Key: {
				ns02#Id: payload.key.id
			},
			ns02#Name: payload.name
		},
		ns0#context: {
			ns01#OrganizationKey @(xsi#"type": "ns01:CompanyKey") : {
				ns01#Id: attributes.queryParams.companyKeyID
			}
		}
	}
}

Drag a Microsoft Dynamics GP connector next to the Transform Message.

Select the Update Entity operation. Pick the Customer entity from the drop-down list. Leave the Input Reference as it is.

Drag a Set Payload element next to the connector and set its value to Success.

From the Mule Palette, drag an HTTP Listener element to the canvas and use the default configuration but with the path set to /deleteCustomer.

Drag a Transform Message element next to the HTTP Listener and add:

%dw 2.0
output application/xml
ns ns0 http://schemas.microsoft.com/dynamics/gp/2010/01
ns ns01 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.GP
ns ns02 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.Common
ns xsi http://www.w3.org/2001/XMLSchema-instance
---
{
	ns0#DeleteCustomer: {
		ns0#key: {
			ns01#Id: attributes.queryParams.customerKeyID
		},
		ns0#context: {
			ns02#OrganizationKey @(xsi#"type": "ns02:CompanyKey") : {
				ns02#Id: attributes.queryParams.companyKeyID
			}
		}
	}
}

Drag a Microsoft Dynamics GP connector next to the Transform Message.

Select the Delete Entity. Pick the Customer entity from the drop-down list. Leave the Input Reference as it is.

Drag a Set Payload element next to the connector and set its value to Success.

From the Mule Palette, drag an HTTP Listener element to the canvas and use the default configuration but with the path set to /getCustomerList.

Drag a Transform Message element next to the HTTP Listener and add:

%dw 2.0
output application/xml
ns ns0 http://schemas.microsoft.com/dynamics/gp/2010/01
ns ns01 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.Common
ns ns02 http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.GP
ns xsi http://www.w3.org/2001/XMLSchema-instance
---
{
	ns0#GetCustomerList: {
		ns0#criteria: {
			ns02#Name: {
				ns01#Like: attributes.queryParams.like
			}
		},
		ns0#context: {
			ns01#OrganizationKey @(xsi#"type": "ns01:CompanyKey") : {
				ns01#Id: attributes.queryParams.companyKeyID
			}
		}
	}
}

Drag a Microsoft Dynamics GP connector next to the Transform Message.

Select the Get Entity List. Pick the Customer entity from the drop-down list. Leave the Input Reference as it is.

Drag a Transform Message next to the connector and add:

%dw 2.0
output application/json
---
payload