REST Application Entitlement Recon with Comma Separated response

[ShantanuKumar]

Hello,

We're currently working on importing entitlements as comma-separated values into entitlements using the REST Application with below response:

{

 "userlist": [

    {

     "groups": [

       "app-users",

       "admin"

      ],

     "name": "123456789"

    },

    {

     "groups": [

       "app-users"

      ],

     "name": "123456789"

    }

  ]

}

Could you please provide guidance on how to proceed with this? Are there any specific formatting requirements or limitations we should be aware of? Any insights or troubleshooting steps would be greatly appreciated.

Thanks,
Karan Chheda

[NM]

Hi @ShantanuKumar , 

Is this the response from get all user call?

[ShantanuKumar]

Yes.

[NM]

@ShantanuKumar , 

Use 

"CUSTOMPROPERTY31": "STORE#ACC#ENT#MAPPINGINFO~#~char" in accountparam

That will solve will your issue.

[ShantanuKumar]

I will ask my team to try it. I saw some articles that if the entitlement values are coming as comma separated then it won't work.

[rushikeshvartak]

Use below code to resolve your issue

"customproperty31": "#CONST#${String output1=response.userlist.groups.replaceAll(', ','\",\"'); beg= ' {\"Group\":{\"entIds\":[\"'; end= '\"],\"keyField\":\"entitlementID\"}}' ; output2= beg.concat(output1) ; finoutput= output2.concat(end) ; return finoutput}~#~char".

[ShantanuKumar]

Hello Rushikesh,

I tried and getting CP31 of account as below screenshot.

ImportAccEntJSON:
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountsNotInImportAction": "Suspend",
"inactivateAccountsNotInFile": false,
"accountThresholdValue": 10000
},
"includeExistingInActiveAccounts":"true",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://####/getAllUsersWithGroups",
"httpHeaders": {
"Authorization": "${access_token}",
"Content-Type": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "userlist",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "name~#~char",
"name": "name~#~char",
"customproperty31": "#CONST#${String output1=response.userlist.groups.replaceAll(', ','\",\"'); beg= ' {\"Group\":{\"entIds\":[\"'; end= '\"],\"keyField\":\"entitlementID\"}}' ; output2= beg.concat(output1) ; finoutput= output2.concat(end) ; return finoutput}~#~char"
},
"makeProcessingStatus": false,
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
}
},
"entitlementParams": {},
"acctEntParams": {}
}

[rushikeshvartak]

Print response.userlist.groups in another custom property and see what data is coming 

[ShantanuKumar]

Below you can check the cp51 and cp31:

[rushikeshvartak]

"customproperty31": "#CONST#${String output1=response.userlist.groups.replaceAll('[\\[\\]]', '').replaceAll(', ', '\",\"'); beg= '{\"Group\":{\"entIds\":[\"'; end= '\"],\"keyField\":\"entitlementID\"}}'; output2= beg.concat(output1); finoutput= output2.concat(end); return finoutput}~#~char"

[ShantanuKumar]

Still the same please check below screenshot:

[rushikeshvartak]

In CP51 use replace ALL with const and remove [ /]

[ShantanuKumar]

Could you please give an example or provide the code as I am not able to modify it.

[ShantanuKumar]

Rishikesh, I am not able to understand the statement you made. Could you please explain or share the expression?

[rushikeshvartak]

"customproperty51": "#CONST#${String output1=response.userlist.groups.replaceAll('[\\[\\]]', '').replaceAll(', ','\",\"'); return output1}~#~char"

[ShantanuKumar]

Hello Rushikesh,

Please check below screenshot still the groups are not selected as entitlement.