Important: This documentation covers Yarn 1 (Classic).
For Yarn 2+ docs and migration guide, see yarnpkg.com.

Package detail

n8n-msdyn365bc

KTC-GmbH0MIT1.1.0TypeScript support: included

An n8n integration node for Microsoft Dynamics 365 Business Central

n8n, n8n-nodes, n8n-nodes-msdyn365bc, microsoft, business-central, dynamics365, d365, msdyn365bc, n8n-community-node-package

readme

n8n-msdyn365bc

n8n Community Node Microsoft Business Central MIT License npm version npm downloads

🚀 A powerful n8n Community Node for seamless integration with Microsoft Dynamics 365 Business Central


📋 Table of Contents


Overview

This n8n node enables seamless integration of Microsoft Dynamics 365 Business Central into your automation workflows. With this node, you can read, write, and manage data as well as utilize Business Central APIs directly from n8n.

🎯 Why use this node?

  • Complete Integration: Direct access to all Business Central OData endpoints
  • Easy to Use: Intuitive configuration without complex setup processes
  • Production-Ready: Robust error handling and proven best practices
  • Community-Driven: Active development and support by the community

✨ Features

🔌 Complete API Integration
Access to all Business Central OData endpoints
📝 CRUD Operations
Create, Read, Update, and Delete records
🔐 Secure Authentication
Support for OAuth 2.0 and API Keys
Batch Operations
Efficient processing of multiple records
🛡️ Error Handling
Robust error handling and retry logic
🔍 Metadata Support
Automatic detection of available entities and fields

🚀 Installation

npm install n8n-nodes-msdyn365bc

Option 2: n8n Community Package Manager

  1. Open n8n
  2. Navigate to SettingsCommunity Nodes
  3. Click Install a community node
  4. Enter n8n-nodes-msdyn365bc
  5. Click Install

Option 3: Manual Installation (Development)

git clone https://github.com/[your-username]/n8n-msdyn365bc.git
cd n8n-msdyn365bc
npm install
npm run build
npm link

⚙️ Configuration

🔐 Setting up Authentication

Parameter Description Example
Client ID Azure App Registration Client ID 12345678-1234-1234-1234-123456789abc
Client Secret Azure App Registration Secret your-client-secret
Tenant ID Azure AD Tenant ID your-tenant-id
Environment URL Business Central API URL api.businesscentral.dynamics.com

API Key (Alternative)

Parameter Description
Access Key Business Central Web Service Access Key
Environment URL Business Central Environment URL

🌐 Environment Configuration

// Example Environment URL
https://api.businesscentral.dynamics.com/v2.0/[tenant-id]/[environment-name]/api/v2.0

📖 Usage

🔧 Basic Operations

📊 Reading Records

{
  "operation": "get",
  "resource": "customers",
  "options": {
    "filter": "Name eq 'Contoso Ltd.'",
    "select": ["No", "Name", "Email"]
  }
}

➕ Creating New Records

{
  "operation": "create",
  "resource": "items",
  "body": {
    "No": "ITEM001",
    "Description": "New Item",
    "UnitPrice": 99.99
  }
}

✏️ Updating Records

{
  "operation": "update",
  "resource": "customers",
  "recordId": "01445544-0000-0000-0000-000000000000",
  "body": {
    "Email": "newemail@example.com"
  }
}

📚 Available Resources

<summary>Click here for a complete list</summary>
  • 👥 customers - Manage customers
  • 🏢 vendors - Manage vendors
  • 📦 items - Manage items
  • 🛒 salesOrders - Sales orders
  • 📋 purchaseOrders - Purchase orders
  • 📈 generalLedgerEntries - General ledger entries
  • 📊 dimensions - Dimensions
  • 🏛️ companies - Companies
  • 💰 payments - Payments
  • 📄 documents - Documents
  • 🔄 workflows - Workflows
  • and many more...

🛠️ Development

📋 Prerequisites

  • Node.js Node.js 18+
  • npm npm 8+
  • n8n n8n (for local testing)

