Webhook data format with Workato (App Connect for Insightly).

So I have been using Zapier to get form submissions and bring the data to Monday.com

We have moved from Monday.com to Insightly and using Workato/(App Connect) instead of Zapier for all our integrations.

Unfortunately Jotform isn't a native app for Workato.

I looked into the Insightly integration here in Jotform but that won't let me put the data in the custom object that I need to. Also I would like to do some logic when gathering the data.

So I am trying to just use a webhook and bring the data on submission.

I need some help understanding how to get the data from the form fields to use in the Workato recipe. Or just general knowlege on what webhook type of methood I should be using and what payload type I can get

Hello @boydbar,

Thanks for reaching out to Jotform Support. The webhook data is in JSON format, and below is an example:

{

   "slug":"submit\/222207483864055\/",

   "q3_name":{

      "first":"John",

      "last":"Doe"

   },

   "q4_email":"john@example.com",

   "event_id":"1660086874830_222207483864055_sBf4zwN",

   "path":"\/submit\/222207483864055"

}

Related guide: How-to-setup-a-webhook-with-jotform

Should you have any further inquiries, please feel free to get back to us.

Hello @amin where can I find the payload schema template?

Hello @boydbar,

Thanks for reaching out to Jotform Support. I'm not sure what you mean by the "payload schema template". We would be so much grateful if you could just further elaborate and provide more information so that we can better assist you.

We're patiently waiting for your response.

When setting up the webhook in workato where I want the data to come. When I request the data in json format the webhook never triggers. If I use their wizard to set up the webhook it gets a submission that has none of the fields. and comes as "unicode text data"... :|

Hello Boydbar,

Please allow us some time to check on this and we'll get back to you with relevant information.

Thank you for your patience.