A little help with a script to trigger a webhook

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

2 Likes

Hi!

I’m also interested to this!

Welcome to the community, @Matt1! And welcome back, @Jonathan_Blair-Joly! :smiley:

The bare-bones pieces you need are the webhook URL and the fetch call to it. Here’s an example with an Integromat webhook call:

let url = "https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxxxx";
await fetch(url);

If you want to pass anything to it, append it to the URL. For example, I use a webhook to call an Integromat scenario to generate a PDF version of the invoice for a specific record, and save it back into the record’s attachment field. When I click the button in a button field on the invoice record, it calls this script, and passes the ID of the record in the webhook like this:

let url = "https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxxxx?recordID=";
let table = base.getTable("Invoices");
let view = table.getView("Outstanding: Actions");

let record = await input.recordAsync("Pick a record", view);
await fetch(url + record.id);
2 Likes

Awesome!

Thank you @Justin_Barrett, I’ll integrate this with the new automation feature.

Thanks again!

@Justin_Barrett

First example worked perfectly.

For the second one with the record id append to the url, I got that error :

ERROR

TypeError: input.recordAsync is not a function
at main on line 5

Do I need to replace “Pick a record” with something? What about taking any record within a specific view or all records within a specific view?

The input.recordAsync method only works when you click a button in a button field to trigger a script in the scripting block. Your earlier note didn’t mention going the automation route. For that, you’ll need to add an input variable to your script action step, passing in the record ID of the triggering record from the trigger step. Let’s say you named that input variable recordID. That would then be available via input.config(). Here’s my earlier example tweaked to work for an automation:

let url = "https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxxxx?recordID=";
let config = input.config();
await fetch(url + config.recordID);
1 Like

Sorry, I forgot to answer your follow-up question:

The automation system works using a triggering record, either a new one added to a table, or a record entering a specific view via a filter. If you want the automation’s script to run on a collection of records, that’s doable, but you’ll need to modify your script to search for the records you want, and also come up with a trigger mechanism that makes sense for your use case. You haven’t shared details about your base design, so I can’t offer any specific suggestions on that front.

This is great. thanks so much!!

@Justin_Barrett

That’s exactly what I need!

Thank you so much.

@Justin_Barrett How would I pass multiple input variables in the URL and via config…?

Welcome to the community, @Sonja_Askarjan! :smiley: 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));
1 Like