Skip to main content
Answer

Webhook from Typeform

  • April 8, 2021
  • 2 replies
  • 28 views
D

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

Best answer by Justin_Barrett

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.

2 replies

Justin_Barrett
Forum|alt.badge.img+21

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
D
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • April 16, 2021

@Dana_Rokach

Everything that @Justin_Barrett said above is fantastic advice!

If you want to stick with TypeForm, you can just use Make’s TypeForm integrations to get your data into Airtable.

However,  your #1 best bet for this is to leave TypeForm and instead use Fillout’s advanced forms for Airtable. Fillout communicates directly with Airtable and can natively do everything that you need to do — no webhooks required.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

D
Justin_Barrett
Terms & ConditionsAccessibility statement