Forum Discussion
j_angelevski
5 years agoContributor III
Hi @arunnp ,
This can be done with the following steps:
-
Add JSON Splitter after the input json and split on
$result
-
Add a mapper to map the corresponding values ( you can easily map the values now since they are no longer in an array )
-
And finally add a Group by N snap to group every object into a single array.
Result:
{
"result": [
{
"ticketNumber": "INC0029337",
"description": "test",
"sys_id": "90a4a74e1be97010ef9f6208b04bcb96",
"comments": "thh lafldsf. legmsfd",
"status": "In Progress",
"lastUpdateTime": "2021-07-26 10:53:28"
},
{
"ticketNumber": "INC0029337",
"description": "test",
"sys_id": "90a4a74e1be97010ef9f6208b04bcb96",
"comments": "thh lafldsf. legmsfd",
"status": "In Progress",
"lastUpdateTime": "2021-07-26 10:53:28"
}
]
}
]