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

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at

Like (0)

Report

Odata Aggregation in D365 Finance

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2

Martin Dráb 232,011 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans