Skip to content
AirTable not findin...
 
Notifications
Clear all

AirTable not finding record via Webhook

13 Posts
3 Users
0 Reactions
4 Views
JMM
 JMM
(@jmm)
Posts: 6
Active Member
Topic starter
 

Hello,

I'm encountering a [404] NOT_FOUND error when using a webhook to retrieve a record ID from Airtable, and I'm struggling to figure out the cause. It's quite frustrating!

Please see the video of the issue here and the screenshots below: Content Blog with Webflow and OpenAI GPT: Content themes & shows - Airtable

The script appears to be functioning correctly during testing but isn't transferring the data to Airtable via callin.io.

Any assistance would be greatly appreciated!

Thank you,
James

 
Posted : 18/12/2023 12:13 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

Welcome to the callin.io community!

Your Record ID is undefined because your input variable is recordId, but your Airtable input is recordid

Screenshot_2023-12-18_201254

Screenshot_2023-12-18_201246

Variable raw names are case-sensitive.

If you still require assistance,

Please share the output bundles from the Custom Webhook module after running the scenario. Then, click the white speech bubble located at the top-right of each module. Save the bundle contents in your text editor as a bundle.json file and upload it here.

Screenshot_2023-10-06_141025

Providing the output bundles will enable others to replicate the scenario's behavior, even if they don't use the external service.

This will help others assist you more effectively. Thank you!

 
Posted : 18/12/2023 12:46 pm
JMM
 JMM
(@jmm)
Posts: 6
Active Member
Topic starter
 

Hello,

That’s a useful observation, but unfortunately, it hasn't resolved the issue for me.

Here is the output bundle from the webhook as requested:

json
[
{
"recordId": "undefined"
}
]

For your verification, please examine the input in Airtable here:

I'm unsure how to create a bundle.json file. I've searched online but haven't found clear instructions. It always saves as plain text, and then callin.io won't allow me to upload it. My apologies, but I hope this information is helpful!

Thank you very much!

James

 
Posted : 18/12/2023 1:34 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

In your Airtable script, it appears you need to use this instead:

javascript
const [ recordId ] = input.config();

 
Posted : 18/12/2023 1:44 pm
JMM
 JMM
(@jmm)
Posts: 6
Active Member
samliew
(@samliew)
Posts: 293
Reputable Member
 

That's strange, this is almost identical to what's in their documentation:

Screenshot_2023-12-18_221234

Maybe we should follow the example precisely:

let inputConfig = input.config();
const response = await fetch(`${webhookUrl}?recordId=${inputConfig['recordId']}`)
 
Posted : 18/12/2023 2:08 pm
JMM
 JMM
(@jmm)
Posts: 6
Active Member
Topic starter
 

Hi there,

Thanks, and apologies for needing to ask, but what should I copy and paste?

Unfortunately, I'm not a developer.

The callin.io setup I'm using comes from a package purchased via GumRoad. It's just this one step that I'm unable to get working.

Thanks,
James

 
Posted : 18/12/2023 2:13 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

that replaces lines 3-5 (your 4 is currently an empty line)

 
Posted : 18/12/2023 2:19 pm
JMM
 JMM
(@jmm)
Posts: 6
Active Member
Topic starter
 

Unfortunately, the issue persists identically.

I've verified that the webhook configuration is correct in both Airtable and callin.io.

Would it be possible to schedule a video call to troubleshoot this live? It's becoming quite frustrating.

Thank you

 
Posted : 18/12/2023 2:25 pm
Christopher_Lembke
(@christopher_lembke)
Posts: 14
Eminent Member
 

This approach worked for me. I created a formula field to extract the record ID using Record_ID() and then utilized this field instead of the default record ID field. This modification ensures the record ID is now output correctly in the callin.io scenario:

image

 
Posted : 01/01/2024 4:49 pm
Christopher_Lembke
(@christopher_lembke)
Posts: 14
Eminent Member
 

It turns out that was a fluke. The correct solution was provided; it's an Airtable bug. The recordID won't be sent until the automation is activated. I also had to implement the script that was suggested:

javascript
let config = input.config();
let url = `` [webhook url goes here]?RecordID=${config.recordid} ``;
fetch(url);

Here is a link to the full explanation of the script:

 
Posted : 02/01/2024 12:23 pm
JMM
 JMM
(@jmm)
Posts: 6
Active Member
Topic starter
 

Hi Christopher,

Thanks for this - somehow I got mine working (complete fluke!) but this is awesome and I really appreciate it!

James

 
Posted : 02/01/2024 4:27 pm
Christopher_Lembke
(@christopher_lembke)
Posts: 14
Eminent Member
 

Likely when you activated your AT automation script, I would assume? That was the key point; in test mode, I won't send the record ID, only when it's active. I'm glad you also managed to get it working.

 
Posted : 02/01/2024 4:40 pm
Share: