# mulesoft Microsoft Dynamics NAV Connector - Full Documentation --- product: Microsoft Dynamics NAV Connector version: 3.0 --- # Microsoft Dynamics NAV Connector 3.0 > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Anypoint Connector for Microsoft Dynamics NAV (NAV Connector) enables Mule apps to interact with Microsoft Dynamics NAV Web Services. Microsoft Dynamics NAV is a global enterprise resource planning (ERP) solution to assist with finance, manufacturing, customer relationship management, supply chains, analytics, and electronic commerce for small and medium-sized enterprise and local subsidiaries of large international groups. The versions of Microsoft Dynamics NAV supported by this connector are: - 2013 R2 - 2015 - 2016 - 2017 Release Notes: [Microsoft Dynamics NAV Connector Release Notes](https://docs.mulesoft.com/release-notes/connector/ms-dynamics-nav-connector-release-notes-mule-4) Exchange: [Microsoft Dynamics NAV Connector](https://www.mulesoft.com/exchange/com.mulesoft.connectors/mule-microsoft-dynamics-nav-connector/) ## Before You Begin To use this information, you should be familiar with Microsoft Dynamics NAV, Mule runtime engine (Mule), Anypoint Connectors, Anypoint Studio, Mule concepts, elements in a Mule flow, and Global Elements. You need login credentials to test your connection to your target resource. For hardware and software requirements and compatibility information, see the Connector Release Notes. To use this connector with Maven, view the pom.xml dependency information in the Dependency Snippets in Anypoint Exchange. ## POM File Information ```xml com.mulesoft.connectors mule-microsoft-dynamics-nav-connector x.x.x mule-plugin ``` Replace `x.x.x` with the version that corresponds to the connector you are using. To obtain the most up-to-date `pom.xml` file information, access the connector in [Anypoint Exchange](https://www.mulesoft.com/exchange/) and click **Dependency Snippets**. ## Primary Use Cases The Microsoft Dynamics NAV Connector supports these operations:
OperationDescription

Page Operation

Execute one of the operations defined in published Page SOAP services.

Codeunit Operation

Execute one of the operations defined in published Codeunit SOAP services.

OData Query

Execute a Query against one of the NAV entities using the OData endpoint.

## Getting Started Before creating a sample flow, a published Page Service is necessary. See below. ## Connect in Anypoint Studio You can use this connector in Anypoint Studio by first downloading it from Exchange and configuring it as needed. ## Add the Connector to a Studio Project Anypoint Studio provides two ways to add the connector to your Studio project: from the Exchange button in the Studio taskbar or from the Mule Palette view. ### Add the Connector Using Exchange 1. In Studio, create a Mule project. 2. Click the Exchange icon **(X)** in the upper-left of the Studio task bar. 3. In Exchange, click **Login** and supply your Anypoint Platform username and password. 4. In Exchange, search for "nav". 5. Select the connector and click **Add to project**. 6. Follow the prompts to install the connector. ### Add the Connector in Studio 1. In Studio, create a Mule project. 2. In the Mule Palette view, click **(X) Search in Exchange**. 3. In **Add Modules to Project**, type "nav" in the search field. 4. Click this connector’s name in **Available modules**. 5. Click **Add**. 6. Click **Finish**. ### Configure in Studio 1. Drag an HTTP Listener to the Studio Canvas. ![Listener dragged to canvas](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/3.0/_images/ms-dynamics-nav-listener-anypoint.png) 1. Set the Path. 2. Click the green plus sign to configure the listener. 2. Drag a Dynamics Nav operation to the Studio Canvas. 3. Click the green plus sign to add a configuration for the connector. 4. Complete these fields.
ParameterDescription

Domain

Domain of the Dynamics NAV instance.

Username

The Windows username to connect to Dynamics NAV.

Password

The password for the user to connect to Dynamics NAV.

SOAP URL

Base URL where the SOAP services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/WS. Example: https://hostname:7047/DynamicsNAV90/WS

OData URL

Base URL where the OData services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/OData. Example: https://hostname:7048/DynamicsNAV90/OData

Company Name (Optional)

Dynamics NAV Company to which connect. In case the field is left blank, the default configured one is used.

Disable Cn Check

For HTTPS certificates, if the certificate is not signed by a trusted partner, the server might respond with an Exception. To prevent this it is possible to disable the CN (Common Name) check. Note: this is not recommended for production environments.

5. Click OK 6. Configure these fields: ![Dynamics NAV Connector config panel on General tab](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/3.0/_images/ms-dynamics-nav-op-config.png) - Query: The query that to run on Dynamics Nav. - Fetch Size: Number of items retrieved on one page. ## Use Case: Studio ![Query flow](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/3.0/_images/ms-dynamics-nav-flow.png) ## USe Case: XML ```xml dsql: SELECT No FROM SalesOrders LIMIT 5 ``` ## See Also - [Published Page Service information](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/3.0/%3Chttps://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2015/dd355316(v=nav.80)?redirectedfrom=MSDN>) - [Microsoft Dynamics NAV Web Services site](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/3.0/%3Chttps://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2016/dd355036(v=nav.90)?redirectedfrom=MSDN>) - [Salesforce Help](https://help.salesforce.com) --- product: Microsoft Dynamics NAV Connector version: 3.0 --- # Microsoft Dynamics NAV Connector 3.0 Reference > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Release Notes: [Microsoft Dynamics NAV Connector Release Notes](https://docs.mulesoft.com/release-notes/connector/ms-dynamics-nav-connector-release-notes-mule-4) ## Limitations - Microsoft Dynamics NAV Connector isn’t supported in CloudHub 2.0 because the underlying CXF library requires a JDK to generate schema classes. To support Microsoft Dynamics NAV Connector in CloudHub 2.0, the client must provide SOAP requests in raw XML format instead of using Plain Old Java Objects (POJOs). For more information, refer to [Upgrading and Migrating Microsoft Dynamics NAV Connector to Version 3.0](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/3.0/ms-dynamics-nav-connector-upgrade-migrate). ## Dynamics Nav Configuration ### Parameters
NameTypeDescriptionDefault ValueRequired

