\nCopy the Bin URL. You will need this in a minute.
\nOpen OMS<\/a> and head to the alert you want to make awesome (Overview – Settings – Alerts).
\nTurn on the Webhook action, and paste the Requestb.in url into the “WebHook URL” field.
\nCheck the box to turn on the “Include Custon JSON Payload”. Paste this json into the field below the checkbox:<\/p>\n
{“AlertRuleName”:”#alertrulename”,
\n“AlertThresholdOperator”:”#thresholdoperator”,
\n“AlertThresholdValue”:”#thresholdvalue”,
\n“LinkToSearchResults”:”#linktosearchresults”,
\n“ResultCount”:”#searchresultcount”,
\n“SearchIntervalEndtimeUtc”:”#searchintervalendtimeutc”,
\n“SearchIntervalInSeconds”:”#searchinterval”,
\n“SearchIntervalStartTimeUtc”:”#searchintervalstarttimeutc”,
\n“searchquery”:”#searchquery”,
\n“workspace”:”#workspaceid”,
\n“IncludeSearchResults”:true
\n}<\/p>\n
Note: You might want to remove the “searchquery” json pair – the alert queries that have special characters can really cause havoc with the webhook.
\nHit “Test WebHook”. If you get an error, remove the searchquery section out of the json and try again. If it occurs again, shoot me an email and I will be glad to help.
\nGo back to RequestB.in and refresh your page. You should see something like this:
\n![\"\"](\"http:\/\/draith.com\/wp-content\/uploads\/2017\/05\/Requestbin.png\")
<\/p>\n
Copy out the “Raw Body” section. Once you have the alerts coming to Flow, the possibilities are endless – want to see those Alerts on your phone? Get PowerApps and in 5 minutes you can point it at the SQL database you are using to store the alerts. Want a mobile notification? Piece of cake with Flow. Hell, maybe you want to Tweet those alerts for some reason – Go for it! I won’t tell you not to.<\/p>\n","protected":false},"excerpt":{"rendered":" The alert actions in Microsoft OMS are great, but they can be a bit limited. Sending emails can be boring, ignored, or end up in the spam folder. Runbooks are awesome, but can take some time to setup. What if you want to use a simple Microsoft Flow to perform other actions? Flow is fast, … Continue reading “OMS and Flow Integration – Best Friends Forever”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[8,14],"class_list":["post-194","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-flow","tag-oms"],"_links":{"self":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts\/194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=194"}],"version-history":[{"count":0,"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts\/194\/revisions"}],"wp:attachment":[{"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nOpen Flow<\/a>, and create a new Flow (My Flows, Create from Blank)
\nFor the Trigger – pick “Request\/Response – Request”. When you click on the trigger, it will open the Flow for editing.
\nClick on “Use sample payload to generate schema”, and paste in the data you got from RequestB.in. Click “Done”. Flow has now setup of the JSON schema that the rest of your Flow will use.
\nAdd another other Flow action like you normally would – For example, you might want to add these alerts to a Sharepoint list, or perhaps put them in a SQL database for archiving. The fields that are available to the actions that follow the Request trigger depend on the fields that were sent by the alert – I suggest that you play around with Threshold vs Metric alerts so you can see how they post to Flow.
\nOne last step – when you save the Flow, make sure you go into the “Request” trigger and copy the URL. You will want to paste that url in the OMS alert Webhook URL (remove the requestb.in url). Now, when the alert triggers, it will pass the data to Flow rather than RequestB.in.<\/p>\n