12-26-2019 10:46 PM
Hi Team,
I have an input json in linkedHashMap in below format:
[
{
“Path”: “/OrgName/shared”,
“subject_type”: [
“GROUP”,
“GROUP”,
“GROUP”,
“USER”
],
“subject”: [
“Operations”,
“admins”,
“Architects”,
“xyz@xyz.com”
],
“perms”: [
[
“R”,
“X”,
“W”
],
[
“R”,
“X”
],
[
“R”,
“X”
],
[
“R”,
“X”
]
]
},
{
“Path”: “/OrgName/shared2”,
“subject_type”: [
“GROUP”,
“GROUP”,
“GROUP”,
“USER”
],
“subject”: [
“Operations”,
“admins”,
“Architects”,
“abc@abc.com”
],
“perms”: [
[
“R”,
“X”,
“W”
],
[
“R”,
“X”
],
[
“R”,
“X”
],
[
“R”,
“X”
]
]
}
]
My requirement is to map the respective fields and need them in a file as below:
{
{ “Path”: “/OrgName/shared”,
“subject_type”:“GROUP”,
“subject”:“Operations”
“perms”: [
“R”,
“X”,
“W”
]
},
{ “Path”: “/OrgName/shared”,
“subject_type”:“GROUP”,
“subject”:“admins”
“perms”:
[
“R”,
“X”
]
},
{ "Path": "/OrgName/shared",
"subject_type":"GROUP",
"subject":"Architects"
"perms":
[
"R",
"X"
]
},
{ "Path": "/OrgName/shared",
"subject_type":"user",
"subject":"xyz@xyz.com"
"perms":
[
"R",
"X"
]
}
}
can it be achieved using any inbuilt snaps or should we go for a script? Any script snippets is appreciated.
Regards,
Satya
Solved! Go to Solution.
12-31-2019 02:14 AM
Hi Satya,
Please find the attached pipeline for the solution.
Regards,
Anil
12-27-2019 07:01 AM
Please take a look at the sl.zip function.
01-06-2020 03:30 AM
Many thanks for the reply. This resolved my issue.
12-31-2019 02:14 AM
Hi Satya,
Please find the attached pipeline for the solution.
Regards,
Anil
01-06-2020 03:31 AM
Hello Anil,
The pipeline exactly matches my requirement. Thank you for your time on this.
Regards,
Satya