acctToEntMapping Not Working After Access Import (REST)

[Micky16]

Hi,

I am trying to perform entitlements association but its only getting mapped to 30 accounts in the endpoint... and the rest is unavailable... I have managed to get cp31 mapping but post running access import, not seeing the mapping under "Entitlement Hierarchy" and "Associated Entitlement"...

Example of CP31 data: {"AribaGroupResponsiblePU":{"entIds":["[xxxx|All, xxxx|Default]"],"keyField":"entitlementID"}}

Postman Response

My ImportAccountEntJSON as below, note that im using separate connection for account and entitlements import

{
"accountParams": {
"connection": "userAuth3",
"processingType": "SequentialAndIterative",
"successResponses": {
"statusCode": [200,201,202,203,204,205]
},
"unsuccessResponses": {
"statusCode": [500,403,404,409]
},
"statusAndThresholdConfig": {
"statusColumn":"customproperty1",
"activeStatus":[
"true"
],
"deleteLinks": false,
"accountThresholdValue": 200000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": false
},
"doNotChangeIfFailed": true,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "xxxxx",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "UserID~#~char",
"name": "UserID~#~char",
"displayname": "Name~#~char",
"status": "Active~#~char",
"customproperty1": "Active~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"AribaGroupResponsiblePU": {
"listPath": "AribaGroupResponsiblePU.EntityValue",
"idPath": "",
"keyField": "entitlementID",
"importAsAccount": false
}
}
},
"entitlementParams": {
"connection": "userAuth2",
"processingType": "SequentialAndIterative",
"successResponses": {
"statusCode": [200,201,202,203,204,205]
},
"unsuccessResponses": {
"statusCode": [500,403,404,409]
},
"doNotChangeIfFailed": true,
"entTypes": {
"AribaGroupResponsiblePU": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "xxxxxxxxxxx",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Content-Type": "application/json",
"Accept-Language": "",
"apiKey": "xxxxxx",
"X-Realm": "xxxxx",
"Authorization": "${access_token}"
}
},
"listField": "value",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "UniqueName~#~char",
"entitlement_value": "UniqueName~#~char"
},
"disableDeletedEntitlements": true
}
}
}
}
},
"acctEntParams": {"processingType": "acctToEntMapping"}
}

Job History Result

[rushikeshvartak]

"acctEntMappings": {
"AribaGroupResponsiblePU": {
"listPath": "EntityValue",
"idPath": "",
"keyField": "entitlementID",
"importAsAccount": false
}

[Micky16]

Hi,

Now i am not able to see the cp31 mapping itself after the account & access import

[Micky16]

Hi @rushikeshvartak ,

I have found out the issue, its failing for users with multiple entitlements and suspected my cp31 storage is not correct, shown as below under double array [ ].

{"AribaGroupResponsiblePU":{"entIds":["[Display|xxx, Display|xxx]"],"keyField":"entitlement_value"}}

For the other system, we only have double quotes " ".

{"Groups":{"entIds":["General","maximouser","StartCenter","AdhocReport"],"keyField":"entitlement_value"}}

Can you advise how i can achieve the same result of cp31 mapping based on the postman response below?

        {

            "UserID": "000008",

            "Active": "false",

            "Name": "Fieldglass 56",

            "AribaGroupResponsiblePU": {

                "EntityValue": [

                    "Display|xxx",

                    "Display|xxxx"

                ]

            }

        },

[rushikeshvartak]

what is working acctEntMappings from other connection

[Micky16]

they have this below,

"acctEntMappings": {
"Groups": {
"listPath": "spi:groupuser",
"idPath": "spi:groupname",
"keyField": "entitlement_value"
}
}

and the postman response,

my AribaGroupResponsiblePU is in curly bracket and the values under EntityValue it inside an array, this format is different in the other application as u can see

[Micky16 · Accepted solution]

Hi, this is resolved by implementing below section, whereby i need to look at a single array of response and parse to listPath

"acctEntMappings": {
"AribaGroupResponsiblePU": {
"listPath": "AribaGroupResponsiblePU.EntityValue",
"idPath": "",
"keyField": "entitlement_value"
}
}