How can I extract groupName from groups array based on groupId during account Import?

[alc]

Hello,

We configured an endpoint Import to map customproperty2 to defaultGroupId with response below.

However, I want to show the groupName instead of groupId with customproperty2. Can you provide a script to extract the groupName from groups array based on the defaultGroupId value?

{
"username":"user01"
"defaultgroupId":"id02",
"groups": [
{
"groupName": "ThegroupName3",
"groupId": "id03"
},
{
"groupId": "id02",
"groupName": "ThegroupName2"
},
{
"groupId": "id01",
"groupName": "ThegroupName3"
}
]
}

Thanks

[stalluri]

@alc 
You can refer to this and map the data accordingly.
https://forums.saviynt.com/t5/community-knowledge-base/mapping-data-in-json-based-on-date-type-respo...
Or
We can use enhanced query and update the value.

[rushikeshvartak]

Please share current import json

[alc]

Hello Rushikes,

in our Import JSON, we only have following mappings. what we need to change for customproperty2 is not map to the defaultGroupId but map to the groupName from groups array  based on the defautlGroupId. the response entry is shown as my first post. we cannot find the correct scripting code to get the mapped groupName.

{
"name": "username~#~char",
"customproperty2": "defaultgroupId~#~char",
"accountID": "username~#~char"
}