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