Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

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

Debankita
New Contributor III
New Contributor III

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?

3 REPLIES 3

sk
All-Star
All-Star

What is your FIELD_MAPPING_JSON and STATUS_THRESHOLD_CONFIG?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Debankita
New Contributor III
New Contributor III

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


}
}

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


}
}


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.