Status for Salesforce accounts are showing "Inactive" irrespective of the user's status

[Debankita]

Hi Team,

While importing the account for Salesforce application we are using the account filter query in order to import only active accounts but the status of all the imported accounts are showing as "Inactive".

We are using the Salesforce connector.

Please help by letting me know why is the status of the accounts showing wrongly in Saviynt?

[sk]

What is your FIELD_MAPPING_JSON and STATUS_THRESHOLD_CONFIG?

[Debankita]

Hi SK,

Field_mapping_JSON

{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"status": "IsActive~#~bool",
"customproperty3": "Login_ID__c~#~char",
"customproperty5": "UserRoleId~#~char",
"customproperty6": "ProfileId~#~char",
"accounttype": "UserType~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"creator": "CreatedById~#~char",
"updateUser": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date"
},
"profilefield_mapping": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"customproperty3": "ParentRoleId~#~char",
"customproperty4": "UserLicenseId~#~char",
"customproperty1": "UserType~#~char",
"description": "Description~#~char",
"customproperty7": "CreatedDate~#~date",
"customproperty8": "CreatedById~#~char",
"customproperty2": "RollupDescription~#~char",
"customproperty6": "DeveloperName~#~char",
"customproperty9": "PortalType~#~char",
"updatedate": "SystemModstamp~#~date"
}
}

Status_config_JSON

{

"statusAndThresholdConfig": {
"statusColumn":
"customproperty30",
"activeStatus": ["512","active"],

"accountThresholdValue": 10000,

"correlateInactiveAccounts": false

}
}

[sk · Accepted solution]

Add below parameter in Field_mapping_JSON

"customproperty30":"IsActive~#~bool"

And change STATUS_THRESHOLD_CONFIG as below

{

"statusAndThresholdConfig": {
"statusColumn": "customproperty30",
"activeStatus": true,

"accountThresholdValue": 10000,

"correlateInactiveAccounts": false

}
}