Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Is It True that NAV OD...
Microsoft Dynamics NAV (Archived)

Is It True that NAV OData web service does not support $count? NAV 2013

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We get this error whenever we try to use $count or $inlinecount.

Is this a shortcoming of NAV's implemenation of OData? If so we might be forced to use Web Services instead.  See below. Is there a workaround in OData?

<code/>
<message xml:lang="en-US">An error occurred while processing this request.</message>
<innererror>
<message>
Exception has been thrown by the target of an invocation.
</message>
<type>System.Reflection.TargetInvocationException</type>
<stacktrace/>
<internalexception>
<message>
Client requests containing $count or $inlinecount are not supported by NAV OData web services.
</message>
<type>
Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataException
</type>
<stacktrace/>
</internalexception>
</innererror>
</error>

 

*This post is locked for comments

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Is It True that NAV OData web service does not support $count? NAV 2013

    hi,

    actually is not resolved in NAV 2013 R2 (i think that is by design not supported and related to .NET Framework with ATOM integration)

    This problem exist also for CRM 2013, SharePoint 2013 and Online releases.

    Look at these posts about CRM 2013

    msdn.microsoft.com/.../gg309461.aspx

    Solutions for CRM here: use filters, fetch & sum functions to count data (workaround)

    community.dynamics.com/.../117356.aspx

    social.microsoft.com/.../odata-query-to-return-record-count

  • Francis Harvey Profile Picture
    Francis Harvey 30 on at
    RE: Is It True that NAV OData web service does not support $count? NAV 2013

    Hi Michael,

    Did you find a way to resolve the issue?

    I'm having the same problem....

    Is there someone who knows if this is resolved in an update or in R2...??

    Thanks a lot,

    Francis Harvey

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

Featured topics

Product updates

Dynamics 365 release plans