Filter in the array

[kachanta]

Hello Community,
I have been trying hard to build a logic urgently. I’m requesting SnapLogic expression language experts to assist here.

I have the input data like below and need to get the phone “number” filed validating 3 conditions.

1. Type should be ‘Mobile’ in array “phone”
2. type should be == ‘Voice’ inside the array “utilizationMeanings”
3. endDate field should be null which is inside another array “dates” inside “utilizationMeanings”

To detail: $ phones[ < find type = Mobile >].utilizationMeanings[ < find type= voice >].dates[< find endDate ==null>].number

{
“phone”: [
{
“number”: “123456789”,
“type”: “Mobile”,
“utilizationMeanings”: [
{ “type”: “Voice”,
“dates”: [
{“startDate”: “2023-05-31T12:08:47.503Z”,“endDate”: null }
]
},
{
“type”: “Text”,
“dates”: [
{“startDate”: “2023-05-30T00:00:00”, “endDate”: null }
]
}
]
}
]
}

[PratapKr_Gayen]

Test_Expression_2023_06_26 (1).slp (13.0 KB)
try this pipeline, hope this will help to solve the current issue.