I know reduce is the function I need to use but I don't know how to start. Maybe there is a more straightforward manner to achieve what I want? I want to group questions with "processUrlID" and with the same sectionID. How can I manipulate this object to create a new object?
[
{
"processUrlID": "9a0e6b48-4019-46ff-9513-eff55c8a0716",
"processParent": "84050058-534d-4e60-92e6-95315786e360",
"questions": [
{
"processTitle": "sdqf",
"DATAINS_TXTSIN_checklistSection": "Section 1",
"DATAINS_TXTSIN_checklistSectionID": "2d9c7bc3-c6f7-4204-a174-1fad80f206a7",
"processUrlID": "da65e3aa-def0-4b69-bbca-7b0c3fe44572",
"processParent": "9a0e6b48-4019-46ff-9513-eff55c8a0716",
},
{
"processTitle": "qsdf",
"DATAINS_TXTSIN_checklistSection": "Section 1",
"DATAINS_TXTSIN_checklistSectionID": "2d9c7bc3-c6f7-4204-a174-1fad80f206a7",
"processUrlID": "0cca5b1d-d5d8-4d5b-9f4c-9cb6ff92e4c6",
"processParent": "9a0e6b48-4019-46ff-9513-eff55c8a0716",
},
{
"processTitle": "qsdfsf",
"DATAINS_TXTSIN_checklistSection": "Section 1",
"DATAINS_TXTSIN_checklistSectionID": "2d9c7bc3-c6f7-4204-a174-1fad80f206a7",
"processUrlID": "d2e70fc8-990b-4660-9d62-1ca0df0d64d3",
"processParent": "9a0e6b48-4019-46ff-9513-eff55c8a0716",
},
{
"processTitle": "dsezar",
"DATAINS_TXTSIN_checklistSection": "Section 2",
"DATAINS_TXTSIN_checklistSectionID": "a4bbde66-8ba0-4513-a64d-41fc34c7827c",
"processUrlID": "d2e70fc8-990b-4660-9d62-1ca0df0d64d3",
"processParent": "9a0e6b48-4019-46ff-9513-eff55c8a0716",
}
],
"sections": [
{
"processUrlId": "2d9c7bc3-c6f7-4204-a174-1fad80f206a7",
"name": "Section 1",
},
{
"processUrlId": "a4bbde66-8ba0-4513-a64d-41fc34c7827c",
"name": "Section 2",
}
]
}
]
to become this object:
[
{
"section": "Section 1",
"sectionID": "2d9c7bc3-c6f7-4204-a174-1fad80f206a7",
"questions": [
"da65e3aa-def0-4b69-bbca-7b0c3fe44572",
"0cca5b1d-d5d8-4d5b-9f4c-9cb6ff92e4c6",
"d2e70fc8-990b-4660-9d62-1ca0df0d64d3",
]
},
{
"section": "Section 2",
"sectionID": "a4bbde66-8ba0-4513-a64d-41fc34c7827c",
"questions": [
"d2e70fc8-990b-4660-9d62-1ca0df0d64d3"
]
}
]