Webhook data sent to Zapier showing apostrophe as '

  • jesseboyd
    Asked on June 29, 2020 at 4:29 PM

    I have my form sending a webhook to Zapier. The form submissions that contain apostrophes are displaying them as '.

    This formatting is getting passed on to the destination.

    Any tips on how I can fix it? It's possible to occur in one of many text fields.

    Jotform Thread 2419195 Screenshot
  • Ariel JotForm Support
    Replied on June 29, 2020 at 7:33 PM

    Greetings,

    Thank you for contacting Support.

    I'm currently looking at your form, I'll update you on this same thread as soon as I have some news.

  • Ariel JotForm Support
    Replied on June 29, 2020 at 8:28 PM

    Greetings,

    Thank you for reaching out.

    I have cloned your Maintenance Request form and wasn't able to reproduce the issue.

    15934750042020 06 30 07 54 27 Screenshot 10

    Nonetheless, try adding a Formatter on you Zap (Formatter by Zapier > Text) to fix your issue.

    15934761062020 06 30 08 13 16 Screenshot 21

     

    Select Convert valid HTML to Markdown, then select your affected fields as Values.

    15934763692020 06 30 08 15 58 Screenshot 32

    Here's a little test to see a preview of the formatter's result.

    Before:

    15934764862020 06 30 08 08 48 Screenshot 43

     

    After:

    15934765502020 06 30 08 10 48 Screenshot 54

    Please give it a try and let us know how it goes.