🏗️ Setup

# Clone repository
git clone https://github.com/[your-username]/n8n-msdyn365bc.git
cd n8n-msdyn365bc

# Install dependencies
npm install

🔨 Build & Test

# Build project
npm run build

# Run tests
npm test
npm run test:coverage

# Local development
npm run dev
# In another terminal
n8n start

📋 API Reference

🔧 Supported Operations

Operation Description Parameters Example
get Retrieve records filter, select, top, skip filter: "Name eq 'Test'"
create Create new record body body: {"Name": "Test"}
update Update record recordId, body recordId: "123"
delete Delete record recordId recordId: "123"
getById Get single record by ID recordId, select recordId: "123"

🔍 Filter Options (OData Syntax)

// Equality
"Name eq 'Contoso'"

// Comparisons
"UnitPrice gt 100"
"UnitPrice lt 50"
"UnitPrice ge 100"
"UnitPrice le 50"

// Date/Time
"CreatedDate ge 2024-01-01T00:00:00Z"

// String functions
"contains(Name, 'Ltd')"
"startswith(Name, 'Con')"
"endswith(Name, 'Ltd')"

// Logical operators
"Name eq 'Contoso' and UnitPrice gt 100"
"Name eq 'Contoso' or Name eq 'Fabrikam'"

🤝 Contributing

Contributions Welcome

We welcome contributions! Please read our Contributing Guidelines before creating a pull request.

💡 Want to contribute professionally? We're always looking for talented AL developers to join our team! Check out our career opportunities below.

🚀 Development Guidelines

  1. Fork the repository
  2. Create branch (git checkout -b feature/new-feature)
  3. Commit changes (git commit -am 'Add new feature')
  4. Push to branch (git push origin feature/new-feature)
  5. Create Pull Request

📊 Project Status

GitHub issues GitHub pull requests GitHub contributors


📝 License

MIT License

This project is licensed under the MIT License. See LICENSE for details.


🐛 Bug Reports & Feature Requests

Use GitHub Issues for:

  • 🐛 Bug Reports
  • 💡 Feature Requests
  • ❓ Usage Questions
  • 📚 Documentation Improvements

📖 Documentation


🏢 About KTC

Developed by KTC

Developed by KTC-Karlsruhe Technology Consulting GmbH

Your reliable digitalization and AI partner for Microsoft Dynamics 365 Business Central

🎯 Our Expertise

  • 🔧 Business Central Implementation - Tailored solutions
  • 📱 App Development - Custom apps for Business Central
  • 🤖 AI Integration - Modern AI solutions
  • ☁️ Cloud Migration - Secure cloud migration

💼 Join Our Team

We're Hiring AL Developers

🚀 Are you passionate about Microsoft Business Central and AL development?

We're actively looking for talented AL (Application Language) Developers to join our growing team! If you're excited about:

  • 💻 AL Development - Building custom extensions and apps for Business Central
  • 🌟 Open Source - Contributing to projects like this n8n node
  • 🤖 AI Integration - Working with cutting-edge AI technologies
  • 🌍 Remote Work - Flexible work arrangements available
  • 📈 Growth - Continuous learning and career development

We'd love to hear from you!

🎯 What we're looking for:

  • Experience with Microsoft AL Language and Business Central
  • Strong problem-solving skills and attention to detail
  • Passion for clean, efficient code
  • Team collaboration and communication skills
  • Interest in automation and AI technologies

📧 How to Apply:

  • Email: careers@ktc.de
  • Subject: "AL Developer Application - GitHub"
  • Include: Your CV, portfolio, and a brief note about what excites you about AL development

📞 Support

🕐 Support Hours

  • Community Support: 24/7 via GitHub Issues
  • Professional Support: Mon-Fri 9:00-17:00 CET
  • Enterprise Support: Available by arrangement


Made with Love

⭐ If you like this project, give us a star on GitHub! ⭐

GitHub Stars GitHub Forks

📝 Note: This project is a community node and is not officially supported by Microsoft or n8n. It is developed and maintained by the community.