MS CRM Online: Get all accounts with more than X contacts

Question

Is it possible to get all accounts in MS CRM Online with more than X contacts via odata (this is probably not possible via FetchXML)?

Something like (dummy code, does not work):

accounts?$apply=aggregate(contact_customer_accounts with countdistinct as total)/filter(total gt X)

I think the only way to do this would be to add a calculated field to Account that counts the number of Contacts — jasonscript, Sep 10 '20 at 02:10
Thanks - I actually wanted to avoid this, but I think you are right — Eichi, Sep 10 '20 at 05:04

score 1 · Accepted Answer · answered Sep 10 '20 at 17:59

1

Unfortunately, this is not possible as it is not straight forward with a single query using fetchxml (no support for subquery and aggregation with having clause) or web api. You can pull all the results and do aggregation using LINQ or other ways.

Compared to that, using a single rollup attribute to count the child contact records on parent account (not a calculated field) is the easiest option.

answered Sep 10 '20 at 17:59

Arun Vinoth-Precog Tech - MVP

22,364
14
59
168

1

also, check this answer and comment by chris, give it a try - https://stackoverflow.com/a/45850995/7920473 – Arun Vinoth-Precog Tech - MVP Sep 10 '20 at 19:16

MS CRM Online: Get all accounts with more than X contacts

1 Answers1