Microsoft Dynamics Business Central API connections

[kosie-snyman]

The company I work for are planning to use MS Business Central (SaaS) as ERP, We need to create interface between Legacy on Premise software and Business Central via API using O Auth authentication. There is no ODBC driver available since Cloud based. Will appreciate advice on how other solved the problem.

[ArtApa]

Hi @kosie-snyman - Here is a possible solution: https://www.cdata.com/kb/tech/d365businesscentral-odbc-alteryx.rst

Alternatively, here are a few links for you:
 - https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/api-overview

 - https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/8074... 

[kosie-snyman]

Thank you for the references and I will definitely be working through these to setup and test connections. 

[lee75clark1]

Hi Kosie, did you ever mange to get anywhere with your workflow. We are in the process of setting up both Business central and Alteryx Server. We have managed to connect to the tables of data in business central but are struggling to find the correct table to share the information as the tables in the connection do not match the tables in business central application? 

Lee