Rest Connection - Use concatination in import account JSON

[prachi]

Hi,

I am trying to import the data and i am getting the entitlement in the below format.
{
"items": [
{
"product": {
"id": "A",
"name": "Account"
},
"role": {
"id": 1,
"name": "Preparer"
}
}
]
}

I have to import this as one entitlement in Saviynt for Role-Product combination. As :

{
Entitlement Value : "Preparer-Account",
Entitlement_ID : "1-A"
}

I am trying to use the below mapping but it is not working, could you pls suggest on what could be the correct format to store in the entitlement in combination.
1. "colsToPropsMap":{
"entitlementID":"${concat(role.id,'-',product.id)}~#~char",
"entitlement_value":"${concat(role.name,'-',product.name)}~#~char"
}
2. concat(role.name+'-'+product.name)
3. ${concat(role.name+'|'+product.name)}

[prachi]

I also tried using the values like below, it is also creating the entitlement value with what i specify after #CONST#

"colsToPropsMap":{
"entitlementID":"#CONST#${String data1 = response.role.id; String data2 = response.product.id; ret = data1 + \"-\" + data2; return ret}~#~char",
"entitlement_value":"#CONST#${String data1 = response.role.name; String data2 = response.product.name; ret = data1 + \"-\" + data2; return ret}~#~char"

}

[rushikeshvartak]

https://forums.saviynt.com/t5/identity-governance/rest-string-functions/m-p/9161#M1562

[rushikeshvartak]

"listField":"",
"keyField":"entitlementID",
"colsToPropsMap":{
"entitlementID":"#CONST#${String data1 = response.role.id; String data2 = response.product.id; ret = data1 + \"-\" + data2; return ret}~#~char",
"entitlement_value":"#CONST#${String data1 = response.role.name; String data2 = response.product.name; ret = data1 + \"-\" + data2; return ret}~#~char"
}

[prachi]

The API looks like this :

In the JSON i have :

"listField":"items",
"keyField":"entitlementID",
"colsToPropsMap":{
"entitlementID":"#CONST#${String data1 = response.role.id; String data2 = response.product.id; ret = data1 + \"-\" + data2; return ret}~#~char",
"entitlement_value":"#CONST#${String data1 = response.role.name; String data2 = response.product.name; ret = data1 + \"-\" + data2; return ret}~#~char"
}

[IAM_99]

Hi , Is this resolved ?