Hello -
I've used the filter array action with success before but I'm just not able to figure out this one.
I want to filter to just store number 3 and its price records after the Select action.
This does not work.
Any suggestions?
Select action output screen shot and snippet of output text below ...
Snippet of output ...
[
{
"StoreNumber": "1",
"prices": [
{
"storePrice": 3.99,
"quantity": 1,
"startDateTime": "2024-03-18T00:00:00-04:00",
"effectiveDateTime": "2024-03-18T00:00:00-04:00",
"endDateTime": "9999-12-31T23:59:59.9999999+00:00",
"effectiveEndDateTime": "9999-12-31T23:59:59.9999999+00:00"
},
{
"storePrice": 4.49,
"quantity": 1,
"startDateTime": "2023-06-05T00:00:00-04:00",
"effectiveDateTime": "2023-06-05T00:00:00-04:00",
"endDateTime": "2024-03-17T23:59:59.9999999-04:00",
"effectiveEndDateTime": "2024-03-17T23:59:59.9999999-04:00"
}
]
},
{
"StoreNumber": "3",
"prices": [
{
"storePrice": 3.99,
"quantity": 1,
"startDateTime": "2025-03-01T00:00:00-05:00",
"effectiveDateTime": "2025-03-01T00:00:00-05:00",
"endDateTime": "9999-12-31T23:59:59.9999999+00:00",
"effectiveEndDateTime": "9999-12-31T23:59:59.9999999+00:00"
},
{
"storePrice": 3.45,
"quantity": 1,
"startDateTime": "2025-01-01T00:00:00-05:00",
"effectiveDateTime": "2025-01-01T00:00:00-05:00",
"endDateTime": "2025-02-28T23:59:59.9999999-05:00",
"effectiveEndDateTime": "2025-02-28T23:59:59.9999999-05:00"
},
{
"storePrice": 3.99,
"quantity": 1,
"startDateTime": "2024-03-18T00:00:00-04:00",
"effectiveDateTime": "2024-03-18T00:00:00-04:00",
"endDateTime": "2024-12-31T23:59:59.9999999-05:00",
"effectiveEndDateTime": "2024-12-31T23:59:59.9999999-05:00"
},
{
"storePrice": 4.49,
"quantity": 1,
"startDateTime": "2023-06-05T00:00:00-04:00",
"effectiveDateTime": "2023-06-05T00:00:00-04:00",
"endDateTime": "2024-03-17T23:59:59.9999999-04:00",
"effectiveEndDateTime": "2024-03-17T23:59:59.9999999-04:00"
}
]
},
{
"StoreNumber": "4",
"prices": [
{
"storePrice": 3.99,
"quantity": 1,
"startDateTime": "2024-03-18T00:00:00-04:00",
"effectiveDateTime": "2024-03-18T00:00:00-04:00",
"endDateTime": "9999-12-31T23:59:59.9999999+00:00",
"effectiveEndDateTime": "9999-12-31T23:59:59.9999999+00:00"
},
{
"storePrice": 4.49,
"quantity": 1,
"startDateTime": "2023-06-05T00:00:00-04:00",
"effectiveDateTime": "2023-06-05T00:00:00-04:00",
"endDateTime": "2024-03-17T23:59:59.9999999-04:00",
"effectiveEndDateTime": "2024-03-17T23:59:59.9999999-04:00"
}
]
},
Thanks!