Re: Webhook from Typeform

Dana_Rokach · ‎Apr 08, 2021

Hi,
I send the form results through a Webhook to Airtable Automations and somehow, I can’t see all the data in the Airtable variable. For example: choices. Can someone help?
The original JSON is pretty long but less than 100kb.

Attached part of the JSON:

Headers
User-Agent: Typeform Webhooks
Content-Type: application/json
Payload
{
  "event_id": "01F2RCN9Q5F24TTF2MY2G4FAB8",
  "event_type": "form_response",
  "form_response": {
    "form_id": "gfSaLT",
    "token": "tc3nuwsqelb7q8a5m82tc3n7nkr9a5zc",
    "landed_at": "2021-04-08T09:21:44Z",
    "submitted_at": "2021-04-08T09:22:54Z",
    "hidden": {
      "interviewee_id": "123123",
      "interviewee_name": "My NAME"
    },
    "definition": {
      "id": "gfSaLT",
      "title": "Pre-Interview Form",
      "fields": [
        {
          "id": "e2Hswr4jWPs1",
          "title": "תמונת פרופיל",
          "type": "file_upload",
          "ref": "a1c008b2-7a9c-42bc-9a6c-6e9afcb935a4",
          "properties": {}
        },
        {
          "id": "zlMjlSMVYHPt",
          "title": "חודש התחלת התמחות",
          "type": "multiple_choice",
          "ref": "88d83a7a-4526-46b6-8da3-06fddb76366c",
          "properties": {},
          "choices": [
            {
              "id": "bTSjxi2p2oOw",
              "label": "מרץ"
            },
            {
              "id": "fsBvpd9EXXS7",
              "label": "ספטמבר"
            }
          ]
        },

The automation response:
Payload
{
“success”: true
}

Thanks in advance,
Dana

Justin_Barrett · ‎Apr 15, 2021

From what I recall hearing from others re: the behavior of Airtable webhooks, the JSON can’t have nested properties. Everything must be at the root level of the original object, with nothing nested (e.g. you can’t have an object that contains an array of other objects). Because Typeform nests the structure several levels deep, it might not be a viable solution.

Someone recommended Cognito Forms to me the other day, and I ran a quick test that confirmed that it works fairly well with Airtable’s webhook automation trigger. Admittedly I didn’t do a very deep test, but it’s worth investigating.

Correct. The only response that Airtable is going to give you is whether or not the webhook call was successful; i.e. did it get through? It’s not going to give you any feedback on the readability of the submitted JSON data on Airtable’s end.

See Solution in Thread

Justin_Barrett · ‎Apr 15, 2021

From what I recall hearing from others re: the behavior of Airtable webhooks, the JSON can’t have nested properties. Everything must be at the root level of the original object, with nothing nested (e.g. you can’t have an object that contains an array of other objects). Because Typeform nests the structure several levels deep, it might not be a viable solution.

Someone recommended Cognito Forms to me the other day, and I ran a quick test that confirmed that it works fairly well with Airtable’s webhook automation trigger. Admittedly I didn’t do a very deep test, but it’s worth investigating.

Correct. The only response that Airtable is going to give you is whether or not the webhook call was successful; i.e. did it get through? It’s not going to give you any feedback on the readability of the submitted JSON data on Airtable’s end.

ScottWorld · ‎Apr 15, 2021

@Dana_Rokach

Everything that @Justin_Barrett said above is fantastic advice!

Additionally, if you want to stick with TypeForm, you can just use Integromat to process your TypeForm form and send all of the data — including any nested data — into Airtable: