- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 11:24 AM - edited ‎Jan 31, 2025 07:21 AM
Hi Everyone,
I need access to 30 days of email data in SendGrid, and one approach I’m exploring is using webhooks. However, I haven’t been able to set it up successfully in Airtable.
A few months ago, I successfully sent webhooks from MS Planner, and it worked fine. One key difference is that the payload from Planner was not nested, whereas the JSON from SendGrid is. Interestingly, when I sent a test request via Airtable's webhook trigger, I received a positive response—again, with non-nested JSON.
I also tested this in Zapier, and it worked without issues. This leads me to believe that Airtable webhooks may not support nested JSON structures.
Has anyone encountered this before or found a workaround? Would love to hear your thoughts!
Thanks!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 01:54 AM - edited ‎Feb 02, 2025 08:45 PM
Hello!
Airtable webhooks may not support nested JSON structures. To work around this, you can pre-process the JSON using a service like Zapier or Integromat to flatten it before sending it to Airtable. Alternatively, write a custom script to convert the nested JSON or use other tools that handle nested JSON better. Since Zapier worked for you, you can choice advantages use it to capture and process the webhook from SendGrid, then push it to Airtable.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 01:54 AM - edited ‎Feb 02, 2025 08:45 PM
Hello!
Airtable webhooks may not support nested JSON structures. To work around this, you can pre-process the JSON using a service like Zapier or Integromat to flatten it before sending it to Airtable. Alternatively, write a custom script to convert the nested JSON or use other tools that handle nested JSON better. Since Zapier worked for you, you can choice advantages use it to capture and process the webhook from SendGrid, then push it to Airtable.
