Webhook notifications to Microsoft Teams? (Currently doesn't seem to work)

mrhcarlin

So on one of my Teams channels I've added an "incoming webhook" connector and put the URL it gave me in SQL Monitor's webhook notifications setting. Now I realise that this feature is in preview, so maybe I just need to wait for it get fixed, but it doesn't work. I ruled out our proxy server being the issue by exposing the SQL Monitor server directly to the Internet, and I'm still getting 400 error codes.

Below is the error from the Base Monitor log whenever I try to send a test notification:

2020-01-28 09:19:35,396 [26] WARN  RedGate.SqlMonitor.Engine.Alerting.Base.Core.Email.WebhookNotificationSender - Error posting webhook notification

System.Net.WebException: The remote server returned an error: (400) Bad Request.

   at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)

   at System.Net.WebClient.UploadString(Uri address, String method, String data)

   at RedGate.SqlMonitor.Engine.Alerting.Base.Core.Email.JsonPoster.PostObject(String url, Object payload)

   at RedGate.SqlMonitor.Engine.Alerting.Base.Core.Email.WebhookNotificationSender.SendNotification(AlertNotification alertNotification)System.Net.WebException: The remote server returned an error: (400) Bad Request.

   at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)

   at System.Net.WebClient.UploadString(Uri address, String method, String data)

   at RedGate.SqlMonitor.Engine.Alerting.Base.Core.Email.JsonPoster.PostObject(String url, Object payload)

   at RedGate.SqlMonitor.Engine.Alerting.Base.Core.Email.WebhookNotificationSender.SendNotification(AlertNotification alertNotification)

I respect that this could also be a Teams issue, but we are actually using webhooks for other applications and they just work.

Is there anything I can do/modify, or will I have to wait for improvements to this feature?

Thanks,

Matt

Russell D

Does passing a webhook to your Teams install require authentication?

mrhcarlin

Russell D said:

Does passing a webhook to your Teams install require authentication?

It does not, which I mainly know from having set up two other incoming webhooks to Teams.

I'm really leaning towards the issue being that Teams can't translate the JSON payload that SQL Monitor sends. Do you know if it's possible to modify the JSON so I can tailor its layout? There's an example in the link below, but I can't find anything like it in installation directory... One of the other two webhooks that I set up required customization of the JSON, so I'm hoping that this is possible with SQL Monitor.

https://documentation.red-gate.com/sm9/configuring-sql-monitor/setting-up-webhook-notifications-preview

Russell D

It's not yet possible I'm afraid. We're hoping to support templating in the near future, so this should be possible but currently your suspicion is correct.

mrhcarlin

Russell D said:

It's not yet possible I'm afraid. We're hoping to support templating in the near future, so this should be possible but currently your suspicion is correct.

Thanks. I'll keep an eye out for it in future releases.

ssh4478

Any further updates on Teams integration. As far I can see its not in preview  anymore but part of product.
I am trying to integrate the web hook with team channels which is kind of working now but stumble upon the fact that we can't have multiple hooks for different channels ?
Also how can we customise the channel based on the severity and type of alerts, is it all possible in line with other same monitoring tools in the market, please suggest?
TIA