Extract Data from Business Central

(2) Share

Report

Posted on by MP-26111204-0

We have a wish to extract data from Business Central automatically.

We want to model the data to fit the data of another system using KNIME.

I have been looking at API, is this the recommended way to connect Business Central Data or is there a smarter way to get data into KNIME.
Note, that we do not have anyone to code, so we want to do it though configuration of the Business Central

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

tlhgolfer 23 on at

Like (0)

Report
Copy link

Link copied!

The key term is "Automatically". You can export data through may ways in BC just not automatically as easy. If you are doing an API you could try Power Automate also, but again you might need some development skills. You could look at using a Job Que to export data. This can be scheduled to run at a specific time and can be recurring. You would need to create a job que to run a codeunit that would extract the data.

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 442 on at

Like (1)

Report
Copy link

Link copied!

Hi,

To extract data from business central without any code, configuration packages is the best way.

You could create configuration packages in business central where you can include the tables that you need and also fields that are needed. This will export the data in excel files. Then you can transform the excel to load into KNIME, if it supports excel or csv files.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 442 on at

Like (1)

Report
Copy link

Link copied!

You can also leverage the standard APIs provided by Business Central, which are available out of the box. These APIs cover most major master data tables as well as document tables.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/

Was this reply helpful? Yes No
Suggested answer

tanya07 1,638 on at

Like (1)

Report
Copy link

Link copied!

Hello,

APIs would be the best way :)

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

However, Microsoft does not provide standard APIs for all tables, and the standard APIs may not contain the fields you need, which all need to be customized.

The same is true when using Power Automate.

More details: Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs

https://yzhums.com/20960/

Hope this can give you some hints as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

This depends on what data sources your other system can work with. Typically, APIs would be the best option, but as mentioned by Yun Zhu, the system may not have all the APIs you need. If that's the case, it won't work for you without access to a developer.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
MP-26111204-0 65 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the inputs, we will try and see how it goes with the API setup :)

Was this reply helpful? Yes No