Rest API Get with a condition

Question

I have two columns :

1- ManagerEmail- This contains the manager emails

2- Status - values saved in this are Pending , Approved , Rejected.

Requirement : Want to fetch only those manager's emails whose status value pending count is more then 25 )

As i have to send mail those manager whose pending status exceed 25 request. I have mail code but i am confuse in Rest API End Point query for this senario

Answer 1

You can structure your query as:

GET /your-api-endpoint?filter=Status eq 'Pending'&$count=true&$apply=groupby((ManagerEmail),aggregate(Status, countdistinct as PendingCount))&$filter=PendingCount gt 25&$select=ManagerEmail