Skip to main content
Post a question

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Query Service - experience sharing

Posted on 21 Apr 2022 08:32:32 by 35

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? 

  • Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on 21 Apr 2022 at 09:56:00
    RE: Query Service - experience sharing

    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);

  • AlexDr8 Profile Picture
    AlexDr8 35 on 21 Apr 2022 at 09:25:35
    RE: Query Service - experience sharing

    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?

  • Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on 21 Apr 2022 at 09:07:20
    RE: Query Service - experience sharing

    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.

  • AlexDr8 Profile Picture
    AlexDr8 35 on 21 Apr 2022 at 08:52:34
    RE: Query Service - experience sharing

    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?

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on 21 Apr 2022 at 08:42:43
    RE: Query Service - experience sharing

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans