Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/28/2024 02:54 AM
05/28/2024 03:54 AM
Hi @AtrayeeDutta can you share the sample response?
05/28/2024 11:26 AM
05/28/2024 10:24 PM
06/19/2024 04:38 AM
Hi @rushikeshvartak @naveenss
Please see the attached please see the attached screenshots and the log file. I can see response in Saviynt log is matching with Postman. However at the time of accounts to entitlement mapping entvalkey is null as per log.
Below is the updated JSON.
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
"t"
],
"deleteLinks": true,
"accountThresholdValue": 10000,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://000000000000000/odata/v2/User?$select=userId,firstName,lastName,custom01,status&$filter=stat...",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "d.results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "userId~#~char",
"name": "userId~#~char",
"status": "status~#~char",
"customproperty1": "firstName~#~char",
"customproperty2": "lastName~#~char",
"customproperty3": "custom01~#~char",
"customproperty11": "status~#~char"
}
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"DynamicGroups": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://000000000000000/odata/v2/DynamicGroup",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "d.results",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "groupID~#~char",
"entitlement_value": "groupName~#~char",
"customproperty1": "groupType~#~char",
"customproperty2": "lastModifiedDate~#~char",
"customproperty3": "groupID~#~char"
}
}
}
}
}
},
"acctEntParams": {
"connection": "acctAuth",
"entTypes": {
"DynamicGroups": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"httpHeaders": {
"Authorization": "${access_token}",
"httpContentType": "application/json"
},
"url": "https://000000000000000/odata/v2/getDynamicGroupsByUser?userId='${id}'&groupSubType='permission'",
"httpMethod": "GET"
},
"listField": "d",
"entIdPath": "groupId",
"entKeyField": "entitlementID",
"acctKeyField": "accountID"
}
}
}
}
}
06/19/2024 06:42 AM
Keep listfield blank and try
06/21/2024 01:26 AM
We have now been able to map one account successfully. However, we encountered another issue. When running the access import for all accounts (53k accounts), the job fails after running for 13 hours. Is there a way to resolve this issue? Below is the working JSON.
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
"t"
],
"deleteLinks": true,
"accountThresholdValue": 10000,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xxxxxxxxxxxxxxxxx/odata/v2/User?$select=userId,firstName,lastName,custom01,status&$filter=st...'",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "d.results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "userId~#~char",
"name": "userId~#~char",
"status": "status~#~char",
"customproperty1": "firstName~#~char",
"customproperty2": "lastName~#~char",
"customproperty3": "custom01~#~char",
"customproperty11": "status~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response.completeResponseMap.d.__next}"
}
}
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"DynamicGroups": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xxxxxxxxxxxxxxxxx/odata/v2/DynamicGroup",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "d.results",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "groupID~#~char",
"entitlement_value": "groupName~#~char",
"customproperty1": "groupType~#~char",
"customproperty2": "activeMembershipCount~#~char",
"customproperty3": "groupID~#~char"
}
}
}
}
}
},
"acctEntParams": {
"connection": "acctAuth",
"entTypes": {
"DynamicGroups": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}",
"Accept":"application/json"
},
"url": "https://xxxxxxxxxxxxxxxxx/odata/v2/getDynamicGroupsByUser?userId='${id}'&groupSubType='permission'",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "d",
"entIdPath": "groupId",
"entKeyField": "entitlementID",
"acctKeyField": "accountID"
}
}
}
}
}
}
06/21/2024 07:48 AM
What is error after 13 hours ? Does API does not have pagination.
06/24/2024 02:38 AM
@AtrayeeDutta
Please try with the below URL in the acctEntParams
"url": "https://000000000000000/odata/v2/getDynamicGroupsByUser?userId=%27${id}%27&groupSubType=%27permission%27",