Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/17/2024 06:19 AM
I am trying to import Accounts from SAP Concur. i am using the below importAccount JSON.
The job is running but its not able to change the status of accounts. There are already 90k records for SAP concur but with "suspended from import service" status.
i am using the JSON below.
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn":"Status",
"activeStatus": [
"true"
],
"accountsNotInImportAction": "Suspend",
"accountThresholdValue": 100000,
"deleteLinks": true,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xyz/v4/users/",
"httpContentType": "application/json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json" }
},
"listField": "Items",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userName~#~char",
"customproperty1": "formatted~#~char",
"customproperty2": "familyName~#~char",
"Status": "active~#~char",
"customproperty3":"active~#~char"
},
"statusConfig": {
"active": "true"},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.NextPage == null?null:response?.completeResponseMap?.NextPage}" }
}
}
}
}
}
in logs i am not getting the error but i could see the below query getting called for activating the accounts.
Has anyone worked on this before ?
06/17/2024 06:40 AM
If accounts are SFIS then new accounts will be created
06/17/2024 06:43 AM - edited 06/18/2024 03:17 AM
Yes, accounts got duplicated again with SFIS status.
I am passing the status column and active status value in the threshold still , accounts are getting imported with SFIS status.
I am not able to understand the error for this. or if i am missing anything.