Account Import JSON configuration for array response from target application

[Karankumar]

I am trying to create account import json :

Here is my response:

{

    "result": {

        "count": 2.0,

        "records": [

            {

                "id": "05c0b15597d93150fac91b34a253af6d",

                "display_name": "A Tester User(AB84403)",

                "user_name": "AB84403",

                "email": "Test.user1@test.com"

            },

            {

                "id": "40c68c141b2ca410b309ea807e4bcbbb",

                "display_name": "Test User2(AB75890)",

                "user_name": "AB75890",

                "email": "test.user2@test.com"

            }

     ]

    }

}

What should be the values of the below fields:

"listField":"result.records[]",
"keyField":"accountID",
"colsToPropsMap": {
"accountID":"id~#~char",
"customproperty1":"display_name~#~char",
"name":"user_name~#~char",
"customproperty2":"email~#~char",
"status":"active~#~char"

Job is getting completed but correlation is not working. 

Max-Age=1800; Expires=Wed, 11-Oct-2023 23:57:06 GMT; Path=/; HttpOnly; secure; SameSite=None], statusCode:200]"
"2023-10-11T23:27:06.905+00:00","ecm-worker","rest.RestUtilService","quartzScheduler_Worker-6","DEBUG","pullObjectsByRest - responseStatusCode ::200"
"2023-10-11T23:27:06.906+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6","DEBUG","Entered getResponseHeaders method"
"2023-10-11T23:27:06.906+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6","DEBUG","responseError : null"
"2023-10-11T23:27:06.906+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6","DEBUG","isAuthError: false"
"2023-10-11T23:27:06.906+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6","DEBUG","pullObjectsByRest - responseMap.size : 1"
"2023-10-11T23:27:06.906+00:00","ecm-worker","rest.RestUtilService","quartzScheduler_Worker-6","DEBUG","Exception in RestUtil.getAt : java.lang.ArrayIndexOutOfBoundsException"
"2023-10-11T23:27:06.906+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6","DEBUG","pullObjectsByRest - objectList.size : null"

[This message has been edited by moderator to mask email domain]

[stalluri]

Check the correlation rule at the endpoint level.
If there is no correlation rule set, the account will not be linked.

Or

[Karankumar]

Co-relation rule is already setup in our environment.

[Saathvik]

@Karankumar : Changing below mapping and see if that works

"listField":"result.records[]",

to 

"listField":"result.records",

[Karankumar]

yes that worked but am seeing issue in the below mapping which maps accounts and entitlements.

Can you  help me with the mapping:

{
"result": {
"count": 1.0,
"records": [
{
"members": [
{
"display_name": "test test (TS57947)",
"user_name": "TST57947",
"email": "test.test1@<HOSTNAME>.com",
"id": "a09c00ec1b693380b309ea807e4bcbf3"
},
{
"display_name": "test test (TS49471)",
"user_name": "TST49471",
"email": "test.test2@<HOSTNAME>.com",
"id": "af7cc4ac1b693380b309ea807e4bcb4a"
},
{
"display_name": "test test (TS64496)",
"user_name": "TST64496",
"email": "test.test3@<HOSTNAME>.com",
"id": "dcbcccec1b693380b309ea807e4bcb2b"
}
],
"member_count": 3.0,
"id": "3b785b771b68f4500262a648624bcb86",
"name": " ProSurvtest Approvers",
"description": "",
"manager": {
"display_name": "test test (TS49471)",
"user_name": "TST49471",
"email": "test.test4@<HOSTNAME>.com"
}
}
}

[Saathvik]

@Karankumar : What is the JSON you have used for respective block?