Issue with salesforce while importing custom attributes

[sandeepgudipudi]

We are facing an issue with custom column import in the salesforce connector. When trying to import an account from Salesforce Application the Account reconciliation job fails for  custom field with below given error. Could you please assist if any additional mappings needs to be done.

Attribute Name: "Integration_User__c" and Data Type is checkbox

Error:

InvalidBatch : Failed to process query: INVALID_FIELD: FederationIdentifier, UserPermissionsSupportUser, Integration_User__c FROM User where ^ ERROR at Row:1:Column:312 No such column 'Integration_User__c' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.

Configurations:

ACCOUNT_FIELD_QUERY

Id, Username, LastName, FirstName, Name, CompanyName, Email, IsActive, UserRoleId, ProfileId, UserType, ManagerId, LastLoginDate, LastPasswordChangeDate, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, ContactId, AccountId, FederationIdentifier, UserPermissionsSupportUser, Integration_User__c

FIELD_MAPPING_JSON

{

  "accountfield_mapping": {

    "accountID": "Id~#~char",

    "name": "Username~#~char",

    "customproperty2": "LastName~#~char",

    "customproperty1": "FirstName~#~char",

    "displayName": "Name~#~char",

    "customproperty3": "CompanyName~#~char",

    "customproperty4": "Email~#~char",

    "status": "IsActive~#~bool",

    "customproperty5": "UserRoleId~#~char",

    "customproperty6": "ProfileId~#~char",

    "accounttype": "UserType~#~char",

    "customproperty7": "ManagerId~#~char",

    "lastlogondate": "LastLoginDate~#~date",

    "lastpasswordchange": "LastPasswordChangeDate~#~date",

    "CREATED_ON": "CreatedDate~#~date",

    "creator": "CreatedById~#~char",

    "customproperty8": "LastModifiedDate~#~date",

    "updateUser": "LastModifiedById~#~char",

    "updatedate": "SystemModstamp~#~date",

    "customproperty9": "ContactId~#~char",

    "customproperty10": "AccountId~#~char",

    "customproperty13": "FederationIdentifier~#~char",

    "customproperty20": "UserPermissionsSupportUser~#~bool",

    "customproperty23": "Integration_User__c~#~bool"

  }

}

I tried giving data type as 

"customproperty23": "Integration_User__c~#~bool" and "customproperty23": "Integration_User__c~#~char"

[AmitM]

Hi @sandeepgudipudi , have you tried in postman , get request , below is sample that we used.

https://XXXX.com/services/data/v57.0/query?q=SELECT+XXX_User_Id__c+,id+, Username,LastModifiedById,SystemModstamp,profileId,LastLoginDate,CreatedDate,CreatedById,Name,IsActive,FirstName,LastName,CompanyName,Email,UserRoleId,ManagerId,LastModifiedDate,ContactId,AccountId,Country,Title,FederationIdentifier,Department,Liner_Brand__c,Cluster__c,CM_Visibility__c,Region__c,UserPermissionsSupportUser+FROM+User+where+UserType='Standard'

I used to get this error when attribute was not correct or not enough permissions. Using postman will atleast eliminate the possibility of Saviynt issue. If not working in postman meaning you need to get it resolved on Salesforce side.

Thanks,

Amit

[sandeepgudipudi]

Hi Amit,

Its a similar error i received in logs, how can it me overcomed

postman query:

{{_endpoint}}/services/data/v{{version}}/query/?q=SELECT+Id, Username, LastName, FirstName, Name, CompanyName, Email, IsActive, UserRoleId, ProfileId, UserType, ManagerId, LastLoginDate, LastPasswordChangeDate, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, ContactId, AccountId, FederationIdentifier, UserPermissionsSupportUser, Integration_User__c +FROM+User+where+UserType='Standard'

Response:

        "message": "\nFederationIdentifier, UserPermissionsSupportUser, Integration_User__c  FROM User where\n                                                  ^\nERROR at Row:1:Column:312\nNo such column 'Integration_User__c' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.",

        "errorCode": "INVALID_FIELD"

[AmitM]

Check with Salesforce team and ask them Attribute API name. IN salesforce , there are different names for same attribute. And use the exact name as shared by team.

Share them it's not working even in postman.

Thanks,

Amit

[sandeepgudipudi]

Hi,

The API Name is same as field name and if you have an idea on what kind of permission are required please let me know

[Dhruv_S]

Hi @sandeepgudipudi 

As suggested by @AmitM Please check with Salesforce support to get the correct field name and API. As per the error message, Integration_User__c  is not a valid field.

If it is failing in postman, it is expected to fail from Saviynt as well. 

Regards,

Dhruv Sharma

[sandeepgudipudi · Accepted solution]

Hi,

issue is resolved after Salesforce team changed permissions on the Attribute

[AmitM]

HI @sandeepgudipudi , good to know that it is resolved.

It will help if you can accept one of the response as Solution. 

Or write your own version that will best suit the SOLUTION. And accept that as solution for others.

Also consider giving Kudos to post that helped you to reach to a solution.

Thanks,

Amit