Microsoft Dynamics NAV Connector

<mule xmlns:dynamics-nav="http://www.mulesoft.org/schema/mule/dynamics-nav"
  ...
  xsi:schemaLocation="http://www.mulesoft.org/schema/mule/dynamics-nav http://www.mulesoft.org/schema/mule/dynamics-nav/current/mule-dynamics-nav.xsd">
  ...
  <flow name="yourFlow">
  ...
  </flow>
</mule>

  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

  
<?xml version="1.0" encoding="UTF-8"?>

<mule xmlns:metadata="http://www.mulesoft.org/schema/mule/metadata" xmlns:mulexml="http://www.mulesoft.org/schema/mule/xml" xmlns:dw="http://www.mulesoft.org/schema/mule/ee/dw" xmlns:json="http://www.mulesoft.org/schema/mule/json" xmlns:tracking="http://www.mulesoft.org/schema/mule/ee/tracking" xmlns:dynamics-nav="http://www.mulesoft.org/schema/mule/dynamics-nav" xmlns:http="http://www.mulesoft.org/schema/mule/http" xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation"
        xmlns:spring="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd
http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
http://www.mulesoft.org/schema/mule/dynamics-nav http://www.mulesoft.org/schema/mule/dynamics-nav/current/mule-dynamics-nav.xsd
http://www.mulesoft.org/schema/mule/ee/dw http://www.mulesoft.org/schema/mule/ee/dw/current/dw.xsd
http://www.mulesoft.org/schema/mule/ee/tracking http://www.mulesoft.org/schema/mule/ee/tracking/current/mule-tracking-ee.xsd
http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd
http://www.mulesoft.org/schema/mule/xml http://www.mulesoft.org/schema/mule/xml/current/mule-xml.xsd">
    <http:listener-config name="HTTP_Listener_Configuration" host="0.0.0.0" port="8081" doc:name="HTTP Listener Configuration"/>
    <dynamics-nav:config-oauth-token name="Microsoft_Dynamics_NAV_Connector__OAuth_2_0_Access_Token" username="${nav.username}" accessToken="${nav.accessToken}" soapUrl="${nav.soapUrl}" odataUrl="${nav.odataUrl}" companyName="${nav.companyName}" disableCnCheck="true" doc:name="Microsoft Dynamics NAV Connector: OAuth 2.0 Access Token"/>
    <flow name="CreateCountryAndGetRecID">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/create" doc:name="/create"/>
        <dw:transform-message doc:name="Send Input as an Object">
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
---
{
    Code : inboundProperties."http.query.params".code,
    Name : inboundProperties."http.query.params".name
}]]></dw:set-payload>
        </dw:transform-message>
        <dynamics-nav:page-operation config-ref="Microsoft_Dynamics_NAV_Connector__OAuth_2_0_Access_Token" serviceOperation="Countries||Create" doc:name="Create Country"/>
        <dw:transform-message doc:name="Extract the Key">
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
---
{
        Key : payload.Key
}]]></dw:set-payload>
        </dw:transform-message>
        <dynamics-nav:page-operation config-ref="Microsoft_Dynamics_NAV_Connector__OAuth_2_0_Access_Token" serviceOperation="Countries||GetRecIdFromKey" doc:name="Get Record ID"/>
    </flow>
    <flow name="ReadCountry_ODataAndSOAPInSameFlow">
        <http:listener config-ref="HTTP_Listener_Configuration" path="/read" doc:name="/read"/>
        <set-variable variableName="CountriesList" value="#[[]]" doc:name="Countries List"/>
        <dynamics-nav:odata-query config-ref="Microsoft_Dynamics_NAV_Connector__OAuth_2_0_Access_Token" query="dsql:SELECT Code,Name FROM Countries ORDER BY Code DESC LIMIT 5" doc:name="OData Query"/>
        <foreach doc:name="For Each">
                    <expression-filter expression="#[!payload.Code.isEmpty()]" doc:name="Filter Countries with empty Code value"/>
                    <dw:transform-message doc:name="Extract Code">
                        <dw:set-payload><![CDATA[%dw 1.0
%output application/java
---
{
        Code : payload.Code
}]]></dw:set-payload>
                    </dw:transform-message>
                    <dynamics-nav:page-operation config-ref="Microsoft_Dynamics_NAV_Connector__OAuth_2_0_Access_Token" serviceOperation="Countries||Read" doc:name="Read Country"/>
                    <expression-component doc:name="Add Country to Countries List"><![CDATA[#[flowVars.CountriesList.add(payload)]]]></expression-component>
        </foreach>
        <set-payload value="#[flowVars.CountriesList]" doc:name="Set the list as payload"/>
        <json:object-to-json-transformer doc:name="Object to JSON"/>
    </flow>
</mule>