Rest Connector: Import accounts JSON accounts are not importing

[saurabhpad]

We are implementing Account import for rest connector. Below is the response of API from postman.

This is the JSON which we have configured for account import. But accounts are not imported. We have checked logs and it gives 200 ok response with no errors.

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
"active"
],
"deleteLinks": true,
"accountThresholdValue": 40,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url":"https://removed.service-now.com/api/now/table/sys_user_grmember?sysparm_query=group%3D0b5ec6bd87d229...",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "result.user.email",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "value~#~char",
"name": "display_value~#~char"
}
}
}
}
}

[This message has been edited by moderator to mask PII and url]

[SumathiSomala]

Hi @saurabhpad 

Are you importing accounts or members associated with groups?

If you are importing account, please check the URL used in the JSON.

"url":"https://domain.service-now.com/api/now/table/sys_user?sysparm_query=active=true&sysparm_exclude_reference_link=true&sysparm_display_value=true"

Please check the table name in ServiceNow.