Consume dbt webhooks with Logic Apps. Getting Status: 401.

Daniel Aguayo 0 Reputation points
2024-09-10T21:00:00.6233333+00:00

I am trying to consume a webhook from dbt that has an authorization token, dbt asks for an endpoint to communicate a payload to. I managed to test it properly with pipedream and it worked, the interface of pipedream allowed me to put an Authorization header and I was able to receive the json payload.

After testing it all worked, I am trying to consume this via logic apps. I am using an activity "When a HTTP request is received". And when triggering on dbt side I am getting status 401. This potentially means that dbt can't communicate with the logic app because it is missing the authentication, the issue I have is that this activity doesn't have the option of adding authentication on handshake.

I am choosing this activity because I require the endpoint that is generated on this activity to give to dbt. I tried http on its own and I got the status 400 when using the worlflow URL.

Below a sample of my current logic app.

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {},
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "parameters": {
            "$connections": {
                "defaultValue": {},
                "type": "Object"
            }
        },
        "triggers": {
            "When_a_HTTP_request_is_received": {
                "kind": "Http",
                "type": "Request"
            }
        }
    },
    "parameters": {
        "$connections": {
            "value": {}
        }
    }
}

Any help or ideas on how to work this around is appreciated, perhaps the solution is to create a custom logic app connector.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,548 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.