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

Accnt Ent Mapping for Multiple values

Jyoti1
Regular Contributor
Regular Contributor

Hi Team

 

We want to map entitlements to accounts and entitlements are stored as comma separated values.

 

Postman response-

Jyoti1_0-1698308689269.png

 "dataSecurityGroupName""CLS Company Code - Belgium,CLS Company Code - France",
 
 
How to map this in account ent importjson
 

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty2",
"activeStatus": [
"true"
],
"deleteLinks": false,
"accountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://removed.com/api/iam/v1/users/allusers/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json",
"startRecord": "0"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "userName~#~char",
"name": "userName~#~char",
"customproperty1": "email~#~char",
"status": "active~#~char",
"customproperty2": "active~#~char",
"customproperty3": "firstName~#~char",
"customproperty4": "lastName~#~char",
"customproperty5": "securityRole~#~char",
"customproperty6": "functionalRole~#~char",
"customproperty7": "defaultMenu~#~char",
"customproperty8": "loginType~#~char",
"customproperty9": "lastLoggedTime~#~char",
"customproperty10": "dataSecurityGroupName~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"offset": {
"batchSize": 500,
"totalCountPath": "headers.x-totalCount"
}
}
}
},
"acctEntMappings": {
"FunctionalRole": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "functionalRole",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "entitlementID~#~char",
"entitlement_value": "entitlementID~#~char"
}
},
"SecurityRole": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "securityRole",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "entitlementID~#~char",
"entitlement_value": "entitlementID~#~char"
}
},
"dataSecurityGroups": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "dataSecurityGroupName",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "entitlementID~#~char",
"entitlement_value": "entitlementID~#~char"
}
}
}
},

"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"FunctionalRole": {
"entTypeOrder": 0,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://removed.com/api/iam/v1/users/roles/functional/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "roles",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "shortName~#~char",
"entitlement_value": "shortName~#~char",
"description ": "longName~#~char",
"customproperty2": "longName~#~char",
"customproperty3": "createUser:~#~char",
"customproperty4": "createTime:~#~date",
"customproperty5": "index~#~char"
},
"pagination": {
"offset": {
"offsetParam": "startRecord",
"batchParam": "limit",
"batchSize": 500,
"totalCountPath": "x-totalcount"
}
},
"disableDeletedEntitlements": true
}
}
},
"SecurityRole": {
"entTypeOrder": 1,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://removed.com/api/iam/v1/users/roles/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "roles",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "shortName~#~char",
"entitlement_value": "shortName~#~char",
"description ": "longName~#~char",
"customproperty2": "longName~#~char",
"customproperty3": "createUser:~#~char",
"customproperty4": "createTime:~#~date",
"customproperty5": "index~#~char",
"customproperty6": "defaultMenu~#~char"
},
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "limit",
"batchSize": 500,
"totalCountPath": "x-totalCount"
}
},
"disableDeletedEntitlements": true
}
}
},
"dataSecurityGroups": {
"entTypeOrder": 2,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://removed.com/api/iam/v1/users/dsgroups/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "dataSecurityGroups",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "groupName~#~char",
"entitlement_value": "groupName~#~char",
"description ": "groupName~#~char",
"customproperty5": "index~#~char"
},
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "limit",
"batchSize": 500,
"totalCountPath": "x-totalCount"
}
},
"disableDeletedEntitlements": true
}
}
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}

[This message has been edited by moderator to mask url]

7 REPLIES 7

SumathiSomala
All-Star
All-Star

@Jyoti1 refer the below forum links

Solved: Re: Rest Connection : Import accounts and entitlem... - Saviynt Forums - 8490

Solved: Account Entitlement Mapping for REST Connector - Saviynt Forums - 54968

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Jyoti1
Regular Contributor
Regular Contributor

Thanks for sharing this but this is not working.

Jyoti1
Regular Contributor
Regular Contributor

i am getting values in cp31 but mapping is not working

{"SecurityRole":{"entIds":["Trade Spend/Sales"],"keyField":"entitlementID"},"dataSecurityGroups":{"entIds":["CLS Email Inbox - UK,CLS Email Inbox - France,CLS Email Inbox - Germany,CLS Email Inbox - Belgium"],"keyField":"entitlementID"},"FunctionalRole":{"entIds":["DMS Manager - Collections + Deductions"],"keyField":"entitlementID"}}

Jyoti1
Regular Contributor
Regular Contributor

Hi Team 

can some one help on this

Dhruv_S
Saviynt Employee
Saviynt Employee

Hi @Jyoti1 

We are looking into this and will keep you posted.

Regards,

Dhruv Sharma

Jyoti1
Regular Contributor
Regular Contributor

Thank you Dhruv. Please let me know if you know this

Dhruv_S
Saviynt Employee
Saviynt Employee

Hi @Jyoti1 

Comma separated strings in entitlements are not supported by Saviynt.

Regards,

Dhruv Sharma