Name

String

The name for this configuration. Connectors reference the configuration with this name.

x

Connection

  • NTLM

  • OAuth

The connection types that can be provided to this configuration.

x

Expiration Policy

ExpirationPolicy

Configures the minimum amount of time that a dynamic configuration instance can remain idle before the runtime considers it eligible for expiration. This does not mean that the platform expires the instance at the exact moment that it becomes eligible. The runtime actually purges the instances as it sees fit.

## NTLM Connection Type > [!NOTE] The JAXB-XJC external library is required for the NTLM and OAuth connection types for Java > 8, 11, and 17: > > - JAXB-XJC v2.3.2 > > - Mule runtime 4.3.0 with Java 8 and 11 > > - Mule runtime 4.4.0 with Java 8 and 11 > > - JAXB-XJC v2.3.9 > > - Mule runtime 4.5.0 with Java 8 and 11 > > - Mule runtime 4.6.0 with Java 8, 11, and 17 ### Parameters
NameTypeDescriptionDefault ValueRequired

Domain

String

Domain of the Dynamics NAV instance

Username

String

The Windows username to connect to Dynamics NAV

x

Password

String

The Windows password to connect to Dynamics NAV

x

Soap Url

String

Base URL where the SOAP services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/WS. Example: https://hostname:7047/DynamicsNAV90/WS

x

OData Url

String

Base URL where the OData services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/OData. Example: https://hostname:7048/DynamicsNAV90/OData.

x

Company Name

String

Dynamics NAV Company to which connect. In case the field is left blank, the default configured one is used.

Disable SSL certificate validation

Boolean

false

Reconnection

Reconnection

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy

Pooling Profile

PoolingProfile

Characteristics of the connection pool

## OAuth Connection Type Use OAuth 2.0 to delegate user authentication to the service hosting the user account. For more information, refer to [Configuring OAuth 2.0 for Connectors](https://docs.mulesoft.com/connectors/introduction/intro-config-oauth2), [Configuring OAuth 2.0 for Connectors on CloudHub](https://docs.mulesoft.com/connectors/introduction/intro-config-oauth2-cloudhub), or [OAuth Support in the SDK](https://docs.mulesoft.com/mule-sdk/latest/oauth). > [!NOTE] The JAXB-XJC external library is required for the NTLM and OAuth connection types for Java > 8, 11, and 17: > > - JAXB-XJC v2.3.2 > > - Mule runtime 4.3.0 with Java 8 and 11 > > - Mule runtime 4.4.0 with Java 8 and 11 > > - JAXB-XJC v2.3.9 > > - Mule runtime 4.5.0 with Java 8 and 11 > > - Mule runtime 4.6.0 with Java 8, 11, and 17 ### Parameters
NameTypeDescriptionDefault ValueRequired

Username

String

The Windows username to connect to Dynamics NAV

x

Access Token

String

The Windows password to connect to Dynamics NAV

x

Soap Url

String

Base URL where the SOAP services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/WS. Example: https://hostname:7047/DynamicsNAV90/WS

x

OData Url

String

Base URL where the OData services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/OData. Example: https://hostname:7048/DynamicsNAV90/OData.

x

Company Name

String

Dynamics NAV Company to which connect. In case the field is left blank, the default configured one is used.

Disable SSL certificate validation

Boolean

false

Reconnection

Reconnection

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy

Pooling Profile

PoolingProfile

Characteristics of the connection pool

## Associated Operations - Codeunit Operation - OData Query - Page Operation ## Codeunit Operation `` ### Parameters
NameTypeDescriptionDefault ValueRequired

Configuration

String

The name of the configuration to use.

x

Entity

Object

#[payload]

Output Mime Type

String

MIME type of the payload that this operation outputs.

Output Encoding

String

Encoding of the payload that this operation outputs.

Config Ref

ConfigurationProvider

Name of the configuration to use to execute this component.

x

Service

String

x

Operation

String

x

Target Variable

String

The name of a variable on which the operation’s output will be placed

Target Value

String

An expression that will be evaluated against the operation’s output and the outcome of that expression will be stored in the target variable

#[payload]

Error Mappings

Array of Error Mapping

Set of error mappings.

Reconnection Strategy

  • Reconnect

  • Reconnect Forever

A retry strategy in case of connectivity errors

### Output

Type

Any

### For Configurations - dynamics-nav-config ### Throws - NAV:CONNECTIVITY - NAV:INCORRECT\_CREDENTIALS - NAV:RETRY\_EXHAUSTED - NAV:UNKNOWN ## OData Query `` ### Parameters
NameTypeDescriptionDefault ValueRequired

Configuration

String

The name of the configuration to use.

x

Query

String

x

Fetch Size

Number

x

Config Ref

ConfigurationProvider

Name of the configuration to use to execute this component.

x

Streaming Strategy

  • Repeatable In Memory Iterable

  • Repeatable File Store Iterable

Configure if repeatable streams should be used and their behavior

Target Variable

String

The name of a variable on which the operation’s output will be placed

Target Value

String

An expression that will be evaluated against the operation’s output and the outcome of that expression will be stored in the target variable

