MS Teams and Webhooks

Baserow Help
1

Hi,
Has anyone managed to configure a webhook for Microsoft Teams ?

On Teams side the connector is created and I created the URL.

image
image876×166 15.7 KB

I have configured the webhook on baserow

image
image629×714 43.5 KB

This is the response that I get :
400 NOT OK, Summary or Text is required
image

1 Like
2

Hi @Nicolas, I don’t have any experience with Microsoft Teams. Judging by this answer on Stack Overflow json - Microsoft Teams Webhook Generating 400 for Adaptive Card - Stack Overflow, it seems like the API call payload body is wrong. Apparently, Teams wants to receive the payload in the following format:

{
"type": "message",
"attachments": [
    {
        "contentType": "application/vnd.microsoft.card.adaptive",
        "contentUrl": null,
        "content": {
            "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
            "type": "AdaptiveCard",
            "version": "1.4",
            "body": [
                
            ]
        }
    }
]}

The downside is that Baserow can only provide a payload that looks like this:

{
    "table_id": 0,
    "event_type": "rows.updated",
    "event_id": "00000000-0000-0000-0000-000000000000",
    "items": [
        {
            "id": 0,
            "order": "1.00000000000000000000",
            "Name": "",
            ...
        }
    ],
    "old_items": [
        {
            "id": 0,
            "order": "1.00000000000000000000",
            "Name": ""
            ...
        }
    ]
}

Maybe you could us a tool like n8n Baserow - n8n Documentation - Microsoft Teams - n8n Documentation or Zapier Baserow Integrations | Connect Your Apps with Zapier - Microsoft Teams Integrations | Connect Your Apps with Zapier, to connect them properly.

3

Hi @bram
Thanks for the hint. I’ll give a try to n8n.