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? Aug 26, 2019 at 18:55
  • Want to turn it into excel sheet to use
    – Peter Luo
    Aug 26, 2019 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, 2019 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.