Webhook Not posting

Austin_Nunns · 07-13-2020 10:35 AM

Hey Appsheet team! I am having an issue with a webhook not functioning.
I have a workflow setup to send a webhook to Zapier (POST, JSON). I have 2 of these already set up and functioning on seperate workflows, just trying to add this for a separate form. The issue is that even though this is setup the same way, it isn’t posting to the zapier site. I have it setup with the zapier Url, Post, JSON, and then tried it with and without the auto-generated body template. I also tried an online webhook tester “webhook.site” and it didn’t pick up a response. I made sure the workflow was triggering by adding another action under the same workflow to email me, and it does.
Thanks!

Phil

What do you see in Audit History as described here https://help.appsheet.com/en/articles/962018-troubleshooting-webhooks

Austin_Nunns

Hi Phil, thanks for getting back to me.
Here is the error I got from the audit log. I’m guessing it has to do with syntax used in my column name, using “:”.

“Errors”: “Error: Failed to parse JSON due to Invalid character after parsing property name. Expected ‘:’ but got: s. Path ‘[‘Q2 Comments’]’, line 1, position 306… Invalid JSON value starts with: self-quarantine” by a medical professional?": “N”,“Q3 Comments”: “”,“Have you or any of your personn”,

Any idea how to fix this? Am I going to have to change my column names?

Austin_Nunns

Austin_Nunns

Well I ended up just removing everything I didn’t need via a text editor as the stuff that said was causing the issue was useless to me anyway, so now it works.

Phil

Glad you got it working. I just saw your earlier question.