Retrieve customer full data from Dynamics ax 2012 and show it in MVCproject

Question

I want to list all customer information in grid-view using MVC c#. also i want to return data from c# to client as json format because I'm using angularjs. I already create AIF and link it with my MVC project , but still i do not know how to retrive all customer data.

any help please

its simple code , just get customer name and id and save it in object variable — alhamdi.cs, Feb 09 '17 at 06:54
Do you have access to the AX db? If you do, you can just query the the db from your MVC project and map the results to a model class then send it to frontend in any format you like(eg. json) — Nagarjuna Yendluri, Feb 10 '17 at 17:21

Aliaksandr Maksimau · Accepted Answer · 2017-02-08T20:58:15.093

0

I think this is exactly what you are looking for:

Query Service [AX 2012]

The query service is one of the Microsoft Dynamics AX system services that enables you to issue a query for data without using an Application Integration Framework (AIF) document service or creating a custom service. The query service returns data in a dataset and implements a paging mechanism so that you can manage large amounts of data returned by a query.

Walkthrough: Calling the Query Service with a Static Query

Another option is to create a custom service or add a service operation to a standard customer service

edited Feb 08 '17 at 20:58

answered Feb 08 '17 at 20:50

Aliaksandr Maksimau

2,251
12
21

in C# side, I know how to use dynamics ax. but in dynamics classes i do not know how to write a method that return all customer list (name, accountNum,....) – alhamdi.cs Feb 09 '17 at 07:11
Then use the first approach (query service). This method doesn't require coding on Dynamics AX side. First link contains C# code that retrieve all customers from AX – Aliaksandr Maksimau Feb 09 '17 at 07:23

Retrieve customer full data from Dynamics ax 2012 and show it in MVCproject

1 Answers1

Query Service [AX 2012]