Retrieve API names of All object in Salesforce ORG using SOQL

Question

How to write SOQL query to retrieve all the object Name and API names of Sobject in Salesforce

Answer 1

Here's a method I've found. It's more explicit than using the permissions object.

Fields

SELECT  QualifiedApiName FROM FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Account' 

Objects

SELECT  QualifiedApiName FROM EntityDefinition order by QualifiedApiName 

Answer 2

You cannot do it with SOQL.

You need describe call

for ( Schema.SObjectType o : Schema.getGlobalDescribe().values() )
{
    Schema.DescribeSObjectResult objResult = o.getDescribe();
    system.debug( 'Sobject: ' + objResult );
    system.debug( 'Sobject API Name: ' + objResult.getName() );
    system.debug( 'Sobject Label Name: ' + objResult.getLabel() );   
}

Run this code in Execute anonymous and check debug. You will get all the sobject name(API Name), label and other properties.

Answer 3

String sObjectName = 'Project__c';
System.debug('=========  '+ sObjectName);
List<Schema.SObjectField> sss=new list<Schema.SObjectField>();

if(sObjectName != null && sObjectName != '' )

Schema.SObjectType gd = Schema.getGlobalDescribe().get(sObjectName); 
Schema.DescribeSobjectResult a11=gd.getDescribe();
Map<String, Schema.SObjectField> M = a11.fields.getMap();        
for(Schema.SObjectField s1:m.values()){                            
    Schema.DescribeFieldResult f = M.get(s1.getDescribe().getName()).getDescribe();
}

Thanks !!!

Answer 4

I haven't compared the list to the describe list but you can find a list of presumably all SObjects within the ObjectPermissions table listed under the SobjectType field. This field is weird though and doesn't allow some filtering (no LIKE operator for example). There is also a possibility the list is generated only from SObjects that are not public read/write, but I haven't checked to see if that is the case.

The proper way is definitely the describe, but this table might provide some insight as well in a quick query. I wouldn't use this route in production code though because of those uncertainties.

SELECT SobjectType FROM ObjectPermissions

Answer 5

The Best Ways to retrieve list of all Objects using Apex, you can use Schema.getGlobalDescribe() method.

Its simple use below code:

for( Schema.SObjectType o: Schema.getGlobalDescribe().values())
    System.debug(o.getDescribe().getName());

For more details check : The Best Ways to Retrieve Names of All Objects Using Apex

Answer 6

To get list of All Objects run below query from workbench:

SELECT QualifiedApiName FROM EntityDefinition ORDER BY QualifiedApiName LIMIT 200 OFFSET 200

Please know that there is a limit of max 200 records will be returned in list per retrieval. Hence add 'LIMIT 200' to restrict the result for first 200 records. Otherwise you will get below error

"EXCEEDED_ID_LIMIT: EntityDefinition does not support queryMore(), use LIMIT to restrict the results to a single batch"

If you need to get next results from record no 201 , 202, ... add 'OFFSET 200' to your query. this will show records from 201 to 400. Sililarly use 'OFFSET 400' for records from 401 to 600 and so on.

Answer 7

Using the list of fields names at FieldDefinition Fields and the basic query given by @oleg, I got exactly what nobody seems to have figured out how to get, easily, from a developer console window. In my case, I needed a list of all the fields on our Lead object, along with their key attributes (Type, Length, Precision, Label, etc.).

My SOQL query is as follows.

SELECT QualifiedApiName, Label, DeveloperName, Description, DataType, ExtraTypeInfo,  Length, Precision, Scale FROM FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Lead'

Getting the data from the console is a snap with the ColumnCopy extension for Chrome, about which you can learn more at https://chrome.google.com/webstore/detail/columncopy/lapbbfoohlcmlbdaakldmmallcbcbpjb. It copies everything except the label row in one swipe. That’s easy enough to hand copy. I am thrilled over the moon!

Answer 8

With the following SOQL, you can get Customizable object without using limit and offset

SELECT NamespacePrefix,  IsCustomizable, QualifiedApiName FROM EntityDefinition where IsCustomizable = true  order by QualifiedApiName 

For more field can be used in where clause to avoid EXCEEDED_ID_LIMIT, you can refer to EntityDefinition Fields

Answer 9

The below code snippet might help you to get you the list of CUSTOM OBJECTS you have in your Salesforce Org. You need to execute this on 'Anonymous Window' and check for the Debug log for the result.

    List<Schema.SObjectType> getSObjectDetail = Schema.getGlobalDescribe().Values();

    for(SObjectType st : getSObjectDetail)
    {
        //Check the object is Custom Object ?
        if(st.getDescribe().getName().contains('__c')) 
            System.debug('Object API Name : '+st.getDescribe().getName()+'   Object Label : '+st.getDescribe().getLabel());
     }