Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 11, 2020 02:04 AM
Hi all,
I need a bit of help with a simple script to trigger a webhook URL. I don’t need to collect or post any info from the webhook, just to trigger it, like clicking a link.
Any ideas on what that script might look like?
Cheers
Matt
Sep 14, 2020 08:53 AM
Welcome to the community, @Sonja_Askarjan! :grinning_face_with_big_eyes: Adding more input variables to the script is done via the built-in system on the left side of the script editor.
To add those to the URL, append them one at a time after the root URL. As you see in my example above, the first argument must be prefaced by a question mark (?). All arguments after that must be prefaced by an ampersand (&). Also, the argument values must be URL-encoded, which can be done in the script with the encodeURI
function (or, alternately, adding formula fields to your base to encode the data using Airtable’s ENCODE_URL_COMPONENT()
function).
For example, say that I added two more input variables named companyName
and companyEmail
to the input variables section. Adding support for those to the example above, it could look like this:
let url = "https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxxxx?recordID=";
let config = input.config();
await fetch(url + config.recordID + "&companyName=" + encodeURI(config.companyName) + "&companyEmail=" + encodeURI(config.companyEmail));
Jan 30, 2021 11:06 AM
So I too am trying to do something similar…
I have a ZAP webhook that sends an email via Outlook. My current method of “firing” the webhook is a BUTTON = Open URL. the Value of the Button = an AT Field = Formula (Concat, URL + values). when i click the BUTTON, i get a new tab that open in Chrome that i have to close every time i click the button… its annoying! i have a different Webhook that i use and the trigger is AUTOMATION = record updated = run script… this all runs behind the scenes and does not bother me! How can make the Button = run script = use fetch url with the supplied “FULL URL = my concat url formula” to “fetch” the webhook?
I tried using the above method, but get errors…
let url = “https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxxxx?recordID=”;
let config = input.config()
;
await fetch(url + config.recordID);
any thoughts or guidance would be greatly appriciated.
Jan 30, 2021 11:47 AM
Here are some good resources to help.
For connecting Airtable to Zapier Webhook : How to Use Zapier Webhooks in Airtable | On2Air
For connecting Airtable to Integromat Webhook: How to Use Integromat Webhooks in Airtable | On2Air
Apr 11, 2021 06:32 PM
Hi @Justin_Barrett,
This script is now a crucial part of my Airtable/Zapier/Webflow stack. Thank you for sharing!
If you wanted to update all records in a table or a selection of multiple records, rather than just one at a time, what would be your approach?
In other words, if you wanted to click one button and trigger a webhook for all, or multiple, records in airtable, how would you implement that?
Thanks again,
Dean
Apr 12, 2021 12:05 PM
Hey @Dean_Arnold! That depends on the situation. If I’m just updating a batch of records and it’s something that I can accomplish directly in Airtable using either a Scripting block or an automation that runs a script action, I tend to lean in that direction. :slightly_smiling_face: If I’m tying into other services via Zapier or Integromat (which I hardly ever do any more), my old go-to process was to build a view to isolate the records I wanted to process, then have Integromat collect all records from that view at the start of a scenario. With a button-click as the kickoff point, I might do something similar: first have the script mark all of the records I want to process so that they appear in a specific view, then kick off the webhook call to Integromat, where it would grab all records from that view and un-mark them as it went. Another option might be to pass the record IDs of the records to process as part of the webhook call. Integromat could parse the IDs, collect the records, and process away.
Aside from the part where I talked about using a view that Integromat would pull from, a lot of the other ideas are pure speculation, but my gut says they would probably work. I just haven’t tested them to get more specific with the process.
Apr 12, 2021 07:06 PM
Right. Simpler than I thought!
I even decided to forego the view.
I just use an Airtable automation that listens for a status update on the record, then runs this script:
let config = input.config();
await fetch(config.Webhook);
Since the Webhook is a formula field I can trigger different zaps depending on the data in the record.
To your point about un-marking. Yes, that is important. Somewhere in your zaps you always want to change the status or filter you are using for the automation or view.
Feb 02, 2022 10:56 PM
The target system then runs a process that is essentially a simple web server listening for requests, that’s the URL.
A DNS name target.example.com
that resolves to a routable IP address, and
A script in /var/scripts/cleanup.sh
that you’d like to trigger.
Feb 28, 2022 03:19 AM
Hi Justin,
When I tried this script webhook didn’t recognize the recordID. Output comes out like this;
recordID: undefined
How will I solve this?
Thank you for the help!
Feb 28, 2022 09:29 AM
Welcome to the community, @KMU_Project! :grinning_face_with_big_eyes: Did you create a recordID
input variable and assign it to be the record ID of the triggering record?
Feb 28, 2022 10:32 AM
Thank you for help! It worked!