n8n-nodes-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. Currently only read is supported.
🔐	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

1. Open n8n
2. Navigate to Settings → Community Nodes
3. Click Install a community node
4. Enter n8n-nodes-msdyn365bc
5. Click Install
6. If you need help with that, check the Install community nodes

Option 3: Manual Installation (Development)

git clone https://github.com/[your-username]/n8n-nodes-msdyn365bc.git
cd n8n-nodes-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

Click here for a complete list

• 👥 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.

🚀 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

---

📝 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

---

📞 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.