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..
It is my experience timeline.
Sharing my knowledge and experience about the Microsoft Power Platform.
a guide to powering up community
Technical Leadership Centred Around the Microsoft Data Platform
Deriving Solutions and features on Power Platform/Dynamics 365
Thoughts & musings from a Dynamics 365 Ninja!
Learn about Microsoft Dynamics CRM Power Platform customization and implementation and other cool stuffs
I know pre-stroke. I will improve who I was.
Balu Gajjala
Power Melange By Shalinee
Power Automate - Power Apps - SharePoint Online - Azure - Nintex - K2 - Artificial Intelligence
An Inquiry in Being
The Influencers & Influences of Indian Music
Hand's-free money management
A closer look at Microsoft Dynamics 365.
Experienced consultant primarily focused on Microsoft Dynamics 365 and the Power Platform
Specific topics by Django Lohn on the whole Microsoft365 Stack
One Stop Destination for Microsoft Technology Solutions
Naturally Curious
Prasanna Vadlamudi
Power Platform and Dynamics 365
A Microsoft Business Applications MVP
Bass defines your home theater
SQL Server tips and experiences dedicated to my twin daughters.
Discovering Azure DevOps and D365 Business Applications
Lets do IT Spells
Russ Parry REALTOR®
Power Platform & Dynamics CRM
Mail to crmtipsbyprm@gmail.com for queries and suggestions
Giving back to the community what I have learned
Learn and Share
Dynamics CRM Technical & Functional Info
Sometimes you need to look at things from different perspective.
Dynamics 365 Customer Engagement, CRM, Microsoft CRM, Dynamics CRM
Step into the world of a Dynamics 365 Consultant
Diana & Dynamics 365 & Power Platform
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