I want to update our database any time a messageStatus changes to "DeliveryFailed". The message_store event sends a notification anytime a message is updated, but it does not include any message IDs to fetch the messageStatus.
I know I can fetch the message list and cycle through results to update the status, but this seems inefficient since there is no way of filtering on messageStatus.
Is there a subscription or event that will send a notification with message ID any time delivery fails? If not, what would be the most efficient way to update messages that failed delivery?