How do you get a list of all the objects and fields in your Salesforce instance? If you have worked on Oracle, you can query views like DBA_TABLES & DBA_TAB_COLUMNS, if you have worked on SQL Server you can query SYS.TABLES & SYS.COLUMNS. Unfortunately, there isn’t a similar simple way in Salesforce. With Salesforce you need to use Metadata APIs and write a few lines of code to get the details.
You can try Schema Lister developed by one of the developers at Tquila. Navigate to URL https://schemalister.herokuapp.com/, select your environment and API version, authorise the Apps through OAuth and it will generate a list of all the objects and fields. The benefit of using this app is that you don’t need to install anything in your Salesforce org and don’t need to provide your Salesforce username and password (as the app uses OAuth to connect to Salesforce)
References & Useful URLs
- You can now also create a report on object and fields definition in Salesforce and here is another blog post at URL How to Report on Objects and Fields Defined in Salesforce
- AppExchange Apps with Keyword ‘metadata’ – Or https://appexchange.salesforce.com/results?keywords=metadata
I had no success with the tool. It gets stuck on Querying objects and fields… for hours and does not complete.
Hi Darren, this is an external tool and I am not sure if the tool is still maintained. Now, you can get the object and list information using report in Salesforce. Please check this blog post on how to do this – https://www.asagarwal.com/how-to-report-on-objects-and-fields-defined-in-salesforce/
I followed the steps, but the report doesn’t give me objects. When I select label, it returns contract history or task history.
Hi Sonia, I tested it after receiving your comment and it worked fine for me. Or alternatively, you may want to follow the instructions in this blog post to get a list of all your objects and fields – https://www.asagarwal.com/how-to-report-on-objects-and-fields-defined-in-salesforce
Thanks Ashish. Is it possible to get the description as well ? If yes… Please let me know the process to get it done.
Thank Ashish for the great Post!! The URL does not work unfortunately.
Thanks Ashish for sharing the great post!
Awesome post,very helpful and time saving!
Thank you Ashish for sharing this!
Ashish,
What a great post! Most useful. thank you for sharing!
Thanks Maria !