Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/06/2023 01:21 AM
Hi All
I am importing accounts and entitlements are coming as accounts attributes-
I have to associate functionalRole and SecurityRole as entitlement. Is this feasible. I tried this but this is not working
"Functional Roles1": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://test.highradius.com/api/iam/v1/users/allusers/list",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"entKeyField": "customproperty6",
"entIdPath": "id",
"acctKeyField": "accountID"
}
}
}
Solved! Go to Solution.
07/06/2023 01:50 AM
Yes, you need to acctToEntMapping as processing types. The https://docs.saviyntcloud.com/bundle/REST-v55x/page/Content/Developers-Handbook.htm will help you.
07/06/2023 05:17 AM
I checked here but it is not working.
07/06/2023 08:05 AM
Can you please share the ImportJSON?
07/06/2023 09:10 AM
{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty2",
"activeStatus": ["true"],
"deleteLinks": false,
"accountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/allusers/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json",
"startRecord": "0"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "userName~#~char",
"name": "userName~#~char",
"customproperty1": "email~#~char",
"status": "active~#~char",
"customproperty2": "active~#~char",
"customproperty3": "firstName~#~char",
"customproperty4": "lastName~#~char",
"customproperty5": "securityRole~#~char",
"customproperty6": "functionalRole~#~char",
"customproperty7": "defaultMenu~#~char",
"customproperty8": "loginType~#~char",
"customproperty9":"lastLoggedTime~#~char"
},
"pagination": {
"offset": {
"batchSize": 500,
"totalCountPath": "headers.x-totalCount"
}
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Functional Roles1": {
"entTypeOrder": 0,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/roles/functional/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "roles",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "shortName~#~char",
"entitlement_value": "shortName~#~char",
"description ": "longName~#~char",
"customproperty2": "longName~#~char",
"customproperty3": "createUser:~#~char",
"customproperty4": "createTime:~#~date",
"customproperty5": "index~#~char"
},
"pagination": {
"offset": {
"offsetParam": "startRecord",
"batchParam": "limit",
"batchSize": 500,
"totalCountPath": "x-totalcount"
}
},
"disableDeletedEntitlements": true
}
}
},
"Security Roles1": {
"entTypeOrder": 1,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/roles/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "roles",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "shortName~#~char",
"entitlement_value": "shortName~#~char",
"description ": "longName~#~char",
"customproperty2": "longName~#~char",
"customproperty3": "createUser:~#~char",
"customproperty4": "createTime:~#~date",
"customproperty5": "index~#~char",
"customproperty6": "defaultMenu~#~char"
},
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "limit",
"batchSize": 500,
"totalCountPath": "x-totalCount"
}
},
"disableDeletedEntitlements": true
}
}
}
}
},
"acctEntParams": {
"connection": "userAuth",
"entTypes": {
"Security Roles1": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/allusers/list",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"entKeyField": "customproperty5",
"entIdPath": "id",
"acctKeyField": "accountID"
}
}
},
"Functional Roles1": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/allusers/list",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"entKeyField": "customproperty6",
"entIdPath": "id",
"acctKeyField": "accountID"
}
}
}
}
}
}
07/10/2023 09:18 AM
Hi sk
can you help on this
07/11/2023 07:16 AM
Please try below once:
{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty2",
"activeStatus": [
"true"
],
"deleteLinks": false,
"accountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/allusers/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json",
"startRecord": "0"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "userName~#~char",
"name": "userName~#~char",
"customproperty1": "email~#~char",
"status": "active~#~char",
"customproperty2": "active~#~char",
"customproperty3": "firstName~#~char",
"customproperty4": "lastName~#~char",
"customproperty5": "securityRole~#~char",
"customproperty6": "functionalRole~#~char",
"customproperty7": "defaultMenu~#~char",
"customproperty8": "loginType~#~char",
"customproperty9": "lastLoggedTime~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"offset": {
"batchSize": 500,
"totalCountPath": "headers.x-totalCount"
}
}
}
},
"acctEntMappings": {
"FunctionalRole": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "functionalRole",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "functionalRole~#~char",
"entitlement_value": "functionalRole~#~char"
}
},
"SecurityRole": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "securityRole",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "securityRole~#~char",
"entitlement_value": "securityRole~#~char"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"FunctionalRole": {
"entTypeOrder": 0
},
"SecurityRole": {
"entTypeOrder": 1
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}
07/12/2023 03:40 AM
Hi Nimit
This is not working-
but i see cp31 like this
{"SecurityRole":{"entIds":["Kraft EU - View Only role"],"keyField":"entitlementID"},"FunctionalRole":{"entIds":["View Only role"],"keyField":"entitlementID"}}
logs-
07/12/2023 05:51 AM
Please check now , a change in acctentmapping
{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty2",
"activeStatus": [
"true"
],
"deleteLinks": false,
"accountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://cloud2-sbox-irapi.highradius.com/api/iam/v1/users/allusers/list",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json",
"startRecord": "0"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "user",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "userName~#~char",
"name": "userName~#~char",
"customproperty1": "email~#~char",
"status": "active~#~char",
"customproperty2": "active~#~char",
"customproperty3": "firstName~#~char",
"customproperty4": "lastName~#~char",
"customproperty5": "securityRole~#~char",
"customproperty6": "functionalRole~#~char",
"customproperty7": "defaultMenu~#~char",
"customproperty8": "loginType~#~char",
"customproperty9": "lastLoggedTime~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"offset": {
"batchSize": 500,
"totalCountPath": "headers.x-totalCount"
}
}
}
},
"acctEntMappings": {
"FunctionalRole": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "functionalRole",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "entitlementID~#~char",
"entitlement_value": "entitlementID~#~char"
}
},
"SecurityRole": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "securityRole",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "entitlementID~#~char",
"entitlement_value": "entitlementID~#~char"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"FunctionalRole": {
"entTypeOrder": 0
},
"SecurityRole": {
"entTypeOrder": 1
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}
07/13/2023 01:51 AM
mapping is not working but cp31 populated {"SecurityRole":{"entIds":["Kraft EU - View Only role"],"keyField":"entitlementID"},"FunctionalRole":{"entIds":["View Only role"],"keyField":"entitlementID"}}
07/13/2023 02:32 AM
Are you also running access import or only account import. CP31 get populated in account import but actual mapping happens while access import and then cp31 data is cleared out.