AccountEnt mapping is not happening in Rest Connector

[VijayMaram]

Hi Team,

I am onboarding rest based application, but when running access import mapping, we observe account and entitlement  mapping is not working. Details were as fallow.

Can you please review and suggest any pointers.

Note: JSON foramt is edited since getting validation error.

"acctEntParams": 
"connection": "acctAuth",
"entTypes": {
"Groups": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"showJobHistory": true,
"processingType": "httpEntToAcct",
" {
"url": "https://******/GetGroup?id=${id}",
httpHeaders: {
"Cookie": "${access_token}",
"Content-Type": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"entKeyField": "entitlementID",
"acctIdPath": "Users[[Id]]",
"acctKeyField": "accountID"
}
}
}
}
}

I have tried multiple combinations. But every time getting Accntkey as null.

Group response:

{
"Id": 2,
"Name": "Anonymous Incident Analysts",
"Description": "",
"BusinessUnit": false,
"SecurityRoles": [],
"Users": [
{
"Id": 6,
"FullName": "Admin, Lockpath"
},
{
"Id": 27,
"FullName": "User, Test"
}
],
"ChildGroups": [],
"ParentGroups": []
}

Log:

2024-07-01T14:40:42-05:00-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-5-td4vx-DEBUG-ACCKEY:null;ENTVALKEY:260649

2024-07-01T14:40:42-05:00-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-5-td4vx-DEBUG-Exception in RestUtil.getAt : java.lang.NumberFormatException: For input string: ""

2024-07-01T14:40:42-05:00-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-5-td4vx-DEBUG-inside processAccountEntitlements

2024-07-01T14:40:42-05:00-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-5-td4vx-DEBUG-ACCKEY:null;ENTVALKEY:260618

2024-07-01T14:40:42-05:00-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-5-td4vx-DEBUG-Exception in RestUtil.getAt : java.lang.NumberFormatException: For input string: ""

[prafullgoyal]

Hi @VijayMaram ,

I would appreciate it if you could share the entire "ImportAccountEntJSON" with me.

Thanks 

Prafull,

[NM]

Hi @VijayMaram , can you try this

"acctEntParams": 

"connection": "acctAuth",

"entTypes": {

"Groups": {

"call": {

"call1": {

"callOrder": 0,

"stageNumber": 0,

"showJobHistory": true,

"processingType": "httpEntToAcct",

" {

"url": "https://******/GetGroup?id=${id}",

httpHeaders: {

"Cookie": "${access_token}",

"Content-Type": "application/json"

},

"httpContentType": "application/json",

"httpMethod": "GET"

},

"listField": "Users",

"entKeyField": "entitlementID",

"acctIdPath": "Id",

"acctKeyField": "accountID"

}

}

}

}

}

[VijayMaram]

Hi @NM Yes i have tried this way too getting same error.

@prafullgoyal 

I have attached full JSON.

[prafullgoyal]

Hi @VijayMaram ,

Could you please share the postman's response? The attribute mapping for "listField" and "entitlementMappingJson" has to be put through a validation process.

********/GetUsers

******/SecurityService/GetGroups

********/SecurityService/GetGroup?id=${id}

Thanks 

Prafull, 

[VijayMaram]

Hi @prafullgoyal 

Please below information.

********/GetUsers

F:\>curl -b cookie.txt -H "content-type: application/json" -H "Accept: application/json" -X POST -d @GetUsersInput.json "https://******/SecurityService/GetUsers"
[
{
"Id": 1191,
"FullName": "Abernathy, Stacey",
"Username": "s96565g",
"Active": true,
"Deleted": false,
"AccountType": 1
},
{
"Id": 973,
"FullName": "Anderson, Anna",
"Username": "a72962a",
"Active": true,
"Deleted": false,
"AccountType": 1
},
{
"Id": 18647,
"FullName": "Capuano, Josef",
"Username": "j17218c",
"Active": true,
"Deleted": false,
"AccountType": 1
},
{
"Id": 3186,
"FullName": "Christensen, Eric",
"Username": "e68480c",
"Active": true,
"Deleted": false,
"AccountType": 1
},

******/SecurityService/GetGroups

F:\>curl -b cookie.txt -H "content-type: application/json" -H "Accept: application/json" -X POST -d @GetGroups.json https:********/SecurityService/GetGroups
[
{
"Id": 931,
"Name": "Administration Platform Support"
},
{
"Id": 943,
"Name": "AM BC Compliance Administrator"
}
]

*******/SecurityService/GetGroup?id=${id}

F:\>curl -b cookie.txt -H "content-type: application/json" -H "Accept: application/json" https://********/SecurityService/GetGroup?id=761
{
"Id": 761,
"Name": "AM External Audit Evidence Responders",
"Description": "Membership of this group required approval from April Vroom A92582V, Jessie Williams M16524W or Stephanne Payne S68507P. Audit Manager (AM) External Audit Evidence Responders..",
"BusinessUnit": false,
"LDAPDirectory": {
"Id": 3,
"DisplayName": "RemoteDirectorySync_Sandbox"
},
"LDAPGroupName": "KL_AMExtAudEvdcRsp_P",
"LDAPGroupDN": "CN=KL_AMExtAudEvdcRsp_P,OU=Keylight Groups,OU=BCBST Groups,DC=bcbst,DC=com",
"SecurityRoles": [
{
"Id": 87,
"Name": "AM_Ext_Audit_Evidence_Responders "
}
],
"Users": [
{
"Id": 14,
"FullName": "Keith, Ted"
},
{
"Id": 15,
"FullName": "Marter, Lisa"
},
{
"Id": 18,
"FullName": "Clark, Carl"
},
{
"Id": 21,
"FullName": "Campbell, Charles"
},

[prafullgoyal]

Please try the JSON file I've attached and let me know.

Thanks 

Prafull,

[NM]

@VijayMaram do you see entitlement getting imported and entitlement ID populated with ID of applications end?

[VijayMaram]

Hi @NM  Yes, entitlement ID getting populated .

[NM]

@VijayMaram share logs when you trigger job

[VijayMaram]

@NM 

Files were not getting uploaded. 

[VijayMaram]

Able to upload partial information from Logs.

@NM