Microsoft Dynamics NAV OData component

Overview

The Microsoft Dynamics NAV component allows Connect to work with the Microsoft Dynamics' NAV software solution for Enterprise Resource Planning (ERP), via Microsoft’s OData API.

Overview

Microsoft Dynamics NAV component for the Connect platform.

Requirements

Environment variables

The component LOG_LEVEL environment variable has been deprecated. Now you can control logging level per each step of the flow.

Credentials

Username

The name of the user who has rights to access Dynamics 365 Business Central or NAVOData, for your Dynamics 365 Business Central or NAVOData service NTLM authentication.

Password

The password, for your Dynamics NAVOData service NTLM authentication.

Service URL

The address of any acceptable URL where the Dynamics 365 Business Central or NAVOData service is located.

Triggers

This component has no trigger functions. This means it will not be accessible to select as a first component during the integration flow design.

Actions

Delete Object By Unique Criteria

Delete an existing entry with the criteria provided.

List of Expected Config fields

Object Type to Delete

Select the type of object which you want to delete.

Expected input metadata

Input metadata is dynamically generated for specified object type. You need to set unique keys which specified in the Microsoft NAV OData metadata. For example:

Object type

Sales Order

JSON schema
{
  "Document_Type": {
    "type": "string",
    "required": true,
    "title": "Document_Type"
  },
  "No": {
    "type": "string",
    "required": true,
    "title": "No"
  }
}

You can find xml metadata using next url template: http://hostname:port/DynamicsNAV80/OData/$metadata.

Expected output metadata

Output metadata is dynamically generated for specified object type.

Object type

Sales Order

JSON schema
{
	"type": "object",
	"properties": {
		"result": {
			"type": "string"
		},
		"criteria": {
			"type": "object",
			"properties": {
				"Document_Type": {
					"type": "string"
				},
				"No": {
					"type": "string"
				}
			}
		}
	}
}