For the alerting to work, the data returned by the data source needs to be in certain alert compliant format / grafana data frame format. Learn more about that here
In infinity case, we don’t have option anything other than backend parser for this data to be alert compatiable. Here is the sample alert setup with the data you provided. I am using JSONata expression $sort($,function($l,$r) {$l.timestamp > $r.timestamp }) to sort the results by timestamp so that the result will be compatiable with the data frame format.
