salesforce – SOQL Query on FieldPermissions

I want to list out Read and Write permissions for a few fields on an object from a profile.
I have a profile named CAPI and under the profile I want to find out all the field permissions from Account object. I’ve constructed this query for it

SELECT SObjectType, Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE SObjectType="Account" AND Field IN('Name','ShippingStreet','ShippingCity') AND Parent.Profile.Name="capi"

But no data gets exported when I execute it. What am I doing wrong? Any suggestions would be appreciated.

Read more here: Source link