Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Extract Data from Busi...
Small and medium business | Business Central, N...
Suggested answer

Extract Data from Business Central

(3) ShareShare
ReportReport
Posted on by MP-26111204-0 25
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
  • MP-26111204-0 Profile Picture
    MP-26111204-0 25 on at
    Extract Data from Business Central
    Thank you for the inputs, we will try and see how it goes with the API setup :)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,463 Super User 2024 Season 2 on at
    Extract Data from Business Central
    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.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,402 Super User 2024 Season 2 on at
    Extract Data from Business Central
    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
     
     
    Hope this can give you some hints as well.
    Thanks.
    ZHU
  • Suggested answer
    tanya07 Profile Picture
    tanya07 1,592 on at
    Extract Data from Business Central
    Hello,
     
    APIs would be the best way :)
     
     
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 93 on at
    Extract Data from Business Central
    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.
     
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 93 on at
    Extract Data from Business Central
    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.

  • Suggested answer
    tlhgolfer Profile Picture
    tlhgolfer 12 on at
    Extract Data from Business Central
    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.
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Share Your Event with the Community

Jump start your event engagement! 📢

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,938 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,655 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans