VisionOpenAPI – one API for your entire Business Central data model
Does your BI system or data warehouse need data from Business Central – including custom-developed tables? Standard web services only expose selected data. VisionOpenAPI is a generic Business Central API that gives access to the full data model without development, so you can pull data into Power BI and other systems.
Full data model for Business Central makes data accessible via API
VisionOpenAPI provides access to a full data model for the individual Business Central solution, even when Business Central has received customer-specific extensions. VisionOpenAPI is mainly used by BI vendors who want to access the unified data model to Business Central.
Open API for Business Central
Data extraction from Business Central via API and without development
Access to the full data model for the entire solution
Easy integration and data access for external systems
Integration to Business Central without development
Access to the full data model for Business Central
One Business Central API – all data accessible without development
With VisionOpenAPI, you can easily and securely extract all the data you want from Business Central for use in other systems
Full data model for Business Central
Microsoft allows you to display selected data as a web service on one page, but with VisionOpenAPI you have access to the full data model
Generic API as a basis for integrations
VisionOpenAPI makes your integrations faster and cheaper, and fits many different integration scenarios
Access to all data - including customized tables
Integration options in standard Business Central are limited, but with this generic web service page all data is available, including from the customer's own tables
When BI systems need to retrieve data from Business Central
VisionOpenAPI is used by several Power BI vendors, but also vendors of other BI platforms can use VisionOpenAPI to make Business Central data available in remote BI system
No development - just web service integration
The integration solution builds on the latest technologies and makes Business Central data accessible without development and without deeper knowledge of Business Central.
Flexible integration with many applications
Once VisionOpenAPI is implemented in the solution, the integration framework can be used for any other integration requests the company may have.
Generic API for Business Central Online
VisionOpenAPI makes it easy to retrieve data from Microsoft's cloud platform, where all Business Central customers' solutions are run (Software-as-a-Service). VisionOpenAPI can thus also provide Business Central's entire data model for use in, for example, a BI system such as Power BI or others.
Flexibility 01
Tailor your integration
VisionOpenAPI allows you to access data in Business Central “from the outside” via the full data model of the customer's customized Business Central. VisionOpenAPI gives you the ability to retrieve data without being a Business Central specialist.
Data exchange 02
Automation that creates value
Make your data extractions more efficient with VisionOpenAPI. Automate remote viewing of sales orders or inventory status and updates from Business Central. VisionOpenAPI makes data exchange fast, reliable and secure.
Error handling 03
Stay ahead of errors before they slow you down
Errors can happen, but with VisionOpenAPI they never become a problem for you. We keep detailed logs of all API activities, provide you with bug reports, and offer effective solutions such as retries and notifications. Our dashboard ensures that you always have an overview of your integrations.
Practical examples 04
Real-life cases that inspire
Our customers often use VisionOpenAPI to automatically and in real time continuously extract data from Business Central so that it can be presented somewhere else or in another system. This could be, for example, in a BI system, where you need a full data model that also contains the customer's special tables and data that you want to include in an external data warehouse and/or in BI dashboards. VisionOpenAPI is also used to display Business Central data from several different accounts and/or Business Central databases (tenants), for example in the form of inventory status across the company's different storage locations and countries. What could you simplify in your business?
Setup and Configuration 05
Effective adaptation from the start
VisionOpenAPI gives you easy and flexible setup so you can quickly connect Dynamics 365 Business Central with external systems for seamless integration from day one.
Integration with Business Central 06
User-friendly integration directly into the system
With VisionOpenAPI you have a full data model for your Business Central that makes it easy to extract data and present Business Central data on websites and in BI systems. VisionOpenAPI makes it all intuitive and efficient for you.
Make your workday smarter with our apps
See more of our innovative apps that simplify your workflows and increase efficiency. From inventory management to integrations and more. Our apps are designed to make a difference in a complex world.
Frequently asked questions
Inspired, but still have questions? Below we have gathered the questions new customers ask most often — they may also give you a better feel for the solution:
One API for the whole data model – including your own tables
BI tools and data warehouses quickly hit a wall in Business Central: standard web services only cover selected data, and every new table requires a developer. VisionOpenAPI is a generic API providing access to the full data model – including custom tables and table-extension fields – with no per-table development.
Reads are consistent (read isolation, so an extract doesn't change midway through a run), and Since and Range date filters make incremental extracts simple. Authentication, a developer guide, integration workflows and a full API reference live in the online help, and a development mode makes it easy to build and test the integration.
Book a meeting to see how quickly your data can land in the BI layer – or try the solution free for 30 days.
Let's optimize your business today
Over the years we have seen — and solved — a lot of the challenges our customers struggle with. Maybe we can help you too, by digitalising manual workflows and making them efficient. We happily accept the challenge.
