New Dynamics 365 Business Central Writer
Write data from Keboola directly into Microsoft Dynamics 365 Business Central — now available in beta.
Push clean, transformed data back into Business Central and keep your ERP in sync with the rest of your data stack.
What's New
The Dynamics 365 Business Central Writer is a new destination component that lets you write records from Keboola Storage tables into your Business Central instance via the OData REST API. It uses OAuth 2.0 authentication and dynamically discovers available endpoints and fields directly from your Business Central metadata — so there's no hardcoded schema to maintain. This beta release is fully functional and ready for real-world use; we're collecting feedback before moving to general availability.
Key Features
- Write records to any Business Central endpoint — customers, vendors, sales orders, and more, all loaded dynamically from your instance
- Create and update modes — insert new records via POST or update existing ones by key field via PATCH
- Auto field mapping — input table columns are fuzzy-matched to Business Central API fields automatically, with support for nested fields via dot notation (e.g.
address.city) - Per-record error handling — optionally continue on failed records instead of stopping the job; failed rows are written to a
failed_records.csvoutput table with error details - OAuth 2.0 with automatic token refresh — secure authentication without manual credential management
- Row-based configuration — each config row targets a separate endpoint, so you can manage multiple entity types from a single component configuration
Why It Matters
Keboola is often where data gets cleaned, enriched, and transformed — but that value shouldn't stay locked in your data warehouse. With this writer, you can close the loop and push analytics-ready data back into Business Central to keep your ERP records accurate and up to date.
Example use case: You're running a sales pipeline in Keboola that reconciles order data from multiple sources. Once the transformation is done, use this writer to automatically update or create sales order records in Business Central — no manual exports, no copy-paste errors.
Where to Find It
You can find the component in the Writers section of your Keboola project. For setup details, refer to the component documentation on GitHub.
We'd love your feedback. If you run into issues, have feature requests, or want to share how you're using the component, reach out via support@keboola.com.