New Relic Alert on CosmosDb Collection

Question

{
"id": "b5cf3d77-a299-47b5-8a94-ceddcba45fcf",
"orderId": "XXXXX",
"versionId": "6",
"eventName": "ORDERED_UNIT_SHIPPED",
"status": "SUCCESS",
"_rid": "xxxxxxxxxxxxx==",
"_self": "xxxxxxxxxxx",
"_etag": "xxxxxxxxxxxxxxxxxx",
"_attachments": "xxxxxx/",
"_ts": xxxxxxxxxx
}

Above is the JSON sample on which I want to create an alert

The alert has to be triggered with the following condition

select count(*) from c where c.status!= SUCCESS and c.Eventname ="ORDERED_UNIT_SHIPPED"

reached a threshold limit.

please let me know whether it is possible or not. if YES please tell me the procedure of it.

Answer 1

• Create LogicApp instance
• Start with Time Trigger
• Run Cosmos DB Api query https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-cosmos-db?tabs=consumption
• Transfrom results to your json schema
• Send it to NewRelic