Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Get new record data with webhooks

Topic Labels: Automations Sync
4536 5
cancel
Showing results for 
Search instead for 
Did you mean: 
kaminoan
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to be able to get notified whenever a new record is created in one of the tables I have, since I want to be able to copy the data into Firebase Firestore using Firebase Functions. This records are created using Softr or an Airtable form.

I have been able to create a webhook and I receive the notification pings in the "target" Firebase Function, getting a very simple payload containing the webhook ID and the base ID (using the correspondent "filter" options). However, I do not know how can I get the actual data of the record. I understand I should fetch the change payloads but I don't seem to be getting it right.

5 Replies 5
Théau
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes you need to call the endpoint https://api.airtable.com/v0/bases/{baseId}/webhooks/{webhookId}/payloads which will list all the payloads related to the webhook you created. And then find in the array the data you're looking for 

ScottWorld
18 - Pluto
18 - Pluto

Yeah, those webhooks are very tricky & nuanced, especially because they expire too. It is much easier to either use Airtable’s webhooks that are built into Automations, or simply use the very easy-to-use webhooks that are built into Make

kaminoan
5 - Automation Enthusiast
5 - Automation Enthusiast

How can I determine which of the payloads from the array is the one containing the newly created record data?

kaminoan
5 - Automation Enthusiast
5 - Automation Enthusiast

Unless I am wrong, Make/Integromat does not seem to have a clear way of detecting when a new record is created in real-time and trigger an automation based on that. Am I wrong?

Théau
5 - Automation Enthusiast
5 - Automation Enthusiast

There is a field `baseTransactionNumber` that gets incremented by one for each notification. You can keep track of it :))