![]() But don’t worry about this part if it isn’t clear, we’re really focused on the Airtable end). AIRTABLE SCRIPTING SERIES(Postman needs a tutorial series in its own right, so I won’t labour this point. We’ll use Postman to play the part of the sending app. In the rest of this post, I’ll show how Airtable is set up to receive a webhook and use that data in an automation. One of the new features in Airtable Automations is the ability to accept a webhook post from another app and capture the data that this app is going to send to us. There’s a certain efficiency about webhooks. With the polling method, I have no idea how many orders I might get when I run every 10 minutes - it could be 1, 10, 100, or, most of time, zero. There’s something nice about webhooks because they are initiated by the app that knows about the event. One is a “pull” and the other is a “push”. Or I can set up a webhook in Shopify that sends the data to Airtable when an event occurs (when a customer places an order for example).I can set up a script in Airtable (or somewhere else) that polls the Shopify API every 10 mins for new orders.There’s essentially two ways I can get the Shopify order data into Airtable: My Airtable base is my fulfilment engine and needs to know about the orders I’ve taken. Let’s say I’ve got a Shopify website to display my widgets and take orders from my customers and I’ve got an Airtable base that holds all of my orders and allows me to make and dispatch my widgets. But what is a webhook? Let’s use a real life scenario to illustrate. Or maybe you want to learn Airtable scripting but you’ve got a pressing deadline that you just need to hit.If you’ve been hanging around SaaS apps and their APIs over the last few years, you’ve probably heard the term “webhook” being banded about by those smart developer types □. You might not have the time or the in-house resource to bring your Airtable environment up to scratch. This is great when you are starting out, but once the table is created you can’t import more data to it - it is only for table creation.Īlongside the introduction of scripts, one of the big leaps forward in Airtable functionality in 2020 was the Automations feature. When creating a table you can use the Import data functionality. Importing a CSV file using Airtable scriptingĪirtable has a couple of ways to import data from an external file - a CSV file or spreadsheet for example. Setting the scene: We have a set of records - in this case, company names - and we want to weed out the duplicates and find a unique set of names (by implication, we’re going to end up with the “first” occurrence of any company name and discard second and subsequent occurrences). If you’ve been hanging around SaaS apps and their APIs over the last few years, you’ve probably heard the term “webhook” being banded about by those smart developer types □. You don’t need to have anything else in your kitbag to make it work. A few tables and views, a couple of forms, maybe an automation or two and, of course, some scripts and you’re all set. Why are there many ways to do the same thing and why doesn’t everyone do it the same way?įor many Airtable use cases, Airtable is the only thing you need. ![]() If you’re a new coder and looking at scripts written by others, some of the syntax and coding conventions can be confusing. AIRTABLE SCRIPTING HOW TOInterested in learning how to script with Airtable? In this post, we’re going to go in the opposite direction and POST some Airtable data to an API. In part 1 we looked at how to get data from an API and create records in Airtable using a GET request. But for a little more control and configurability (and to continue our API series), in this post we’re going to use the Airtable scripting block to communicate directly with SendGrid. Sending an email using SendGrid (APIs Part 3)Īirtable has a built-in SendGrid app and this is great for sending emails to your users/customers/whatever. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |