Is there a way to get a profile's field level security? I tried an soql query for FieldPermissions object but it's based off of permission sets so if there's no permission set with at least read access on that field, it doesn't show up. However, I want all the fields on the profile itself.

  • 1
    What you are trying to achieve? Is it just for documentation purpose, or ts for business use case? – Pranay Jaiswal Aug 26 '19 at 18:55
  • Want to turn it into excel sheet to use – Peter Luo Aug 26 '19 at 18:58
  • Last time I did this, I wrote an Excel Macro. One API call to get all field names and generate columns/rows, then another to get the active fields, which populated the grid. It took a couple of days because I suck at VBScript, but overall wasn't too hard to accomplish. Sadly, I don't have the source for this any longer. – sfdcfox Aug 26 '19 at 21:31

Your Answer

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

Browse other questions tagged or ask your own question.