We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Account Import JSON configuration for array response from target application

Karankumar
New Contributor
New Contributor

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]
5 REPLIES 5

stalluri
Regular Contributor
Regular Contributor

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

stalluri_2-1697073977624.png

 

stalluri_0-1697073891526.png

Or

stalluri_1-1697073932457.png

 

Co-relation rule is already setup in our environment.

@Karankumar : Changing below mapping and see if that works

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

to 

"listField":"result.records",


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Karankumar
New Contributor
New Contributor

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"
}
}
}

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


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.