Servicenow accounts status comes as Suspended from Import service

[hirenp]

Hi,

We are reconciling accounts from service now however all the accounts come into EIC as suspended from import service. Below is the ImportAccountEntJSON json. Additionally our version has STATUS_THRESHOLD_CONFIG attribute which is currently empty

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 50,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"statusColumn":"customproperty50",
"activeStatus": [
"true"
]
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://<domainname>/api/now/table/sys_user?sysparm_limit=100&active=true",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"statusConfig": {
"active": "true",
"inactive": "false"
},
"listField": "result",
"keyField": "accountID",
"colsToPropsMap": {
"ACCOUNTTYPE": "u_qc_employee_type~#~char",
"name": "user_name~#~char",
"CUSTOMPROPERTY50": "u_user_status~#~char",
"status": "active~#~char",
"accountID": "sys_id~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.split(';')?.size()==5?headers?.Link?.split(';')[2]?.replace('rel=\"prev\",<', '')?.replace('>','')?.trim():headers?.Link?.split(';')?.size()==4 && headers?.Link?.split(';')[2].contains('rel=\"next\",<')?headers?.Link?.split(';')[1]?.replace('rel=\"first\",<', '')?.replace('>','')?.trim():null}"
}
}
}
}
}
}

[rushikeshvartak]

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 50,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://<domainname>/api/now/table/sys_user?sysparm_limit=100&active=true",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"statusConfig": {
"active": "true",
"inactive": "false"
},
"listField": "result",
"keyField": "accountID",
"colsToPropsMap": {
"ACCOUNTTYPE": "u_qc_employee_type~#~char",
"name": "user_name~#~char",
"CUSTOMPROPERTY50": "u_user_status~#~char",
"status": "active~#~char",
"accountID": "sys_id~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.split(';')?.size()==5?headers?.Link?.split(';')[2]?.replace('rel=\"prev\",<', '')?.replace('>','')?.trim():headers?.Link?.split(';')?.size()==4 && headers?.Link?.split(';')[2].contains('rel=\"next\",<')?headers?.Link?.split(';')[1]?.replace('rel=\"first\",<', '')?.replace('>','')?.trim():null}"
}
}
}
}
}
}

[hirenp]

@rushikeshvartak 

I think you want to use out of the box status column. I have tried that and it still does not work.

[rushikeshvartak]

Its working in my case please share logs