I am trying to create a table whereby two of the values are within a JSON array. The data in each array entry is based on the "type" field. I can't seem to figure out how to extract the proper json using json_extract or spath, so I assume I'm going in the wrong direction. Any help would be appreciated. I can't figure out how to say 'Extract the value from displayName for the array entry where a specific key/value pair match my criteria' Any help is appreciated. Example Data {
"actor": {
"type": "User",
"alternateId": "john.smith@example.com"
},
"target": [
{
"type": "User",
"alternateId": "jane.doe@example.com",
"displayName": "Doe, Jane",
"detailEntry": null
},
{
"type": "UserGroup",
"alternateId": "unknown",
"displayName": "Good Employees",
"detailEntry": null
}
],
"uuid":"58dd3885-0c4a-11ee-9843-938af4d00f2c"
} Preferred Output Actor Group User john.smith@example.com Good Employees jane.doe@example.com
... View more
