
Hi All,
I want to use group by in the web api query below is the query i am using, but getting error,
https://xxxxx.crm.dynamics.com/api/data/v9.0/accounts?$select=name&$top=3?$apply=groupby%20((name))
Any help would be appreciated.
Regards,
Shahbaaz
*This post is locked for comments
I have the same question (0)Hi Shahbaaz,
My understanding is if you need to group by records it should be based on a field from a parent.
for e.g in below example i am grouping accounts(child) by a parentaccount ( parent) ( lookup).
passion4dynamicscrm.api.crm8.dynamics.com/.../accounts$select=name&$apply=groupby((parentaccountid/name))
what exactly you would like to retrieve?