Odata Aggregation in D365 Finance

(1) Share

Report

Posted on by PrebenAmilcare

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 (1)

Answers (0)

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

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