User Import from REST Endpoint

[IAMDeveloper11]

We have a REST endpoint returning user data in JSON format. We are trying to import that to EIC, and have configured below steps:

1.  Configured the Security System, Endpoint, and Connection.
2. Configured the ConnectionJSON and UserImportJSON with a successful test connection. The ImportUserJSON configuration is below.

On running the User Import Job, there are no users imported and the log shows no data picked. I couldn't find any documentation that would help with this configuration- it's clear that we're missing something, so any pointers to check this are appreciated! 

{
"connection": "userAuth",
"successResponses": {
"statusCode": [
200,
201,
202,
203,
204,
205
]
},
"url": "RemovedForPrivacy",
"httpMethod": "GET",
"httpHeaders": {},
"properties": {
"userName":"Test",
"password":"Test"
},
"userResponsePath": "users",
"colsToPropsMap": {
"username": "EmployeeID~#~char",
"systemUserName": "EmployeeID~#~char",
"firstname": "PrimFirstName~#~char",
"lastname": "PrimLastName~#~char",
"email": "email~#~char"
}
}

[SB]

We  can try the below and see if it helps

1. Run the call in Postman to see if it is returning the data.

2. Use an online tool like https://jsonpath.com to check if the path defined for user response is correct.

3. update ConfigJSON param in the REST connection with value {"showLogs":true} and this should print additional logs to help identify the cause.