Integrating Dynamics AX With Mobile (iOS, Android, Windows Phone, Windows Store) using ASP.NET Web API

What if your lead asks you to integrate Dynamics AX with your Mobile application? In that case you need to be smart. If you have worked with WCF, you would be having an idea that when you host WCF you get a WSDL link which you can use to add a service reference.

Dynamics AX has AIF (Application Integration Framework) which is used to integrate Microsoft Dynamics AX with external software systems.

MSDN says,

Application Integration Framework (AIF) provides an extensible framework that supports multiple asynchronous transports, as well as synchronous transport using Web services, to reliably exchange documents in XML format with trading partners or other systems.

An exchange starts with a document, that is, a document class defined using Microsoft Dynamics AX business logic. The document is serialized into XML and header information is added to create a message, which may then be transferred into or out of your Microsoft Dynamics AX system (called the local endpoint within AIF).

Now issue here is that I need to integrate different tables of Microsoft Dynamics and need to Get and Post data to them. I have two options here,

I might create a WCF and host that to communicate with my Mobile Application that may be Android, iOS or Windows Phone & Store.
I might create ASP.NET Web API and communicate with my Mobile Application.

I preferred ASP.NET Web API on WCF, here are some of the reasons:

WCF	ASP.NET Web API
Enables building services that support multiple transport protocols (HTTP, TCP, UDP, and custom transports) and allows switching between them.	HTTP only. First-class programming model for HTTP. More suitable for access from various browsers, mobile devices etc enabling wide reach.
Enables building services that support multiple encodings (Text, MTOM, and Binary) of the same message type and allows switching between them.	Enables building Web APIs that support wide variety of media types including XML, JSON etc.
Supports building services with WS-* standards like Reliable Messaging, Transactions, Message Security.	Uses basic protocol and formats such as HTTP, WebSockets, SSL, JQuery, JSON, and XML. There is no support for higher level protocols such as Reliable Messaging or Transactions.
Supports Request-Reply, One Way, and Duplex message exchange patterns.	HTTP is request/response but additional patterns can be supported through SignalR and WebSockets integration.
WCF SOAP services can be described in WSDL allowing automated tools to generate client proxies even for services with complex schemas.	There is a variety of ways to describe a Web API ranging from auto-generated HTML help page describing snippets to structured metadata for OData integrated APIs.
Ships with the .NET framework.	Ships with .NET framework but is open-source and is also available out-of-band as independent download.

Once we are done with developing our ASP.NET Web API we are going to host that using IIS Server and use public IP to let our mobile application communicate with our Microsoft Dynamics AX through Web API.

Being a mobile guy I don't have much idea about Dynamics AX. It took me few hours to understand Dynamics AX and in this tutorial I would start from scratch as if you never interacted with Dynamics AX previously.

So, let's start,

Let's start with a simple table, I would first create a simple table having not more than three attributes,

ID
First Name
Last Name

And name the table as STUDENT.

We need to create a Unique Index field as well because if we are targeting READ and FIND method of Document Service.

In AOT under Query Node with Name AxdStudentInfo, create a new DataSource and add StudentInfoTable. Right click on field and set Dynamic Property to Yes.
Now right click on “StudentInfoTable” Node and set its Update properties to true, so Update methods will get created against this query object.
Now in Development environment from top menu click on AIF frame and then select Create Document Service and click on it. For this result in running a Wizard.
Select the following options from Wizard and select the query which we created from the above mentioned drop down. Name the Document Name.
Press Next button, from the next button check all the checkboxes as per the following:.
Press on Next Button.
Press on Generate button.
Press on Finished button.

There is a possibility of errors in the generated code, You can find complete code generated with wizard in private project in Dynamics AX.
Right click on AxdStudentInfo and compile again.

You have deleted two methods cacheObject and cacheRecordRecord in AxStudentInfoTable and compiled the complete project.
Now right click on StudentInfoService and set namespace.
Now right click on Service group Node and create a new service group.
Drag and drop service node under Student InfoService group. So Student Service will be available for in side service group.
Now generate Inc CIL or right click on StudentInfoServicegroup and click deploy.
After successful deployment you may find the following info box.
Now open a new work space and go at System Administration module and open in bound port under Application integration framework.

