Connect a module

Microsoft Dynamics 365 Business Central

ShopMCP connects to Business Central API v2.0 using a Microsoft Entra app. The first release is read-only: companies, customers, vendors, items, inventory movements, sales documents, purchase documents, and financial records.

Admin-only while the integration is validated

This connector currently requires Microsoft Entra and Business Central admin setup. Customer self-serve OAuth and write tools are deferred.

1. Register a Microsoft Entra app

In Microsoft Entra, register an app for ShopMCP and grant it Dynamics 365 Business Central API access. For the admin MVP, ShopMCP uses the client credentials flow with https://api.businesscentral.dynamics.com/.default.

Copy the tenant ID.
Copy the application client ID.
Create and copy a client secret.
Grant admin consent for the Business Central API permission.

2. Enable the app inside Business Central

In Business Central, open Microsoft Entra Applications, add the app client ID, enable it, and assign only the permission sets needed for the records ShopMCP should read. The app must be able to see at least one company and execute the standard API v2 pages for that company.

Use least privilege

Business Central application accounts cannot use SUPER. Keep this app scoped to read-only ERP records until write safety is explicitly validated.

3. Connect in ShopMCP

Open Settings -> Integrations and choose Business Central. Paste the tenant ID, client ID, client secret, and environment name. You can optionally supply a company ID; if left blank, ShopMCP uses the first company returned by/companies during verification.

Connection readiness

A working connection has to pass three separate checks.

Microsoft Entra issues a token for https://api.businesscentral.dynamics.com/.default.
/companies returns at least one company in the selected environment.
Company-scoped API v2 reads such as customers, items, purchase orders, sales invoices, and ledger entries return 200 responses.

ShopMCP uses the standard Business Central API v2.0. No Business Central extension is required unless you later need custom fields that are not exposed by Microsoft's standard API.

What you can ask

List customers, vendors, payment terms, and currencies.
Review items, item variants, item categories, locations, and inventory movements.
Find sales orders, sales order lines, sales invoices, credit memos, purchase orders, purchase receipts, and purchase invoices.
Review aged receivables, aged payables, customer payments, vendor payments, bank accounts, and ledger entries.
Inspect chart of accounts, posting groups, dimensions, journals, accounting periods, payment methods, shipment methods, and tax setup.
Run Business Central inventory health, PO/replenishment, fulfilment-risk, and finance-reconciliation probes.
Filter by date, status, customer, vendor, account, or modified time using OData filters.

Troubleshooting

Token rejected - confirm the tenant ID, client ID, client secret, and granted Business Central API permission.
401 after token issuance - confirm the Entra app is enabled or consented inside the selected Business Central environment.
403 from Business Central - confirm the app is enabled in Business Central and has the needed permission sets.
No company found - verify the environment name and company visibility for the app. Use Sandbox, not the UI label Sandbox (Sandbox).
403 mentioning _Exclude_APIV2_ - the app can see the company, but the assigned permission set is blocking standard API v2 pages or table data.