Duplicate accounts under entitlements

[Aadhithyan]

Hi All,

Working on REST based Workday connector.

Ran the accounts import to pull in the accounts and entitlements which was successful. but association did not happen. So ran the access import and association happened but it created two accounts under each entitlement and both the accounts are active.

also this is the importaccount entitlement json.

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"acctEntMappings": {
"Organization_Roles_group": {
"importAsEntitlement": true,
"listPath": "Organization_Roles_group",
"idPath": "Assignable_Role",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Assignable_Role~#~char",
"entitlement_value": "Assignable_Role~#~char"
}
},
"User-Based_Security_Groups_for_User_group": {
"importAsEntitlement": true,
"listPath": "User-Based_Security_Groups_for_User_group",
"idPath": "User_Based_Security_Group",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "User_Based_Security_Group~#~char",
"entitlement_value": "User_Based_Security_Group~#~char"
}
}
},
"call": {
"call1": {
"callOrder": 0,
"listField": "Report_Entry",
"keyField": "accountID",
"disableDeletedAccounts": false,
"http": {
"url": "",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
}
},
"colsToPropsMap": {
"accountID": "EEID~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char",
"name": "Worker~#~char"
}
}
}
},
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"Organization_Roles_group": {
"entTypeOrder": 1,
"call": {}
},
"User-Based_Security_Groups_for_User_group": {
"entTypeOrder": 1,
"call": {}
}
}
},
"acctEntParams": {
"entTypes": {
"Organization_Roles_group": {
"call": {
"call1": {
"processingType": "acctToEntMapping",
"http": {}
}
}
},
"User-Based_Security_Groups_for_User_group": {
"call": {
"call1": {
"processingType": "acctToEntMapping",
"http": {}
}
}
}
}
}
}

Can someone please help with this issue.

Regards,

Aadhithyan.S

[This post has been edited by a Moderator to merge two posts.]

[rushikeshvartak]

Does  accountid is same for both accounts

[Aadhithyan]

@rushikeshvartak any idea? 

[Aadhithyan]

@rushikeshvartak  Yes both have the same accountID

[rushikeshvartak]

Using enhanced query change status of duplicate accounts