My project is using customer.io to send emails in different flows.
Every now and then we have a bug, and one of those calls stops and email is not sent.
I want to get alerted when an email is not sent in the last 24 hours. It would be great if the solution could give me alert on any spike but the mvp is 0 in the last 24 hours.
What is the best way to do it?
Currently, I am trying to use some process to poll customer.io REST API which provides exactly the information I need.
[{
"campaign": "Hello",
"sent": 0 // This should trigger an alert. sent is for last 24 hours
}, {
"campaign": "World",
"sent": 1 // should not trigger an alert
}]
Then to do some ETL on this, and feed some data source (maybe cloudwatch, haven't decided yet), and then hook grafana to give me alerts on any spikes.
I am new to this field and am wondering if I am going the right way and if there's a better/easier way to tackle the problem.
== Update - I found out about Grafana SimpleJSON plugin but it expects me to be the owner of the backend. I am going to write some lambdas and use gateway (basically implement an ETL) and use SimpleJSON plugin from grafana to get things going.