Hello Saviynt Team,
I am using the following ImportAccountEntJSON to import accounts and entitlements. The accounts and entitlements import correctly, but the relationship between them does not. Could you please advise how to import the account-access relationship from an array? Specifically, what should the entIdPath be to correctly obtain the userReferences that are in the array
{
"globalSettings": {
"dateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'"
},
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"listField": "Resources",
"keyField": "accountID",
"http": {
"url": "https://example.com/api/scim/v2/Users",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
}
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
},
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userName~#~char",
"customproperty1": "externalId~#~char",
"customproperty2": "userType~#~char",
"customproperty3": "name.familyName~#~char",
"customproperty4": "name.givenName~#~char",
"customproperty5": "emails[0].value~#~char",
"customproperty6": "phoneNumbers[0].value~#~char"
}
}
}
},
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"UserReference": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"connection": "acctAuth",
"listField": "Resources",
"keyField": "entitlementID",
"http": {
"url": "https://example.com/api/scim/v2/Users?filter=userName%20sw%20%22REF_%22",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
}
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
},
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "userName~#~char",
"displayname": "userName~#~char"
}
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"UserReference": {
"acctKeyField": "accountID",
"entKeyField": "entitlementID",
"call": {
"call1": {
"processingType": "http",
"connection": "acctAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"url": "https://example.com/api/scim/v2/Users",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "Resources",
"acctIdPath": "id",
"entIdPath": "urn:tgk:params:scim:schemas:extension:2.0:User.userReferences",
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
}
}
}
}
}
}
}
JSON Response Example:
{
"schemas": [
"urn:ietf:params:scim:api:messages:2.0:ListResponse"
],
"totalResults": 1,
"Resources": [
{
"schemas": [
"urn:ietf:params:scim:schemas:core:2.0:User",
"urn:tgk:params:scim:schemas:extension:2.0:User"
],
"id": "myuser",
"externalId": "myuser",
"meta": {
"resourceType": "User",
"lastModified": "2024-05-22T19:13:12.593Z"
},
"userName": "myuser",
"userType": "E",
"emails": [
{
"value": "myuser@example.com"
}
],
"partiallyBlocked": false,
"urn:tgk:params:scim:schemas:extension:2.0:User": {
"userReferences": [
"REF_PUBCO"
],
"locked": false,
"mustChangePwdAtNextLogin": false,
"interactionType": "INTERACTIVE"
}
}
],
"startIndex": 0
}
