Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Rest Connector: Import accounts JSON accounts are not importing

saurabhpad
New Contributor II
New Contributor II

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

saurabhpad_0-1695282685400.png

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]

1 REPLY 1

SumathiSomala
All-Star
All-Star

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.

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.