Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

ImportAccountEntJson - No Entilements and Account status

Saviynt_Savvy
Regular Contributor
Regular Contributor

Hi All,

I am using the below ImportAccountEntJson where I get

All the accounts as Active and No Associated Entitlements in the Account details.
Also Not able to import any Entitlements.

What is the modification required to make in the below JSON.

ImportAccountEntJSON:
{
"accountParams":{
"connection":"acctAuth",
"processingType":"SequentialAndIterative",
"statusAndThresholdConfig":{
"statusColumn":"customproperty5",
"activeStatus":[
"Active"
],
"deleteLinks":false,
"accountThresholdValue":1000,
"correlateInactiveAccounts":true,
"inactivateAccountsNotInFile":false,
"deleteAccEntForActiveAccounts":true
},
"call":{
"call1":{
"callOrder":0,
"stageNumber":0,
"http":{
"url":"https://192.xxx.xx.xx/phoenixapi/xxxxxxx/sandbox/Admin/Global/Employees/search",
"httpContentType":"application/json",
"httpMethod":"GET",
"httpHeaders":{
"Authorization":"${access_token}",
"Accept":"application/json"
}
},
"listField":"result",
"keyField":"accountID",
"colsToPropsMap":{
"accountID":"employeeId~#~char",
"name":"employeeName~#~char",
"status":"status~#~char",
"customproperty1":"userName~#~char",
"customproperty2":"emplClassCode~#~char",
"customproperty3":"tellerClassCode~#~char",
"customproperty4":"ptid~#~char",
"customproperty5":"status~#~char",
"customproperty6":"networkAcct~#~char",
"customproperty31":"STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings":{
"Security Group":{
"listField":"result",
"idPath":"emplClassCode",
"keyField":"entitlementID"
}
}
},
"entitlementParams":{
"connection":"acctAuth",
"processingType":"SequentialAndIterative",
"entTypes":{
"Security Group":{
"entTypeOrder":0,
"call":{
"call1":{
"callOrder":0,
"stageNumber":0,
"http":{
"url":"https://192.xxx.xx.xx/phoenixapi/xxxxxx/sandbox/Admin/Global/Employees/Classes/search",
"httpContentType":"application/json",
"httpMethod":"GET",
"httpHeaders":{
"Authorization":"${access_token}",
"Accept":"application/json"
}
},
"listField":"result",
"keyField":"entitlementID",
"colsToPropsMap":{
"entitlementID":"emplClassCode~#~char",
"entitlement_value":"emplClassCode~#~char",
"description":"description~#~char",
"status":"status~#~char"
}
}
}
}
}
},
"acctEntParams":{
"processingType":"acctToEntMapping"
}
}

Below is the JSON Response of the API call for Accounts:

{
"pagingInfo": {
"totalResults": 10,
"pageSize": 10,
"currentPage": 1,
"moreRecords": true
},
"result": [
{
"sex": "M",
"addressLine1": null,
"depositDr": 999999999.00,
"glCrOff": 0.00,
"loanCrOff": 0.00,
"depositCrOff": 0.00,
"tin": null,
"allowCtrApproval": "Y",
"sdDr": 999999999.00,
"loanCr": 999999999.00,
"allowUcfDefChange": "N",
"restrictId": 5001,
"rimDr": 999999999.00,
"allowRateChange": "N",
"interests": null,
"branchNo": 100,
"sdCrOff": 0.00,
"escheatedAccess": "N",
"emplType": "External",
"tellerNo": 95,
"skills": null,
"allowMultiLogon": "N",
"tellerClassCode": 19,
"employeeName": "System",
"rimDrOff": 0.00,
"userName": "SYSTEM",
"emplClassCode": 10,
"employeeId": 0,
"emplId": 0,
"ptid": 1,
"rowVersion": 10,
"status": "Closed",
"networkAcct": null,
"exCr": 999999999.00,
"exDr": 999999999.00,
}
],
}

I am also using the below STATUS_THRESHOLD_CONFIG and Config_JSON in the connection:
Status_Threshold_Config:
{
"statusColumn": "customproperty5",
"activeStatus": [
"Active"
],
"correlateInactiveAccounts": true
}

Config JSON:
{
"showlogs": true,
"statusConfig": {
"active": "Active",
"inactive": "Inactive"
}
}

Thanks & Regards,
SaviyntSavvy

 

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

keep Status mapping either in Status threshold config or Import json


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Hi @rushikeshvartak ,
Thank you for the reply.
I have modified the JSON later and I am using it only in the Import JSON.
Now I'm able to import the accounts but yet not able to import the entitlements.
I see the below message in the log details after running the AccountImport Job.
"associated entitlement : Security Group with account is not for import."

Saviynt_Savvy_1-1715234193458.png

Please see the forum link below where I'm mentioned that issue.
https://forums.saviynt.com/t5/identity-governance/importaccountent-json-associated-entitlement-secur...

Thanks & Regards,
SaviyntSavvy

Please provide updated JSON , if this issue is resolved then lets track other issue in another thread


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Manu269
All-Star
All-Star

Is the api validated in postman?

Check the response please

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.