Get the record Count of all countable Sobjects in Salesforce

 Salesforce: Get the record count of all objects


Use case: A client wants to access the data volume for data migration and needs to get record counts from all countable objects in Salesforce

Solution: 
1) log in to Workbench
2) Go to Utilities > Rest Explorer
3) Do a GET call on this URI: /services/data/v56.0/limits/recordCount ( change 56.0 with the latest API version)
4) Check the result. Copy the JSON and convert it to CSV

Note:
1) The Rest call result does not include uncountable objects and record count for deleted records in the recycle bin
2) Ensure your user has "View Setup and Configuration” permission








Comments

Post a Comment

Popular Post

Use Of Standard Set Of Controller

Image
The Code used is as follows : VF Page :  <apex:page controller="opportunityList2Con">      <apex:form >         <apex:pageBlock >             <apex:pageBlockTable value="{!opportunities}" var="o">                 <apex:column value="{!o.name}"/>                 <apex:column value="{!o.closedate}"/>             </apex:pageBlockTable>                          <apex:commandButton rendered="{!setCon.hasPrevious}" value="first" action="{!setCon.first}"/>          ...
Read more

How to remove and Delete row from PageBlock table on VF page

<apex:page controller="Classname" sidebar="false">    <style> .Processing { position: fixed; background: url('/img/loading32.gif'); background-repeat: no-repeat; background-position: center; width: 100%; height: 100%; z-index: 1004; left: 0%; top: 0%; } </style> <apex:Form id="frmId"> <apex:actionstatus id="statusProcessing" startstyleclass="Processing"></apex:actionstatus> <apex:pageBlock id="blockTD"> <apex:variable var="delrowNumber" value="{!0}"/>  <apex:pageBlockTable value="{!lstofData}" var="objTB"> <apex:column headerValue="Action"> <apex:commandLink value="Del" style="color:red" action="{!delRow}" immediate="true" reRender="blockTD" status="statusProcessing" > <ap...
Read more

Show Pagination and Colum Sorting on VF page using Jquery Plugin

Image
Requirement:  To show Account record in table form on VF page and user able to paginate pages and sort the column: Solution:  Using Jquery Plugin you can directly implement pagination and column Sorting Download Jquery Plugin : https://sfcomponent-dev-ed.my.salesforce.com/sfc/p/#6F000001f5y8/a/6F0000004XWj/F0czOc51PF5iaC7ERZBb.cO.nU95xWyEaGcUTmPkCaU Add data table zip file in Static Resource Class Code: public class AccountController {  public List<Account> lstofacc{get;Set;}  public AccountController ()  {      lstofacc = new List<Account>([select id,AccountNo, name from account]);        } } Page Code: <apex:page controller=" AccountController  " sidebar="false" standardStylesheets="false" docType="html-5.0" tabStyle="Account"> <head> <apex:stylesheet value="{!URLFOR($Resource.DataTable,'DataTable/datatables.min.css')}" /> <apex:stylesheet value=...
Read more