And Open Application Inbound framework.
Copy WSDL URL and now our real work starts.
Create New ASP.NET project and select Web API from template.
Create New Controller and Create a Post Method for that.
Now we need to consume our WSDL Link, for that we need to first of all add a Service Reference in solution explorer. Enter your WSDL link to complete the Wizard.
After you have added service reference you need to consume that service reference and sync that with POST method of your Web API.

Here is mine,

Code:

public void Post([FromBody]Person value)
{
ServiceReference2AxdStudentQuery _TableQuery = new ServiceReference2AxdStudentQuery();
ServiceReference2AxdEntity_StudentsTable_1 _StudentTable = new ServiceReference2AxdEntity_StudentsTable_1();
_StudentTable.Name = value.Name;
_StudentTable.ID = value.ID;
_TableQuery.StudentsTable_1 = new ServiceReference2AxdEntity_StudentsTable_1[1] { _StudentTable };
ServiceReference2StudentQueryServiceClient _Client = new ServiceReference2StudentQueryServiceClient();
ServiceReference2CallContext _callContext = new ServiceReference2CallContext();
_callContext.Company = "USMF";
ServiceReference2EntityKey[] entityKeys = _Client.create(_callContext, _TableQuery);
}

Now what you need to do is to start that Web API in Google Chrome as it renders JSON more easily. I am using JSON as format of data so I need to add two lines to change that form XML to JSON. Add these lines in WebApiConfig.cs file

Code:

var appXmlType = config.Formatters.XmlFormatter.SupportedMediaTypes.FirstOrDefault(t => t.MediaType == "application/xml"); config.Formatters.XmlFormatter.SupportedMediaTypes.Remove(appXmlType);

To test it you just need to post to the URL of your Web API using any of the tool. I personally use Fiddler. When you would open Table in Table Explores you would notice that your POST have added data respectively to Dynamics Student Table. We are done with your Integration, Now next part here is to integrate that with mobile.

All the work I have done here is in a server environment. To use that Web API I need to host that using IIS Server. Here a blog that you can follow.

Once you have hosted your Web API, you would be having a URL that you may use to hit that.

You can consume that API on any of the platform that supports JSON. e.g. Windows, Android, iOS or any platform including JAVA.

Let's try to look at the procedure to consume that in Universal Windows Platform Application.

Whenever you are parsing JSON you need to request data using Client. Well it's same for parsing Json.net way or native way.

Code:

First you need initialize client to request JSON data,

var client = new HttpClient();

Then for obvious reasons you need to put request URL for JSON data,

Code:

HttpResponseMessage response = await client.GetAsync(new Uri("http://YourserviceURL"));

It's time to get JsonString so that we can parse that,

Code:

var jsonString = await response.Content.ReadAsStringAsync();

Now here things become a bit tricky, my json is consisted to simple JSONArray, your JSON may appear a bit different from what my json looks like. Here is a way to know how your JSON looks like. Just navigate to json2csharp.com, put the url of JSON and it would return you with respective C# class of your JSON. You may use that to cast you JSON object.

As my JSON is a simple array so I just need to cast that to JSONArray and get out objects from that. I have saved my JSON respective C# class as "RootObject"

Code:

JsonArray root = JsonValue.Parse(jsonString).GetArray();
for (uint i = 0; i < root.Count; i++)
{
//Parse that accordingly
});

Here obs_mydata is my ObservableCollection where I am adding channels, whereas RootObject is my JSON respective C# class. Now you just need to bind your Observable Collection with UI. I would strongly suggest you to follow MVVM pattern and get full out of BLEND for VS.

To get respective C# class of your JSON you can use an online tool.

I hope you would have got some idea from this article about integrating Dynamics AX with your Mobile App of any other platform.

Credits: Some of the documentation of MSDN has been used as part of blog.

7 Comments

Join the conversation! Your thoughts help the community grow.

Bhuvanesh Mohankumar10y ago
Good one...
Imran Javed Zia11y ago
Nice Work
Mukesh Kumar11y ago
Great One
Harshad Pansuriya11y ago
Nice one
Sibeesh Venu11y ago
Nice Share
Nilesh Jadav11y ago
Good Share !!
Mohammed Ibrahim11y ago
nice