#[payload]

Error Mappings

Array of Error Mapping

Set of error mappings.

Reconnection Strategy

  • Reconnect

  • Reconnect Forever

A retry strategy in case of connectivity errors

### Output

Type

Array of Object

### For Configurations - dynamics-nav-config ### Throws - NAV:CONNECTIVITY - NAV:INCORRECT\_CREDENTIALS - NAV:UNKNOWN ## Page Operation `` ### Parameters
NameTypeDescriptionDefault ValueRequired

Configuration

String

The name of the configuration to use.

x

Entity

Object

#[payload]

Output Mime Type

String

MIME type of the payload that this operation outputs.

Output Encoding

String

Encoding of the payload that this operation outputs.

Config Ref

ConfigurationProvider

Name of the configuration to use to execute this component.

x

Service

String

x

Operation

String

x

Target Variable

String

The name of a variable on which the operation’s output will be placed

Target Value

String

An expression that will be evaluated against the operation’s output and the outcome of that expression will be stored in the target variable

#[payload]

Error Mappings

Array of Error Mapping

Set of error mappings.

Reconnection Strategy

  • Reconnect

  • Reconnect Forever

A retry strategy in case of connectivity errors

### Output

Type

Any

### For Configurations - dynamics-nav-config ### Throws - NAV:CONNECTIVITY - NAV:INCORRECT\_CREDENTIALS - NAV:RETRY\_EXHAUSTED - NAV:UNKNOWN ## Reconnection Type
FieldTypeDescriptionDefault ValueRequired

Fails Deployment

Boolean

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy

Reconnection Strategy

  • Reconnect

  • Reconnect Forever

The reconnection strategy to use

### Reconnect
FieldTypeDescriptionDefault ValueRequired

Frequency

Number

How often to reconnect (in milliseconds)

Count

Number

The number of reconnection attempts to make

blocking

Boolean

If false, the reconnection strategy runs in a separate, non-blocking thread

true

### Reconnect Forever
FieldTypeDescriptionDefault ValueRequired

Frequency

Number

How often in milliseconds to reconnect

blocking

Boolean

If false, the reconnection strategy runs in a separate, non-blocking thread

true

## Pooling Profile Type
FieldTypeDescriptionDefault ValueRequired

Max Active

Number

Controls the maximum number of Mule components that can be borrowed from a session at one time. When set to a negative value, there is no limit to the number of components that may be active at one time. When maxActive is exceeded, the pool is said to be exhausted.

Max Idle

Number

Controls the maximum number of Mule components that can sit idle in the pool at any time. When set to a negative value, there is no limit to the number of Mule components that may be idle at one time.

Max Wait

Number

Specifies the number of milliseconds to wait for a pooled component to become available when the pool is exhausted and the exhaustedAction is set to WHEN_EXHAUSTED_WAIT.

Min Eviction Millis

Number

Determines the minimum amount of time an object may sit idle in the pool before it is eligible for eviction. When non-positive, no objects will be evicted from the pool due to idle time alone.

Eviction Check Interval Millis

Number

Specifies the number of milliseconds between runs of the object evictor. When non-positive, no object evictor is executed.

Exhausted Action

Enumeration, one of:

  • WHEN_EXHAUSTED_GROW

  • WHEN_EXHAUSTED_WAIT

  • WHEN_EXHAUSTED_FAIL

Specifies the behavior of the Mule component pool when the pool is exhausted. Possible values are: "WHEN_EXHAUSTED_FAIL", which will throw a NoSuchElementException, "WHEN_EXHAUSTED_WAIT", which will block by invoking Object.wait(long) until a new or idle object is available, or WHEN_EXHAUSTED_GROW, which will create a new Mule instance and return it, essentially making maxActive meaningless. If a positive maxWait value is supplied, it will block for at most that many milliseconds, after which a NoSuchElementException will be thrown. If maxThreadWait is a negative value, it will block indefinitely.

Initialisation Policy

Enumeration, one of:

  • INITIALISE_NONE

  • INITIALISE_ONE

  • INITIALISE_ALL

Determines how components in a pool should be initialized. The possible values are: INITIALISE_NONE (will not load any components into the pool on startup), INITIALISE_ONE (will load one initial component into the pool on startup), or INITIALISE_ALL (will load all components in the pool on startup)

Disabled

Boolean

Whether pooling should be disabled

## Expiration Policy Type
FieldTypeDescriptionDefault ValueRequired

Max Idle Time

Number

A scalar time value for the maximum amount of time a dynamic configuration instance should be allowed to be idle before it’s considered eligible for expiration

Time Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the maxIdleTime attribute

### Error Mapping Error mapping.
FieldTypeDescriptionDefault ValueRequired

Source

Enumeration, one of:

  • ANY

  • REDELIVERY_EXHAUSTED

  • TRANSFORMATION

  • EXPRESSION

  • SECURITY

  • CLIENT_SECURITY

  • SERVER_SECURITY

  • ROUTING

  • CONNECTIVITY

  • RETRY_EXHAUSTED

  • TIMEOUT

Source.

Target

String

Target.

x

## Repeatable In Memory Iterable Type
FieldTypeDescriptionDefault ValueRequired

Initial Buffer Size

Number

This is the amount of instances that will be initially be allowed to be kept in memory in order to consume the stream and provide random access to it. If the stream contains more data than can fit into this buffer, then it will be expanded according to the bufferSizeIncrement attribute, with an upper limit of maxInMemorySize. Default value is 100 instances.

Buffer Size Increment

Number

