Skip to main content

Introduction of ODATA Services In NAV 2013.

Hi all,

Let's discuss about a New Services came up with NAV 2013 - ODATA. In the post we will see the basic introduction about ODATA, how to enable it and how it can be browsed.

Later on we will discuss on how to consume data exposed via ODATA.



If you see the service console of NAV 2013 aka Microsoft Dynamics NAV Administration you will see a separate tab for ODATA Services as shown below -


As you can see the parameters in this tab are pretty self explanatory.

First thing need to be done is Enable OData services from the console if it is not enable by default.

Let's try to browse the the port in Internet Explorer.

The URL to test the ODATA Services is - http://localhost:7048/DynamicsNAV70/OData/

Where -
Localhost - is the Server name where it is hosted (in my case it is hosted on local machine).
:7084 - is the port where it is hosted on server.
DynamicsNAV70 - Service Instance Name.
OData - is open data protocol.

Here is what i got response of above query from Internet Explorer.

So as of now nothing has been exposed. Exposing is same as of NAV 2009 version with an addition, we can expose Pages, Codeunits and Queries.

Open the NAV 2013 windows Client and navigate to
Departments/Administration/IT Administration/General/Web Services


Edit the page and expose the object you want. I am using Customer Card, Page 21.
I name it NAVCustomers as shown.



Lets refresh the URL in Internet Explorer. Yeah, i can see NAVCustomers there in the list.

Let's try to find the data that is exposed. But How?

Here is the URL for same - http://localhost:7048/DynamicsNAV70/OData/NAVCustomers


In right hand side you can see the No of records the have been feeded.

we will see the consumption of feed in Next Post.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.