Consume dbt webhooks with Logic Apps. Getting Status: 401.
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.