This is by how much will the buffer size expands if it exceeds its initial size. Setting a value of zero or lower will mean that the buffer should not expand, meaning that a STREAM_MAXIMUM_SIZE_EXCEEDED error will be raised when the buffer gets full. Default value is 100 instances.

Max Buffer Size

Number

This is the maximum amount of memory that will be used. If more than that is used then a STREAM_MAXIMUM_SIZE_EXCEEDED error will be raised. A value lower or equal to zero means no limit.

## Repeatable File Store Iterable Type
FieldTypeDescriptionDefault ValueRequired

Max In Memory Size

Number

This is the maximum amount of instances that will be kept in memory. If more than that is required, then it will start to buffer the content on disk.

Buffer Unit

Enumeration, one of:

  • BYTE

  • KB

  • MB

  • GB

The unit in which maxInMemorySize is expressed

## See Also [Salesforce Help](https://help.salesforce.com) --- product: Microsoft Dynamics NAV Connector version: 4.0 is-latest-version: true --- # Microsoft Dynamics NAV Connector 4.0 > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Anypoint Connector for Microsoft Dynamics NAV (NAV Connector) enables Mule apps to interact with Microsoft Dynamics NAV Web Services. Microsoft Dynamics NAV is a global enterprise resource planning (ERP) solution to assist with finance, manufacturing, customer relationship management, supply chains, analytics, and electronic commerce for small and medium-sized enterprise and local subsidiaries of large international groups. The versions of Microsoft Dynamics NAV supported by this connector are: - 2013 R2 - 2015 - 2016 - 2017 Release Notes: [Microsoft Dynamics NAV Connector Release Notes](https://docs.mulesoft.com/release-notes/connector/ms-dynamics-nav-connector-release-notes-mule-4) Exchange: [Microsoft Dynamics NAV Connector](https://www.mulesoft.com/exchange/com.mulesoft.connectors/mule-microsoft-dynamics-nav-connector/) ## Before You Begin To use this information, you should be familiar with Microsoft Dynamics NAV, Mule runtime engine (Mule), Anypoint Connectors, Anypoint Studio, Mule concepts, elements in a Mule flow, and Global Elements. You need login credentials to test your connection to your target resource. For hardware and software requirements and compatibility information, see the Connector Release Notes. To use this connector with Maven, view the pom.xml dependency information in the Dependency Snippets in Anypoint Exchange. ## POM File Information ```xml com.mulesoft.connectors mule-microsoft-dynamics-nav-connector x.x.x mule-plugin ``` Replace `x.x.x` with the version that corresponds to the connector you are using. To obtain the most up-to-date `pom.xml` file information, access the connector in [Anypoint Exchange](https://www.mulesoft.com/exchange/) and click **Dependency Snippets**. ## Primary Use Cases The Microsoft Dynamics NAV Connector supports these operations:
OperationDescription

Page Operation

Execute one of the operations defined in published Page SOAP services.

Codeunit Operation

Execute one of the operations defined in published Codeunit SOAP services.

OData Query

Execute a Query against one of the NAV entities using the OData endpoint.

## Getting Started Before creating a sample flow, a published Page Service is necessary. See below. ## Connect in Anypoint Studio You can use this connector in Anypoint Studio by first downloading it from Exchange and configuring it as needed. ## Add the Connector to a Studio Project Anypoint Studio provides two ways to add the connector to your Studio project: from the Exchange button in the Studio taskbar or from the Mule Palette view. ### Add the Connector Using Exchange 1. In Studio, create a Mule project. 2. Click the Exchange icon **(X)** in the upper-left of the Studio task bar. 3. In Exchange, click **Login** and supply your Anypoint Platform username and password. 4. In Exchange, search for "nav". 5. Select the connector and click **Add to project**. 6. Follow the prompts to install the connector. ### Add the Connector in Studio 1. In Studio, create a Mule project. 2. In the Mule Palette view, click **(X) Search in Exchange**. 3. In **Add Modules to Project**, type "nav" in the search field. 4. Click this connector’s name in **Available modules**. 5. Click **Add**. 6. Click **Finish**. ### Configure in Studio 1. Drag an HTTP Listener to the Studio Canvas. ![Listener dragged to canvas](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/latest/_images/ms-dynamics-nav-listener-anypoint.png) 1. Set the Path. 2. Click the green plus sign to configure the listener. 2. Drag a Dynamics Nav operation to the Studio Canvas. 3. Click the green plus sign to add a configuration for the connector. 4. Complete these fields.
ParameterDescription

Domain

Domain of the Dynamics NAV instance.

Username

The Windows username to connect to Dynamics NAV.

Password

The Windows password to connect to Dynamics NAV.

Soap Url

Base URL where the SOAP services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/WS. Example: https://hostname:7047/DynamicsNAV90/WS

Odata Url

Base URL where the OData services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/OData. Example: https://hostname:7048/DynamicsNAV90/OData

Company Name

Dynamics NAV Company to which connect. In case the field is left blank, the default configured one is used.

Disable SSL certificate validation

For HTTPS certificates, if the certificate isn’t signed by a trusted partner, the server might respond with an exception. You can disable the CN (Common Name) check. This isn’t recommended for production environments.

