I need to iterate this array and extract all values of name and confidence to check for certain conditions. Unable to extract it properly. Tried using split and trim among many other things. could someone suggest how to extract each object one by one and do the necessary checks and computations on the same.
This will process your JSON array to table in Splunk which will be easy to process later on. If you have all of your events in one single event as JSON array then I would recommend splitting it into one single JSON object and ingest. Because parsing at search will reduce the performance of your search.