OData integration

Dynamicweb allows for data integration through the Open Data Protocol (OData), which is a standardized way of communicating with RESTful API's.

Through the OData protocol you can use HTTP methods such as GET or POST on endpoints and you can filter the response or select specific fields. 

By utilizing the built in Endpoint provider and OData provider you can set up data integration activities for importing data from any interface that exposes OData web services as well as for exporting data to Dynamics 365 Business Central.

There are five general steps in configuring an OData integration in Dynamicweb:

  • Authenticating access to an OData source 
  • Establishing endpoints in Dynamicweb
  • Configuring a source provider
  • Configuring a destination provider
  • Defining mappings between Dynamicweb and the OData source/destination 

Your OData integration project will most likely require an authentication through the OAuth 2.0 protocol. 

Generally authenticating  an endpoint from a cloud system requires OAuth 2.0 whereas locally hosted solutions can make do with basic authentications such as a WebServiceAccessKey

Configuration of OAuth 2.0 depends on the system you wish to integrate with. You can read more about how to establish OAuth for the systems currently supported in Dynamicweb here:

There are two distinct types of endpoints for OData integration: OData API and OData V4 (anti-pattern). The desired type of endpoint must be selected when setting up a data integration activity. You can acces a step-by-step guide for each of the endpoint types by following the links below.


The OData API type of endpoint is a general purpose integration tool that allows for manual mappings between any exposed OData source and any entity in the Dynamicweb database.

An OData API integration is a fast and easily customizable way to import data to Dynamicweb. 

OData V4 - Business Central pre-config The OData V4 setting of the endpoint provider is built specifically for data integration with Dynamics 365 Business Central. By using the OData V4 URL's of Business Central web services you can take advantage of predefined object type mappings for a seamless data integration.