Filter in the array
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.
- Type should be ‘Mobile’ in array “phone”
- type should be == ‘Voice’ inside the array “utilizationMeanings”
- 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 }
]
}
]
}
]
}
