Why FirstName, LastName, Company field not found in FieldPermission query result

field-level-securityfieldsleadspermission-setspermissions

I'm trying to get all fields and its read and write permission using below query

SELECT Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE SObjectType ='Lead' AND parentId IN ( SELECT permissionSetId FROM PermissionSetAssignment where assigneeId IN('#assignee_Id #'))

I'm getting expected result :

But still some fields are missing in the output like "FirstName, LastName, Company, Street, City, Country…"

assignee_Id is System Administrator and having Field-Level access to all fields.

Facing same issue with Account and Contact.

Best Answer

FieldPermissions represents the enabled field permissions for the parent Permission Set. It's not a representation of everything that someone has access to.

The fields you identified: FirstName, LastName, Street, etc are fields that Salesforce sets access to.

You'll notice, within a permission set, that when you set Object Settings for Lead, those fields aren't included (meaning they're not permissionable).

You can see this another way through the fields property of DescribeSObjectResults (or through workbench explorer). A field has a property called permissionable

Schema.DescribeFieldResult dfr = Schema.SObjectType.Lead.fields.FirstName;
System.debug(dfr.isPermissionable()); //returns false

Indicates whether FieldPermissions can be specified for the field (true) or not (false).

Related Solutions

[SalesForce] “Required fields are missing” on non-null field

In short, there's four components that determine what goes into Salesforce (assuming stable connections, no weird firewalls that strip data from messages etc).

The original data
The mapping of original data to SF Objects
Triggers etc. in SF
Access rights in SF

It seems you ruled out 1, 3 and 4 to be the problem, so there's no other conclusion that 2 is the problem.

Check a network analyzer like WireShark to see what is actually going over the line, and try other import tools like DataLoader to check if the import still fails when you know that 2 is good. Possibly, create an Apex Trigger on the Account Object and System.debug(...) all incoming data, especially the LastName field.

[SalesForce] Why MailingPostalCode field is not found in Address object

When trying:

Contact c = [Select Id, MailingAddress From Contact Limit 1];
system.debug(c);
system.debug(c.MailingAddress.postalcode);

We get the error:

Invalid foreign key relationship: Contact.MailingAddress

However this works as expected:

Contact c = [Select Id, MailingAddress From Contact Limit 1];
system.debug(c);
system.debug( ( (Address)c.MailingAddress ).postalcode);

Address a = (Address)c.MailingAddress;
system.debug(a.postalcode);
system.debug(a.getPostalCode());

Best Answer

Related Solutions

[SalesForce] “Required fields are missing” on non-null field

[SalesForce] Why MailingPostalCode field is not found in Address object

Related Topic