Using RetrieveTotalRecordCount Function we can get the total number of records for an entity (works for more than 50000 records)
For e.g.
https://dreamingincrm.com/2019/07/22/getting-entity-record-counts/
https://stackoverflow.com/questions/51543802/counting-all-rows-in-dynamics-crm-online-web-api-odata
https://nishantrana.me/2020/05/27/different-ways-of-getting-record-count-total-in-dynamics-365/
Hope it helps..
Advertisements
Discover more from Nishant Rana's Weblog
Subscribe to get the latest posts sent to your email.
Share It -
Nishant Rana's Weblog 
Does it get count of all records like SQL query or it has limitations like max 50k?
LikeLike
I am trying to get count for an entity by providing above syntax in api call and executing it through python script .
cntcrmwebapi = ‘https://URL/?RetrieveTotalRecordCount(EntityNames=[\’EntityName\’])’
print(cntcrmwebapi)
I am getting result as Response 200 .. How to capture output of count of records ?
LikeLike
I found this extremely helpful (since Microsoft’s documentation is spectacularly insufficient). Many thanks indeed.
LikeLiked by 1 person
Thanks for your kind words..
LikeLike