n8n-nodes-dolibarr

This is an n8n community node for Dolibarr, an open-source ERP/CRM software.

This node allows you to interact with your Dolibarr instance directly from n8n workflows, enabling automation of business processes like customer management, invoicing, orders, stock management, and more.

n8n is a fair-code licensed workflow automation platform.

Installation

Follow the installation guide in the n8n community nodes documentation.

npm install n8n-nodes-dolibarr

Requirements

• Dolibarr: Version 22.0 or higher
• n8n: Version 1.0.0 or higher
• Node.js: 20.15 or higher

Credentials

To use this node, you need to configure the Dolibarr API credentials:

1. Base URL: The URL of your Dolibarr instance (e.g., https://your-dolibarr.com)
2. API Key: Your Dolibarr API key (generate it in Dolibarr: Setup > Users > [User] > API tab)
3. Entity ID (optional): For multicompany installations, specify the entity ID

Supported Resources

This node supports 18 Dolibarr resources with full CRUD operations and special actions:

Core Business

| Resource | Operations | |----------|------------| | Third Party | Create, Get, Get Many, Update, Delete | | Product | Create, Get, Get Many, Update, Delete | | Invoice | Create, Get, Get Many, Update, Delete, Validate, Set to Draft, Add Line, Add Payment | | Order | Create, Get, Get Many, Update, Delete, Validate, Close, Set to Draft, Add Line | | Proposal | Create, Get, Get Many, Update, Delete, Validate, Close, Set to Draft, Add Line |

Management

| Resource | Operations | |----------|------------| | Project | Create, Get, Get Many, Update, Delete, Validate, Close | | Contact | Create, Get, Get Many, Update, Delete | | Category | Create, Get, Get Many, Update, Delete, Link Object, Unlink Object | | User | Create, Get, Get Many, Update, Delete |

Stocks & Finance

| Resource | Operations | |----------|------------| | Stock | Create Movement, Get Movements, Get Warehouses | | Bank Account | Create, Get, Get Many, Update, Get Lines |

Planning

| Resource | Operations | |----------|------------| | Agenda Event | Create, Get, Get Many, Update, Delete | | Document | Upload, Download, Get Many, Delete |

Suppliers

| Resource | Operations | |----------|------------| | Supplier Invoice | Create, Get, Get Many, Update, Delete, Validate, Add Line | | Supplier Order | Create, Get, Get Many, Update, Delete, Validate, Approve, Add Line |

Services

| Resource | Operations | |----------|------------| | Contract | Create, Get, Get Many, Update, Delete, Validate, Add Line, Activate Line | | Intervention | Create, Get, Get Many, Update, Delete, Validate, Close, Add Line | | Expense Report | Create, Get, Get Many, Update, Delete, Validate, Approve, Add Line |

Trigger Node

The Dolibarr Trigger node allows you to start workflows based on Dolibarr events:

• Third Party Created/Updated
• Invoice Created/Validated/Paid
• Order Created/Validated
• Proposal Created/Signed
• Product Created/Updated
• Project Created
• Stock Movement
• Supplier Order/Invoice Created

Features

Pagination

All "Get Many" operations support automatic pagination with the Return All option.

SQL Filters

Use Dolibarr's SQL filter syntax to filter results:

(t.name:like:'%test%') and (t.client:=:1)

Supported operators:

• = : equals
• != : not equals
• < : less than
• > : greater than
• <= : less or equal
• >= : greater or equal
• like : SQL LIKE pattern matching
• notlike : SQL NOT LIKE

Dynamic Dropdowns

Select third parties, products, projects, users, and more from dynamic dropdowns that load data from your Dolibarr instance.

Extrafields Support

Custom fields (extrafields) are supported in create and update operations.

Example Workflow

1. Trigger: When a new invoice is validated in Dolibarr
2. Action: Send an email notification with invoice details
3. Action: Create a task in your project management tool

API Documentation

For more information about the Dolibarr REST API:

• Dolibarr REST API Documentation

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

MIT

Author

Created for the n8n community.

Changelog

1.0.0

• Initial release
• 18 resources with full CRUD operations
• Polling trigger for Dolibarr events
• Extrafields support
• SQL filters support
• Automatic pagination