I'm having a brain fart and cant quite figure out how to get my Filter Array function to work on this json:
{
"data": [
[
{
"groups": [],
"label": "Raw Signals",
"summary_current_period": 16439,
"summary_previous_period": 31579
},
{
"groups": [],
"label": "Filtered Events",
"summary_current_period": 708,
"summary_previous_period": 839
},
{
"groups": [],
"label": "Security Incidents",
"summary_current_period": 0,
"summary_previous_period": 0
},
{
"groups": [],
"label": "Escalations",
"summary_current_period": 0,
"summary_previous_period": 0
},
{
"groups": [],
"label": "Unusual",
"summary_current_period": 1,
"summary_previous_period": 0
},
{
"groups": [],
"label": "Notifications",
"summary_current_period": 170,
"summary_previous_period": 197
}
]
],
"params": {
"customer_code": "REDACTED",
"end_time": "2022-09-23 23:59:59+00:00",
"format": null,
"report_types": [
"ActivitySummary"
],
"sites": [],
"start_time": "2022-09-17 00:00:00+00:00"
},
"report_id": "REDACTED",
"request_end_time": "2022-09-23T14:37:26.198084+00:00",
"request_start_time": "2022-09-23T14:33:51.152314+00:00",
"status": "ACTIVE"
}
My filter array is where
body('Parse_JSON')?['data']?[0]?[0]?['label'] is equal to Raw Signals, but its not showing me just the raw signals data, its showing me all of those labels. I want to extract the summary_current_period data for each label.
