OData Web Services
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 .
|Develop fast OData clients||OData Query performance|
|Expose a codeunit through OData to implement a Remote Procedure Call (RPC)||Creating and Interacting with an OData V4 Unbound Action|
|Use OData to obtain an AtomPub document.||Using OData to Return or Obtain an AtomPub Document|
|Use OData to obtain a service metadata (EDMX) document.||Using OData to Return or Obtain a Service Metadata (EDMX) Document|
|Use filter expressions in OData URIs.||Using Filter Expressions in OData URIs|
|Use FlowFilters in OData URIs.||Using FlowFilters in OData URIs|
|Use server-driven paging in OData URIs.||Server-Driven Paging in OData Web Services|
|Navigate in an OData web service application by using resource properties.||Using Containments and Associations|
|Write to the database through an OData web service that exposes a writable page.||Using OData Web Services to Modify Data|
|Learn about limitations with Business Central OData||Known OData Limitations|
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.
Submit and view feedback for