I want to get an overview of all custom fields I have in an org. I don't want to see them just for a single object - I want so see them all "at once" (for the whole org). Also it would be neat if I could filter them by namespace.

Can I query them via the Metadata API? If so - how?

  • Btw - I think I saw a colleague with this once in Excel / Power BI. But I cannot find anything for this either. – Semmel Mar 5 '19 at 15:08
  • I've used the Field Dumper app on AppExchange and it worked well enough. It doesn't display the namespace in a separate column, only in the field's API name. – David Cheng Mar 5 '19 at 16:11

You can do this in the Tooling API (e.g. Developer Console):

SELECT NamespacePrefix, DeveloperName, TableEnumOrId
FROM CustomField

In the Developer Console in Salesforce, click on the Query Editor tab, use the above query and check the "Use Tooling API" checkbox. You can add a WHERE clause if you want to specify a certain namespace, name, or object.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.