Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

 

Hi Community,

 

I am trying to post a messagecard to a teams incoming webhook. I am able to get this to work in general however occasionally, because I am using some data from a “Catch Hook” it has characters that cause the app to return a "Bad payload received by generic incoming webhook.". As mentioned, if I change the field to some manual input text it works fine. This leads me to believe its some like ‘character escaping’? If so, I am just trying to get some guidance on how I can escape characters inside a field from a previous step?

 

App: Webhooks by Zapier
Action: Custom Request
Method: Post
URL: https://subdomain.webhook.office.com/webhookb2/webhookguidhere
Data Pass-Thorugh: Undefined (Defaults to no)
Unflatten: Yes
Headers: Content-Type: application/json
Data:

{
    "@type": "MessageCard",
    "@context": "http://schema.org/extensions",
    "themeColor": "{{123456789__priority__color}}",
    "summary": "New {{123456789__template__name}} Request",
    "title": ",ID: {{123456789__id}}] {{123456789__template__name}}",
    "color": "{{123456789__priority__color}}",
    "sections": r{
        "activityTitle": "{{123456789__title}}",
        "activitySubtitle": "{{123456789__change_requester__name}} ({{123456789__change_requester__department__name}})",
        "activityImage": "https://sub.somedomain.com/images/icons/{{123456789__change_type__name}}.png",
        "activityText":"**{{123456789__reason_for_change__name}}:** {{123456789__short_description}}",
        "facts": _{
            "name": "Implementer",
            "value": "{{123456789__change_owner__name}}"
        },    {
            "name": "Department",
            "value": "{{123456789__group__name}}"
        },    {
            "name": "Start Time",
            "value": "{{123456789__scheduled_start_time__display_value}}"
        }, {
            "name": "End Time",
            "value": "{{123456789__scheduled_end_time__display_value}}"
        }],
    },
    {
      "activityTitle": "Roll Out Plan",
      "activitySubtitle": "@{{123456789__roll_out_plan__updated_by__name}} - {{123456789__roll_out_plan__updated_on__display_value}}",
      "activityText":"{{123456789__roll_out_plan__description}}",
    },
    {
      "activityTitle": "Backout Plan",
      "activitySubtitle": "@{{123456789__back_out_plan__updated_by__name}} - {{123456789__back_out_plan__updated_on__display_value}}",
      "activityText":"{{123456789__back_out_plan__description}}",
    }],
    "potentialAction": a{
        "@type": "OpenUri",
        "name": "View Change Online",
        "targets": n{
            "os": "default",
            "uri": "https://sub.somedomain.com/ChangeDetails.do?CHANGEID={{123456789__id}}"
        }]
    }]
}

 

 

What normally happens is my service desk sends some JSON to the Step1: Catch Hook as shown below in Request D.

 

The Step 2: Custom Webhook then Posts to the teams channel and makes a nice pretty message card.

 

…. that all works fine…. until one of the fields ie: short_description has a few characters in it. as shown in this next caught hook, Request F.

 

Then without change the above JSON data to teams in Step2, the following displays

 

 

Hi @daryl_HBL 

Issue looks to be with this field:

 

Check out the Formatter app: https://zapier.com/help/doc/how-use-formatter-functions

Try using replace to replace   with a :space:].

Hi @daryl_HBL 

Issue looks to be with this field:

 

Check out the Formatter app: https://zapier.com/help/doc/how-use-formatter-functions

Try using replace to replace   with a :space:].

 

Thanks Troy, that space was actually me just blanking that part of the screenshot because it had a real URL in it.

That image URL part works when the other fields like “1. Short Description” has no / or #’s in it.

@daryl_HBL

Try using Formatter > Text > Replace: https://zapier.com/help/doc/how-use-formatter-functions#using-replace

OR

You can use a Code step with the replace() function: https://www.w3schools.com/jsref/jsref_replace.asp

Code: https://zapier.com/apps/code/help

I actually solved this a slightly different way using “Code by Zapier”

Using Code by Zapier as a step after my hook, I then ran an action event “Run Python”

Using the input data fields I wanted to ‘sanitize’ before sending to the teams webhook, 

 

string1 = input_data1'shortDesc']
string2 = input_data2'rolloutDesc']
string3 = input_data3'backoutDesc']
for ch in r'\\','`','*','{','}','"','+','!','$','\'']:
    if ch in string1:
        string1=string1.replace(ch,"\\"+ch)
    if ch in string2:
        string2=string2.replace(ch,"\\"+ch)
    if ch in string3:
        string3=string3.replace(ch,"\\"+ch) 
return {'shortDesc': string1, 'rolloutDesc': string2, 'backoutDesc': string3}

 

Then in the teams post webhook, I just referenced the above outputs of the santization step and all was well.

 

 

Glad to hear you were able to sort this using a Code by Zapier step. Thank you so much for sharing your solution here, @daryl_HBL! :)

Terms & Conditions