Need help in ImportAccount JSON REST

Jaya
Regular Contributor
Regular Contributor

Hello,

In REST connector I need some help in account-Ent mapping.

Individually we are able to fetch all the users & entitlements(Roles/groups) present in the application.

Now problem is in mapping correct entitlement value to the user.

I am using below query to fetch all users & Ent.

{"accountParams":
{"connection":"userAuth",
"processingType":"SequentialAndIterative",
"call":{"call1":{"callOrder":1,
"listField":"data",
"keyField":"accountID",
"disableDeletedAccounts":true,
"http":{"url":"https://sandbox.xxx.com/user/users/page?limit=1000",
"httpMethod":"GET",
"httpContentType":"application/json",
"httpHeaders":{"x-api-key":"xxx"}},
"colsToPropsMap":{"accountID":"id~#~char","name":"email~#~char","customproperty1":"first~#~char","customproperty2":"last~#~char"}}}},
"entitlementParams":{
"processingType":"SequentialAndIterative",
"entTypes":{"Usergroups":{"entTypeOrder":1,"call":{"call1":{"callOrder":1,"connection":"userAuth","listField":"data",
"keyField":"entitlementID",
"disableDeletedEntitlements":true,
"http":{"url":"https://sandbox.xxx.com/user/group",
"httpMethod":"GET",
"httpContentType":"application/json",
"httpHeaders":{"x-api-key":"xxx"}},
"colsToPropsMap":{"entitlementID":"id~#~char","entitlement_value":"name~#~char","description":"description~#~char"}}}},
"Roles":{"entTypeOrder":1,"call":{"call1":{"callOrder":1,"connection":"userAuth","listField":"data",
"keyField":"entitlementID",
"disableDeletedEntitlements":true,
"http":{"url":"https://sandbox.xxx.com/user/role",
"httpMethod":"GET",
"httpContentType":"application/json",
"httpHeaders":{"x-api-key":"xxx"}},
"colsToPropsMap":{"entitlementID":"id~#~char","entitlement_value":"name~#~char","description":"description~#~char"}}}}}},
"acctEntParams":{"entTypes":{}}}

We have a different URL to fetch all the groups assigned to a user i.e., https://sandbox.xxx.com/user/group/user/{userid}

Need help to map assigned entitlement values to user account, not sure where to add another call for this, please suggest.

Thanks
Jaya Karothia
1 REPLY 1

nimitdave
Saviynt Employee
Saviynt Employee

Please try with below:

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 1,
"listField": "data",
"keyField": "accountID",
"disableDeletedAccounts": true,
"http": {
"url": "https://sandbox.xxx.com/user/users/page?limit=1000",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"x-api-key": "xxx"
}
},
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "email~#~char",
"customproperty1": "first~#~char",
"customproperty2": "last~#~char"
}
}
}
},
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"Usergroups": {
"entTypeOrder": 1,
"call": {
"call1": {
"callOrder": 1,
"connection": "userAuth",
"listField": "data",
"keyField": "entitlementID",
"disableDeletedEntitlements": true,
"http": {
"url": "https://sandbox.xxx.com/user/group",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"x-api-key": "xxx"
}
},
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"description": "description~#~char",
"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"listField": "",
"idPath": "id",
"keyField": "accountID",
"importAsAccount": false
}
},
"Roles": {
"entTypeOrder": 1,
"call": {
"call1": {
"callOrder": 1,
"connection": "userAuth",
"listField": "data",
"keyField": "entitlementID",
"disableDeletedEntitlements": true,
"http": {
"url": "https://sandbox.xxx.com/user/role",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"x-api-key": "xxx"
}
},
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"description": "description~#~char",
"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"listField": "",
"idPath": "id",
"keyField": "accountID",
"importAsAccount": false
}
}
}
},
"acctEntParams": {
"processingType": "entToAcctMapping"
}
}

Assumptions:

in the entitlement params call for roles and users groups, account identifier in the response is coming as id parameter under data array.

If you still facing issues then please a sample response of data for each url with sensitive data masked.