Connecting to the Microsoft Dynamics 365 Business Central Odata Web Services

Looking to integrate with Microsoft Dynamics 365 Business Central?  Your first step in SmartConnect will be to set up the connector, then you will be able to create your SmartConnect maps to set up your integrations.

The Dynamics NAV/D365 Business Central Odata Connector is available in SmartConnect and later.

Before setting up the connector in SmartConnect, at least one Business Central Web Service will need to be published as outlined in this article.

To set up the connection in SmartConnect to Microsoft Dynamics 365 Business Central, navigate to the Setup tab in the top ribbon.

1. Double click on the Dynamics NAV/365 Business Central Odata Connector.  This will open the Microsoft Dynamics NAV/365 Business Central Odata Connector setup window.

2. For the Authentication Type, select Dynamics 365 BC
3. For the Service URL you will need to find the Odata V4 URL for your instance.
You will want to copy the Odata V4 URL for a Page Web Service up to the end of the instance name, right before ‘OData V4’.

By using this URL, you will be able to integrate with all the objects in your Dynamics 365 Business Central instance that are published to web services.

*Note your URL will not include the Sandbox instance name in the URL unless you are connecting to a Sandbox instance.

4. Next, in the SmartConnect Connector window, enter a Dynamics 365 Business Central user, password and default company.

  • The system service user will be used to connect to the Dynamics 365 Business Central web services to retrieve the company and available web services for that environment.
  • The user selected must be a member of the same domain Business Central uses.
  • To access your user information from Dynamics 365 Business Central (so you can enter it into SmartConnect), click on the magnifying glass icon (the search), and then search “users”.

  • Click on your Dynamics 365 Business Central user to access the User Name and the Web Services Access Key:

  • You’ll need to enter your Dynamics 365 Business Central User Name into the User Name field on the SmartConnect Connector window.
  • You’ll need to enter the Dynamics 365 Business Central Web Service Access Key into the Password on the SmartConnect Connector window.
  • Then, select Default Company you’d like to use.  

*Note that you can integrate with multiple companies using SmartConnect.

For more detail on setup and configuration, visit the SmartConnect Manual.  

Once you have your connectors set up, start integrating and create your first SmartConnect map.


Deleting Source Files from Archive Folder
The Sales Header does not exist. Identification fields and values: Document Type=’Quote’No.=’’
How to Exclude Data Source Rows
SmartConnect - Extra Source Records
SmartConnect – Zip File as Source


Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
Manufacturing Serial Trace SmartList Builder Template
The server process could not be started because the configured identity is incorrect.
How to update SmartConnect from to SmartConnect 2014
Using WINSCP and a task to upload or download files from an SFTP site



open all | close all


CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce scripting SmartConnect SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.