Consuming Dynamics AX 365FO Data entities using Web API (Part 3)

Hi Guys,

This is with the 3rd and final part of same demo, In this post we will see what is the code we need to write on wep api project to get the data from Dynamics ax 365. In this post we will be reading the purchase order data from Dynamics ax 365. In case if you have not read the previous two parts then follow these links

https://msdax.wordpress.com/2018/03/20/consuming-dynamics-ax-365fo-data-entities-using-web-api-part-1/

https://msdax.wordpress.com/2018/03/22/consuming-dynamics-ax-365fo-data-entities-using-web-api-part-2/

To start with, we need to add few dll references on Web api project. Please make sure Microsoft.OData.Client dll should be of same version what we have referenced in AuthenticationUtility and ODataUnity project(These projects are previously discussed in last blogs).

using Manage Nuget Package option we can install package for Microsoft.OData.Client

Now with the simple coding part, we need to reference following dll.

I have created this initConfiguration method to authenticate my call using Azure, GetAuthenticationHeader method is given on OAuthHelper class, we will pass true for web api projects.

Then i have created this fillOrder method to fill the list based on the query i have read from Dynamics ax 365 for purchase orders.

This is the main web api method for reading the purchase orders, i am reading top 50 for now.

After all this simple coding and all the configuration effort, when i click run on the project, i got this cool browser with my results of orders.

This is the result after all the effort,

Consuming Dynamics AX 365FO Data entities using Web API (Part 1)

Object is to read data from Dynamics ax 365FO data entities using Web Api project.

This is first part of the blog series on consuming Data entities using Web api, in this blog i will be covering the configuration part of the projects

Step 1: Download Dynamics ax integration sample project from GITHUB
https://github.com/Microsoft/Dynamics-AX-Integration/tree/master/ServiceSamples

 

Extract the project, you will see different samples.

Step 2: We will copy two projects AuthenticationUtility and ODataUtility and move to the new web api project we are going to create.

 

New project structure will look like this.

 

We also need to add the reference of dll of two projects  AuthenticationUtility and ODataUtility to our new projects.

There is a class ClientConfiguration in AuthenticationUtility project that is required a configuration change and requires to set following attribute from your Azure subscription.

UriString, UserName, Password, ActiveDirectoryResource, ActiveDirectoryTenant, ActiveDirectoryClientAppId, ActiveDirectoryClientAppSecret

In the next blogs i will be covering

1. How to setup web api project app on Azure and what are we needed to setup the app in Azure.
2. I will be covering code side also on which i will demonstrate how we can consume OData entity.

Thanks
Amir (Happy Daxing)