Data Access Connect to your Business Central data with the managed API

This is what you get

Every time, you need ERP-data for other IT-solutions, like Business Intelligence, you can use the Data Access app. You get the 73 most commonly used tables from Business Central including all regular fields.

Request data from Business Central with a GET, and you receive a JSON response.

To extract data to your reporting or data storage solution, add your preferred integration solution, eg OData connector for Power BI, Azure Logic Apps, Data Factory or Azure functions.

When configured, the app keeps track of deletions in relevant tables, so your integrations only need to load the most recently modified data to stay updated. The app is frequently updated to support updates of Business Central from Microsoft. The API will always expose the current Business Central table structure.

Limitations and Possibilities

The data displayed does not include calculated data fields and flow fields. Included tables are listed below.

You may need to adapt your integration when Microsoft changes the table structure of Business Central.

You can extend this app. If you need more data, you can expand the data model or hire us to do so. But in most cases, it will not be necessary.