5. On the **Advanced** tab, set **Response Timeout** and **Response Timeout Unit** if you don’t want the defaults. The default response timeout is 5000 milliseconds. For more information, see [NTLM Connection Type](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/ms-dynamics-nav-connector-reference#ntlm) and [OAuth Connection Type](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/ms-dynamics-nav-connector-reference#dynamics-nav-config_oauth). 6. Click OK. 7. Configure these fields: ![Dynamics NAV Connector config panel on General tab](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/latest/_images/ms-dynamics-nav-op-config.png) - **Query**: The query to run on Dynamics NAV. - **Fetch Size**: Number of items retrieved on one page. ## Use Case: Studio ![Query flow](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/latest/_images/ms-dynamics-nav-flow.png) ## USe Case: XML ```xml dsql: SELECT No FROM SalesOrders LIMIT 5 ``` ## See Also - [Published Page Service information](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/%3Chttps://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2015/dd355316(v=nav.80)?redirectedfrom=MSDN>) - [Microsoft Dynamics NAV Web Services site](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/%3Chttps://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2016/dd355036(v=nav.90)?redirectedfrom=MSDN>) - [Salesforce Help](https://help.salesforce.com) --- product: Microsoft Dynamics NAV Connector version: 4.0 is-latest-version: true --- # Microsoft Dynamics NAV Connector 4.0 Reference > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Release Notes: [Microsoft Dynamics NAV Connector Release Notes](https://docs.mulesoft.com/release-notes/connector/ms-dynamics-nav-connector-release-notes-mule-4) ## Limitations - Microsoft Dynamics NAV Connector isn’t supported in CloudHub 2.0 because the underlying CXF library requires a JDK to generate schema classes. To support Microsoft Dynamics NAV Connector in CloudHub 2.0, the client must provide SOAP requests in raw XML format instead of using Plain Old Java Objects (POJOs). For more information, refer to [Upgrading and Migrating Microsoft Dynamics NAV Connector to Version 4.0](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/ms-dynamics-nav-connector-upgrade-migrate). ## Dynamics Nav Configuration ### Parameters
NameTypeDescriptionDefault ValueRequired

Name

String

The name for this configuration. Connectors reference the configuration with this name.

x

Connection

  • NTLM

  • OAuth

The connection types that can be provided to this configuration.

x

Expiration Policy

Configures the minimum amount of time that a dynamic configuration instance can remain idle before the runtime considers it eligible for expiration. This does not mean that the platform expires the instance at the exact moment that it becomes eligible. The runtime actually purges the instances as it sees fit.

## NTLM Connection Type > [!NOTE] The JAXB-XJC external library is required for the NTLM and OAuth connection types: > > - `org.glassfish.jaxb:jaxb-xjc:4.0.9` > > - Mule runtime 4.9.0 and later with Java 17 ### Parameters
NameTypeDescriptionDefault ValueRequired

Domain

String

Domain of the Dynamics NAV instance

Username

String

The Windows username to connect to Dynamics NAV

x

Password

String

The Windows password to connect to Dynamics NAV

x

Soap Url

String

Base URL where the SOAP services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/WS. Example: https://hostname:7047/DynamicsNAV90/WS

x

Odata Url

String

Base URL where the OData services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/OData. Example: https://hostname:7048/DynamicsNAV90/OData.

x

Company Name

String

Dynamics NAV Company to which connect. In case the field is left blank, the default configured one is used.

Disable SSL certificate validation

Boolean

false

Response Timeout

Number

HTTP response timeout. This field is on the Advanced tab. Expressions aren’t supported.

5000

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

Time unit for the response timeout. This field is on the Advanced tab. Expressions aren’t supported.

MILLISECONDS

Reconnection

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy

Pooling Profile

Characteristics of the connection pool

## OAuth Connection Type Use OAuth 2.0 to delegate user authentication to the service hosting the user account. For more information, refer to [Configuring OAuth 2.0 for Connectors](https://docs.mulesoft.com/connectors/introduction/intro-config-oauth2), [Configuring OAuth 2.0 for Connectors on CloudHub](https://docs.mulesoft.com/connectors/introduction/intro-config-oauth2-cloudhub), or [OAuth Support in the SDK](https://docs.mulesoft.com/mule-sdk/latest/oauth). > [!NOTE] The JAXB-XJC external library is required for the NTLM and OAuth connection types: > > - `org.glassfish.jaxb:jaxb-xjc:4.0.9` > > - Mule runtime 4.9.0 and later with Java 17 ### Parameters
NameTypeDescriptionDefault ValueRequired

Username

String

The Windows username to connect to Dynamics NAV

x

Access Token

String

The Windows password to connect to Dynamics NAV

x

Soap Url

String

Base URL where the SOAP services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/WS. Example: https://hostname:7047/DynamicsNAV90/WS

x

Odata Url

String

Base URL where the OData services are exposed in the form https://<Server>:<WebServicePort>/<ServerInstance>/OData. Example: https://hostname:7048/DynamicsNAV90/OData.

x

Company Name

String

Dynamics NAV Company to which connect. In case the field is left blank, the default configured one is used.

Disable SSL certificate validation

Boolean

false

Response Timeout

Number

HTTP response timeout. This field is on the Advanced tab. Expressions aren’t supported.

5000

Response Timeout Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

Time unit for the response timeout. This field is on the Advanced tab. Expressions aren’t supported.

MILLISECONDS

Reconnection

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy

Pooling Profile

Characteristics of the connection pool

## Associated Operations - [Codeunit Operation](#codeunitOperation) - [OData Query](#odataQuery) - [Page Operation](#pageOperation) ## Codeunit Operation `` ### Parameters
NameTypeDescriptionDefault ValueRequired

Configuration

String

The name of the configuration to use.

x

Entity

Object

#[payload]

Output Mime Type

String

MIME type of the payload that this operation outputs.

Output Encoding

String

Encoding of the payload that this operation outputs.

Config Ref

ConfigurationProvider

Name of the configuration to use to execute this component.

x

Service

String

x

Operation

String

x

Target Variable

String

The name of a variable on which the operation’s output will be placed

Target Value

String

An expression that will be evaluated against the operation’s output and the outcome of that expression will be stored in the target variable

#[payload]

Error Mappings

Array of Error Mapping

Set of error mappings.

Reconnection Strategy

A retry strategy in case of connectivity errors

### Output

Type

Any

### For Configurations - [Dynamics Nav Configuration](#dynamics-nav-config) ### Throws - NAV:CONNECTIVITY - NAV:INCORRECT\_CREDENTIALS - NAV:RETRY\_EXHAUSTED ## OData Query `` ### Parameters
NameTypeDescriptionDefault ValueRequired

Configuration

String

The name of the configuration to use.

x

Query

String

x

Fetch Size

Number

x

Config Ref

ConfigurationProvider

Name of the configuration to use to execute this component.

x

Streaming Strategy

Configure if repeatable streams should be used and their behavior

Target Variable

String

The name of a variable on which the operation’s output will be placed

Target Value

String

An expression that will be evaluated against the operation’s output and the outcome of that expression will be stored in the target variable

#[payload]

Error Mappings

Array of Error Mapping

Set of error mappings.

Reconnection Strategy

A retry strategy in case of connectivity errors

### Output

Type

Array of Object

### For Configurations - [Dynamics Nav Configuration](#dynamics-nav-config) ### Throws - NAV:CONNECTIVITY - NAV:INCORRECT\_CREDENTIALS - NAV:RETRY\_EXHAUSTED ## Page Operation `` ### Parameters
NameTypeDescriptionDefault ValueRequired

Configuration

String

The name of the configuration to use.

x

Entity

Object

#[payload]

Output Mime Type

String

MIME type of the payload that this operation outputs.

Output Encoding

String

Encoding of the payload that this operation outputs.

Config Ref

ConfigurationProvider

Name of the configuration to use to execute this component.

x

Service

String

x

Operation

String

x

Target Variable

String

The name of a variable on which the operation’s output will be placed

Target Value

String

An expression that will be evaluated against the operation’s output and the outcome of that expression will be stored in the target variable

#[payload]

Error Mappings

Array of Error Mapping

Set of error mappings.

Reconnection Strategy

A retry strategy in case of connectivity errors

### Output

Type

Any

### For Configurations - [Dynamics Nav Configuration](#dynamics-nav-config) ### Throws - NAV:CONNECTIVITY - NAV:INCORRECT\_CREDENTIALS - NAV:RETRY\_EXHAUSTED ## Reconnection Type
FieldTypeDescriptionDefault ValueRequired

Fails Deployment

Boolean

When the application is deployed, a connectivity test is performed on all connectors. If set to true, deployment fails if the test doesn’t pass after exhausting the associated reconnection strategy

Reconnection Strategy

The reconnection strategy to use

### Reconnect
FieldTypeDescriptionDefault ValueRequired

Frequency

Number

How often to reconnect (in milliseconds)

Count

Number

The number of reconnection attempts to make

blocking

Boolean

If false, the reconnection strategy runs in a separate, non-blocking thread

true

### Reconnect Forever
FieldTypeDescriptionDefault ValueRequired

Frequency

Number

How often in milliseconds to reconnect

blocking

Boolean

If false, the reconnection strategy runs in a separate, non-blocking thread

true

## Pooling Profile Type
FieldTypeDescriptionDefault ValueRequired

Max Active

Number

Controls the maximum number of Mule components that can be borrowed from a session at one time. When set to a negative value, there is no limit to the number of components that may be active at one time. When maxActive is exceeded, the pool is said to be exhausted.

Max Idle

Number

Controls the maximum number of Mule components that can sit idle in the pool at any time. When set to a negative value, there is no limit to the number of Mule components that may be idle at one time.

Max Wait

Number

Specifies the number of milliseconds to wait for a pooled component to become available when the pool is exhausted and the exhaustedAction is set to WHEN_EXHAUSTED_WAIT.

Min Eviction Millis

Number

Determines the minimum amount of time an object may sit idle in the pool before it is eligible for eviction. When non-positive, no objects will be evicted from the pool due to idle time alone.

Eviction Check Interval Millis

Number

Specifies the number of milliseconds between runs of the object evictor. When non-positive, no object evictor is executed.

Exhausted Action

Enumeration, one of:

  • WHEN_EXHAUSTED_GROW

  • WHEN_EXHAUSTED_WAIT

  • WHEN_EXHAUSTED_FAIL

Specifies the behavior of the Mule component pool when the pool is exhausted. Possible values are: "WHEN_EXHAUSTED_FAIL", which will throw a NoSuchElementException, "WHEN_EXHAUSTED_WAIT", which will block by invoking Object.wait(long) until a new or idle object is available, or WHEN_EXHAUSTED_GROW, which will create a new Mule instance and return it, essentially making maxActive meaningless. If a positive maxWait value is supplied, it will block for at most that many milliseconds, after which a NoSuchElementException will be thrown. If maxThreadWait is a negative value, it will block indefinitely.

Initialisation Policy

Enumeration, one of:

  • INITIALISE_NONE

  • INITIALISE_ONE

  • INITIALISE_ALL

Determines how components in a pool should be initialized. The possible values are: INITIALISE_NONE (will not load any components into the pool on startup), INITIALISE_ONE (will load one initial component into the pool on startup), or INITIALISE_ALL (will load all components in the pool on startup)

Disabled

Boolean

Whether pooling should be disabled

## Expiration Policy Type
FieldTypeDescriptionDefault ValueRequired

Max Idle Time

Number

A scalar time value for the maximum amount of time a dynamic configuration instance should be allowed to be idle before it’s considered eligible for expiration

Time Unit

Enumeration, one of:

  • NANOSECONDS

  • MICROSECONDS

  • MILLISECONDS

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

A time unit that qualifies the maxIdleTime attribute

### Error Mapping Error mapping.
FieldTypeDescriptionDefault ValueRequired

Source

Enumeration, one of:

  • ANY

  • REDELIVERY_EXHAUSTED

  • TRANSFORMATION

  • EXPRESSION

  • SECURITY

  • CLIENT_SECURITY

  • SERVER_SECURITY

  • ROUTING

  • CONNECTIVITY

  • RETRY_EXHAUSTED

  • TIMEOUT

Source.

Target

String

Target.

x

## Repeatable In Memory Iterable Type
FieldTypeDescriptionDefault ValueRequired

Initial Buffer Size

Number

This is the amount of instances that will be initially be allowed to be kept in memory in order to consume the stream and provide random access to it. If the stream contains more data than can fit into this buffer, then it will be expanded according to the bufferSizeIncrement attribute, with an upper limit of maxInMemorySize. Default value is 100 instances.

Buffer Size Increment

Number

This is by how much will the buffer size expands if it exceeds its initial size. Setting a value of zero or lower will mean that the buffer should not expand, meaning that a STREAM_MAXIMUM_SIZE_EXCEEDED error will be raised when the buffer gets full. Default value is 100 instances.

Max Buffer Size

Number

This is the maximum amount of memory that will be used. If more than that is used then a STREAM_MAXIMUM_SIZE_EXCEEDED error will be raised. A value lower or equal to zero means no limit.

## Repeatable File Store Iterable Type
FieldTypeDescriptionDefault ValueRequired

Max In Memory Size

Number

This is the maximum amount of instances that will be kept in memory. If more than that is required, then it will start to buffer the content on disk.

Buffer Unit

Enumeration, one of:

  • BYTE

  • KB

  • MB

  • GB

The unit in which maxInMemorySize is expressed

## See Also [Salesforce Help](https://help.salesforce.com) --- product: Microsoft Dynamics NAV Connector version: 3.0 --- # Upgrading and Migrating Microsoft Dynamics NAV Connector to Version 3.0 > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Upgrade Anypoint Connector for Microsoft Dynamics NAV Connector to version 3.x. ## Supported Upgrade Paths
From VersionTo Version

2.x

3.x

## Changes in This Release To support Microsoft Dynamics NAV Connector in CloudHub 2.0, the client must provide SOAP requests in raw XML format instead of using Plain Old Java Objects (POJOs). Follow these steps to send or receive SOAP requests in raw XML format: 1. Make sure you have the prerequisites, such as Mule 4.6.6 or later, and obtain the WSDL file. 2. Identify all Mule flows that use Microsoft Dynamics NAV SOAP operations. 3. For the request body, update the content type to `application/xml` and provide SOAP requests in raw XML format instead of using POJOs. ![Page Operation Configuration](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/3.0/_images/ms-dynamics-nav-page-config.png) XML for sending SOAP requests directly: ```xml 1000 ``` ![Transform message of Page Operation](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/3.0/_images/ms-dynamics-nav-page-output.png) XML for using the DataWeave transform method to convert JSON to XML payload: ```xml ``` 4. For the response body, you will receive SOAP responses in raw XML format and must handle these responses accordingly. XML of a SOAP response: ```xml Returned_1000 Returned_Awesome_Product 100.00 ``` XML for using the DataWeave method to transform XML payload: ```xml ``` ## Upgrade Prerequisites Before you perform the upgrade, you must create a backup of your files, data, and configurations in case you need to restore to them. ## Upgrade Steps Follow these steps to perform the upgrade: 1. In Anypoint Studio, create a Mule project. 2. In the **Mule Palette** view, click **Search in Exchange**. 3. In **Add Dependencies to Project**, enter `dynamics nav` in the search field. 4. In **Available modules**, select **Microsoft Dynamics NAV** and click **Add**. 5. Click **Finish**. 6. Verify that the Microsoft Dynamics NAV Connector dependency version is `3.0.0` in the `pom.xml` file in the Mule project. Studio upgrades the connector automatically. ### Verify the Upgrade After you install the latest version of the connector, follow these steps to verify the upgrade: 1. In Studio, verify that there are no errors in the **Problems** or **Console** views. 2. Verify that there are no problems in the project `pom.xml` file. 3. Test the connection to verify that the operations work. ## Troubleshoot If there are problems with caching the parameters and caching the metadata, try restarting Anypoint Studio. ### Revert the Upgrade If it is necessary to revert to the previous version of Microsoft Dynamics NAV Connector, change the `ms-dynamics-nav-connector` dependency version `3.0.0` in the project’s `pom.xml` to the previous version. You must update the project’s `pom.xml` in Anypoint Studio. ## See Also - [Introduction to Anypoint Connectors](https://docs.mulesoft.com/connectors/introduction/introduction-to-anypoint-connectors) - [Microsoft Dynamics NAV Connector Reference](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/3.0/ms-dynamics-nav-connector-reference) - [Salesforce Help](https://help.salesforce.com) --- product: Microsoft Dynamics NAV Connector version: 4.0 is-latest-version: true --- # Upgrading and Migrating Microsoft Dynamics NAV Connector to Version 4.0 > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Upgrade Anypoint Connector for Microsoft Dynamics NAV (Microsoft Dynamics NAV Connector) from version 3.x to version 4.x. ## Supported Upgrade Paths
From VersionTo Version

3.x

4.x

## Changes in This Release ### 4.0 - This connector is now compatible with Java 17 only. - The SOAP stack now uses Apache CXF 4.2.4 and the Jakarta XML Bind, XML Web Services, JWS, and SOAP APIs. Applications that depend on Apache CXF 3 or the Java EE JAXB, JAX-WS, JWS, or SAAJ packages must be re-verified. Operation names and the `nav` configuration prefix are unchanged. - The NTLM and OAuth connection types now include optional **Response Timeout** and **Response Timeout Unit** fields on the Advanced tab. The default response timeout is 5000 milliseconds. Expressions aren’t supported for these fields. For more information, see [NTLM Connection Type](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/ms-dynamics-nav-connector-reference#ntlm) and [OAuth Connection Type](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/ms-dynamics-nav-connector-reference#dynamics-nav-config_oauth). - The JAXB-XJC external library for the NTLM and OAuth connection types is now `org.glassfish.jaxb:jaxb-xjc:4.0.9`. Version 3.x used `com.sun.xml.bind:jaxb-xjc:2.3.9`. - These libraries are upgraded to address reported security vulnerabilities: - The Apache CXF library is upgraded to version 4.2.4. - The JAXB runtime and XJC libraries are upgraded to version 4.0.9. - The Jakarta XML Bind API is upgraded to version 4.0.5. - The Apache Commons Lang library is upgraded to version 3.21.0. - These libraries are added to address reported security vulnerabilities: - The Jakarta XML Web Services API is added at version 4.0.3. - The Jakarta XML SOAP API is added at version 3.0.2. - The Jakarta JWS API is added at version 3.0.0. - The SAAJ implementation is added at version 3.0.6. - The Bouncy Castle libraries are added at version 1.86. ## Requirements Ensure your system meets the following compatibility requirements before you perform the upgrade:
Application/ServiceVersion

Mule runtime

4.9.0 and later

Java

17

Microsoft Dynamics NAV

  • 2013 R2

  • 2015

  • 2016

  • 2017

## Upgrade Prerequisites Before you perform the upgrade, you must: 1. Create a backup of your files, data, and configuration in case you need to restore to the previous version. 2. Ensure that your environment meets the version 4.x requirements, including Java 17 and Mule runtime 4.9.0 or later. 3. Re-verify applications that depend on Apache CXF 3 or the Java EE JAXB, JAX-WS, JWS, or SAAJ packages. 4. Update the JAXB-XJC external library to `org.glassfish.jaxb:jaxb-xjc:4.0.9` for the NTLM and OAuth connection types. 5. Install Microsoft Dynamics NAV Connector 4.x to replace the connector operations that were previously included in version 3.x. ## Upgrade Steps Follow these steps to perform the upgrade from Microsoft Dynamics NAV Connector 3.x to Microsoft Dynamics NAV Connector 4.x: 1. In Anypoint Studio, create a Mule project. 2. In the Mule Palette view, click **Search in Exchange**. 3. In the **Add Dependencies to Project** window, enter `dynamics nav` in the search field. 4. In the **Available modules** section, select **Microsoft Dynamics NAV** and click **Add**. 5. Click **Finish**. 6. Verify that the `mule-microsoft-dynamics-nav-connector` dependency version is `4.x.x` in the `pom.xml` file, where `x.x` is the minor release and patch version number. For example, if you are upgrading to version 4.0, the dependency version in the `pom.xml` file should be `4.0.0`. Studio upgrades the connector automatically. ## Verify the Upgrade After you install the latest version of the connector, follow these steps to verify the upgrade: 1. In Studio, verify that there are no errors in the **Problems** or **Console** views. 2. Check the project `pom.xml` file and verify that there are no problems. 3. Test the connection and verify that the operations work. ## Troubleshooting If there are problems with caching the parameters and caching the metadata, try restarting Studio. ## Revert the Upgrade If it is necessary to revert to the previous version of Microsoft Dynamics NAV Connector, change the `mule-microsoft-dynamics-nav-connector` dependency version in the project’s `pom.xml` file to the previous version. You must update the project’s `pom.xml` file in Anypoint Studio. ## Send SOAP Requests in XML Format To support Microsoft Dynamics NAV Connector in CloudHub 2.0, the client must provide SOAP requests in raw XML format instead of using Plain Old Java Objects (POJOs). Follow these steps to send or receive SOAP requests in raw XML format: 1. Make sure you have the prerequisites, such as Mule 4.9.0 or later, and obtain the WSDL file. 2. Identify all Mule flows that use Microsoft Dynamics NAV SOAP operations. 3. For the request body, update the content type to `application/xml` and provide SOAP requests in raw XML format instead of using POJOs. ![Page Operation Configuration](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/latest/_images/ms-dynamics-nav-page-config.png) XML for sending SOAP requests directly: ```xml 1000 ``` ![Transform message of Page Operation](/mulesoft/current/en-us/microsoft-dynamics-nav-connector/latest/_images/ms-dynamics-nav-page-output.png) XML for using the DataWeave transform method to convert JSON to XML payload: ```xml ``` 4. For the response body, you will receive SOAP responses in raw XML format and must handle these responses accordingly. XML of a SOAP response: ```xml Returned_1000 Returned_Awesome_Product 100.00 ``` XML for using the DataWeave method to transform XML payload: ```xml ``` ## See Also - [Introduction to Anypoint Connectors](https://docs.mulesoft.com/connectors/introduction/introduction-to-anypoint-connectors) - [Microsoft Dynamics NAV Connector Reference](https://docs.mulesoft.com/microsoft-dynamics-nav-connector/latest/ms-dynamics-nav-connector-reference) - [Salesforce Help](https://help.salesforce.com)