Book Image

Microsoft Dynamics AX 2012 Services

By : Klaas Deforche, Saelen Kenny
Book Image

Microsoft Dynamics AX 2012 Services

By: Klaas Deforche, Saelen Kenny

Overview of this book

Because an ERP system like Microsoft Dynamics AX 2012 plays a central role in an organization, there will always be the need to integrate it with other applications. In many cases, services are the preferred way of doing this, and Microsoft Dynamics AX 2012 is now more flexible than ever when it comes to the creation and use of these services. Understanding these services will help you identify where they can be used, and do so effectively."Microsoft Dynamics AX 2012 Services" is a hands-on guide that provides you with all the knowledge you will need to implement services with Microsoft Dynamics AX 2012. The step-by-step examples will walk you through many of the tasks that you need to perform frequently when creating and using services."Microsoft Dynamics AX 2012 Services" provides detailed and practical examples for creating and using services that will make it a resource you will consult many times during your implementationsThis book helps you to identify situations where services can be used for your implementations. By providing step-by-step instructions for many of the common tasks, you will gain practical know-how on to get the job done.Easy to follow instructions are provided for all types of services you will encounter. You will learn how to create document services using the AIF Document Service Wizard and how to use X++ to create custom services. You will also learn how to deploy services and web services and how you can consume them in both X++ and .NET. The services are also put to use in the SysOperation framework, which uses services to run business logic and is the new way to create batch processes in Microsoft Dynamics AX 2012.
Table of Contents (9 chapters)

Query service


The query service enables us to retrieve data from Microsoft Dynamics AX without having to use the .NET Business Connector or, even worse, access the SQL database directly.

By using the query service, you can fetch data using any of the following query types:

  • Static query: This is used to retrieve data by using queries that are present in the AOT. We will use this type in the demonstration.

  • User-defined query: A query can also be created by using the QueryMetadata class. By doing this, you can create a query in the same way as you create queries in X++ code.

  • Dynamic query: Another way of running a query is by creating an X++ class that extends the AifQueryBuilder class. You can invoke the ExecuteQuery operation by passing in the name of the query builder class. It is also possible to pass arguments by using a class that extends from the AifQueryBuilderArgs class.

Fetching data for the grid

Now let's put some code behind the clicked event handler of the Refresh button. The idea is...