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

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.