OData Web Services – Business Central

The Open Data Protocol (OData) is a web protocol that is designed for querying tabular data and provides you with an alternative to SOAP-based web services. OData builds on web technologies such as HTTP and JavaScript Object Notation (JSON) to provide access to information from different applications, services, and stores. OData uses URIs for resource identification and commits to an HTTP-based, uniform interface for interacting with resources. This commitment to core Web principles allows for OData to enable a new level of data integration and interoperability across a broad range of clients, servers, services, and tools.

You can use OData web services to show Business Central data, and you can update data in a Business Central database using OData web services.

Using OData in other Microsoft products and technologies

OData is used in other Microsoft products and technologies, including the following:

  • Microsoft Excel implements OData for its PowerQuery feature.
  • Microsoft PowerBI can read data from OData services.
  • Microsoft SharePoint can expose its list-oriented data with OData.

Key concepts and techniques for accessing Business Central data using OData

The topics in this section describe the key concepts and techniques for accessing Business Central data from OData applications that are supported by Business Central .

Enabling and Configuring OData on the Business Central Server

The Business Central Server instance has several configurations settings that enable and control OData services. For more information, see OData Services Settings.

Known Limitations with Business Central OData

The Open Data Protocol (OData) implementation in Business Central does not implement all features in the OData specification. For more information, see Known OData Limitations.

See Also

SOAP Web Services

Source Article