n8n-msdyn365bc
🚀 A powerful n8n Community Node for seamless integration with Microsoft Dynamics 365 Business Central
📋 Table of Contents
- Overview
- Features
- Installation
- Configuration
- Usage
- API Reference
- Development
- Contributing
- Careers
- Support
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
Option 1: npm (recommended)
npm install n8n-nodes-msdyn365bc
Option 2: n8n Community Package Manager
- Open n8n
- Navigate to Settings → Community Nodes
- Click Install a community node
- Enter
n8n-nodes-msdyn365bc
- 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
OAuth 2.0 (recommended)
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
- 👥 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 18+
npm 8+
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
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
- Fork the repository
- Create branch (
git checkout -b feature/new-feature
) - Commit changes (
git commit -am 'Add new feature'
) - Push to branch (
git push origin feature/new-feature
) - Create Pull Request
📊 Project Status
📝 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
📚 Resources & Links
📖 Documentation
- 📘 Microsoft Business Central API Documentation
- 📗 n8n Community Nodes Documentation
- 📙 OData Query Options
🔗 Related Projects
- n8n - The main n8n project
- Microsoft Business Central - Official Business Central
🏢 About 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
🚀 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
⭐ If you like this project, give us a star on GitHub! ⭐
📝 Note: This project is a community node and is not officially supported by Microsoft or n8n. It is developed and maintained by the community.