web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Odata Aggregation in D...

Finance | Project Operations, Human Resources, ...

Unanswered

Odata Aggregation in D365 Finance

(1) Share

Report

Report

Posted on by PrebenAmilcare

2

Hi,

I'm trying to use the D365 Finance odata api to do aggregations. Whenever I try to use the queries as described in the link below, I don't get any different results. Does anyone here know if aggregation methods are supported in the D365FO odata api? Is there any pre-requisites?

I find very little when googling this, so any help would be appcriciated.

example: ~?$apply=aggregate(Amount with sum as Total)

https://docs.oasis-open.org/odata/odata-data-aggregation-ext/v4.0/cs01/odata-data-aggregation-ext-v4.0-cs01.html#_Toc378326295:~:text=3%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%20System%20Query%20Option%20%24apply

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 303,481 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Preben,

Aggregation is not supported with the OData connector for Dynamics 365 Finance. You can find supported statements on this page: Open Data Protocol (OData) - Finance & Operations | Dynamics 365 | Microsoft Learn

If you need aggregated data, you can first consume data in another service and then perform the aggregation or develop another data entity having already aggregated data.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 527 Super User 2026 Season 1

#2

Giorgio Bonacorsi 473

#3

Adis 284 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans