Power Automate - Building Flows

Answered

Mandrill Webhook parse application/x-www-form-urlencoded request

Like (0) Share

Report

Posted on 1 Mar 2023 16:05:36 by ndndnnn

Hello all,

I am trying to configure Mandrill (for mail transactions) Webhook to write on Teams when a mail is bounce. Webhook is generating a request in application/x-www-form-urlencoded format instead json format. So I am trying to parse it correctly and I am having some difficulties.

Hope somebody could help me.

I am trying to get access to properties into formadata > value.

This is the output of the trigger

{

"headers": {

"Accept": "*/*",

"Host": "prod-31.westeurope.logic.azure.com",

"User-Agent": "Mandrill-Webhook/1.0",

"X-Mandrill-Signature": "M2YBbE5ZzBaxGBcGDOL0Cj6LIhA=",

"Content-Length": "3884",

"Content-Type": "application/x-www-form-urlencoded"

"body": {

"$content-type": "application/x-www-form-urlencoded",

"$content": "base64code",

"$formdata": [

{

"key": "mandrill_events",

"value": "[{\"event\":\"delivered\",\"ts\":1677682563,\"diag\":\"250 2.6.0 <adbff3de-44dd-4282-88ed-9bb54e7fb876> ,\"sender\":\"mail@mail.com\",\"template\":\"template\"}}]"

}

]

}

I censored base64 content and "value" for privacy reasons.

How can I achieve this? I am not sure how to parse that output and extract $formdata.

Thanks in advance

Monosnap Historia...

All responses (2)

Answers (1)

hahart 3 on 16 May 2023 at 19:49:53

Like (0)

Report

Re: Mandrill Webhook parse application/x-www-form-urlencoded request

Thank you! This worked a dream.
Verified answer

ndndnnn 12 on 02 Mar 2023 at 10:13:24

Like (1)

Report

Re: Mandrill Webhook parse application/x-www-form-urlencoded request

in case there is someone with the same problem, here is the solution with Mailchimp Webhook. It was a little bit tricky:

step 1 and 2

1.- When a HTTP request is received Connector with empty JSON scheme.
2.- JSON Parse with:
Content: triggerBody()['$formdata']
Scheme:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"key": {
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"key",
"value"
]
}
}

3.- Apply to each:
Output: body('parse_JSON')
4.- Parse JSON 2:
Content: items('Apply_to_each')['value']
Scheme:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"event": {
"type": "string"
},
"_id": {
"type": "string"
},
"msg": {
"type": "object",
"properties": {
"ts": {
"type": "integer"
},
"_id": {
"type": "string"
},
"state": {
"type": "string"
},
"subject": {
"type": "string"
},
"email": {
"type": "string"
},
"tags": {
"type": "array",
"items": {
"type": "string"
}
},
"smtp_events": {
"type": "array"
},
"resends": {
"type": "array"
},
"_version": {
"type": "string"
},
"diag": {
"type": "string"
},
"bgtools_code": {
"type": "integer"
},
"sender": {
"type": "string"
},
"template": {
"type": "string"
},
"bounce_description": {
"type": "string"
}
}
},
"ts": {
"type": "integer"
}
},
"required": [
"event",
"_id",
"msg",
"ts"
]
}
}
Now you can use the useful keys Mailchimp Webhook has. You could send it via email.

Community site session details

Mandrill Webhook parse application/x-www-form-urlencoded request

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Mandrill Webhook parse application/x-www-form-urlencoded request

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates