Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: A little help with a script to trigger a webhook

22776 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt1
4 - Data Explorer
4 - Data Explorer

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

29 Replies 29

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));
Eddie_Kaeser
6 - Interface Innovator
6 - Interface Innovator

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.

openside
10 - Mercury
10 - Mercury

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

Dean_Arnold
7 - App Architect
7 - App Architect

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

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.

Dean_Arnold
7 - App Architect
7 - App Architect

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.

Jhon_Albert
4 - Data Explorer
4 - Data Explorer

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.

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!

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?

Thank you for help! It worked!