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, the Atom Publishing Protocol (AtomPub), 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 Microsoft Dynamics NAV data, and you can update data in a Microsoft Dynamics NAV database using OData web services.
OData can be found in other Microsoft products and technologies, including the following:
-
Microsoft Excel implements OData for its PowerPivot add-in.
-
Microsoft SharePoint can expose its list-oriented data with OData.
-
Microsoft Azure Table Services are based on OData.
The topics in this section describe the key concepts and techniques for accessing Microsoft Dynamics NAV data from OData applications that are supported by Microsoft Dynamics NAV.
| To | See |
|---|---|
Use OData to obtain an AtomPub document. | |
Use OData to obtain a service metadata (EDMX) document. | How to: Use OData to Return/Obtain a Service Metadata (EDMX) Document |
Use OData to obtain a JavaScript Object Notation (JSON) document. | |
Use filter expressions in OData URIs. | |
Use FlowFilters in OData URIs. | |
Use server-driven paging in OData URIs. | |
Navigate in an OData web service application by using resource properties. | |
Write to the database through an OData web service that exposes a writable page. |
Known Limitations
You can specify filters in OData web services in general that are not supported in Microsoft Dynamics NAV, such as using an OR operator to filter on two different fields. In those cases, you will see the following error:
 Copy Code | |
|---|---|
An error occurred while processing this request. | |