Finance | Project Operations, Human Resources, ...

Query Service - experience sharing

(0) Share

Report

Posted on by AlexDr8

Hey! We are currently working on the documentation regarding the query service - https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/query-service.
There are several questions:

1. Does Query Service must be installed as an additional service or it's included in the standard Dynamics AX 2012 installation package?

2. Please share the experience with WSDL. How to get it? How to request it?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

1. It's included - you don't need to do anything.

2. You can find the URL of WSDL on the page that you've linked above. It's http://<servername>:8101/DynamicsAx/Services/QueryService (assuming the default port number).

Was this reply helpful? Yes No
AlexDr8 35 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply!

How to install or adjust this service for further use:

1. Could you please provide an example of how to call a service for getting data about the "Invoices" or "Customers"?

2. Where can I find the instruction with examples of how to generate the WSDL for getting the info mentioned in 1 question above?

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

1. Look at the link in your question. It already contains an example of calling a query to get customers.

2. You won't generate WSDL. This is a system service developed by Microsoft and you'll find WSDL on the URL mentioned above. You'll use this WSDL to generate a service client for calling the query service.

Was this reply helpful? Yes No
AlexDr8 35 on at

Like (0)

Report
Copy link

Link copied!

After generating service client and call - query service. Could you please provide an example of how to call a query service for retrieving data mentioned above e.g. Invoices?

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Please open the documentation page - you can find several examples there. This is one of them:

DataSet dataSet; Paging paging = null; dataSet = client.ExecuteStaticQuery("CustTable", ref paging);

Was this reply helpful? Yes No