We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK 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

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

Hi @Jyoti1 

Comma separated strings in entitlements are not supported by Saviynt.

Regards,

Dhruv Sharma