Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: SendGrid To Airtable Webhooks

Solved
Jump to Solution
214 0
cancel
Showing results for 
Search instead for 
Did you mean: 
MPruthi97
4 - Data Explorer
4 - Data Explorer

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!

 

1 Solution

Accepted Solutions
Avis682Holmes
4 - Data Explorer
4 - Data Explorer

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.

See Solution in Thread

1 Reply 1
Avis682Holmes
4 - Data Explorer
4 - Data Explorer

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.