Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

404 error in Airtable module in Make.com

1925 9
cancel
Showing results for 
Search instead for 
Did you mean: 
dancarl
4 - Data Explorer
4 - Data Explorer

I am very new and only working on a free account and have run out of free ai chat credits.

 

I am trying to follow a youtubers work flow to create blog articles and post to my wp site. workflow is as follows

Webhook-->Airtable-->Claude-->claude-->JSON-->Cluade-->Tools-->OpenAI-->Openai-->markdown-->Google Doc-->Google doc-->Airtable-->wordpress.

some of the double cluade and openai were create prompt then create article/image.

Webhook

https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3

Airtable layout

Blogs Posts

 RecordID | Main Keyword | Generate | Outline | Complete Google Doc | Google doc image | Status

Webhook in Airtable ( generate tab )


 
RecordID tab 
RIGHT("000000" & RECORD_ID(), 6)
 
nothing in Main Keyword tab.
 
so work flow is  click new row in airtable = generates new RecordID and a "Generate" button I add in the "Main Keyword" and then sent to Claude to create my prompt, then Claude to "JSON Create" then JSON markdown --> back to Claude to create article, then open ai to create image prompt, then open ai dalle3 to create image, -->markdown then into a google doc, and image into a google doc, to airtable and then to wordpress. 
 
Sorry if it is drawn out but just copying from youtube.
 
I have reconnected my account in airtable, redetermined data structure and a few other things but cannot get past the 404 error in the airtable module.
 
Thank you for any help.
 
Dan

 

9 Replies 9

Hm for the RecordID field, try using 'RECORD_ID()' instead of 'RIGHT("000000" & RECORD_ID(), 6)'?  Think that should help

dancarl
4 - Data Explorer
4 - Data Explorer

would i need to change the field in the "Generate" tab?

dancarl
4 - Data Explorer
4 - Data Explorer

i did change the record id field but still had the 404

Ah sorry about that, yeap, you need to update the button formula to be the following:

'https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3?RecordID=' & {RecordID}

 

ScottWorld
18 - Pluto
18 - Pluto

@dancarl 

Some top Make tips for you here:

While it is often desired to trigger a Make automation through a button in Airtable, that always opens up an extra browser tab that you need to close afterwards, either manually or through a JavaScript.

Now the advantage to this is that you can control the contents of that browser tab by using Make’s webhook response module.

But if you just want the automation to run without taking the user out of Airtable, you can trigger your Make automation using Airtable’s automations. I discuss how to use this technique in this thread.

I’ve also assembled a bunch of additional Make training resources in this thread.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

now i don't get my unique "RecordID" in the row i just get ( RECORD_ID() ) in each row and still get the 404 error.

thank you

Hmm, weird!  I tried it out and it seems to be working fine.  Could you have a look at the base and try to see what's different from your own set up?
Screenshot 2025-01-22 at 12.46.10 PM.png

To do that, you'll need to duplicate the base into your own workspace with instructions on how to do that here: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-bases-in-airtable

 

your example it's passing on the unique Record id in the webhook formula. I need it to pass on the Main Keyword. 

so I must be missing something simple? So will go over what I'm trying to do again. 

so airtable has 3 columns so far, first one is RecordID then Main keyword and the last is Generate.

When I click a new row it automatically generates a new unique RecordID of 6 characters  and the blue generate button appears. I manually add in the Keyword and hit generate and it sends the keyword to the Make.com workflow. 

my formula in the "RecordID" looks fine it generates a unique code and the formula is 

RIGHT("000000" & RECORD_ID(), 6)

The Generate formula is 

 
but i get the 404 error in the airtable module in Make.com, in the error code the input shows this..

 

Input

 

  • Bundle 1Collection
    • Record ID
      {RecordID}
    • Base
      appQfFK7uuDJVWEe5
    • Table
      tblzsWFSwUclJzhla
    • Use Column ID
      false

The process makes it way all the way to the air table module then stops with the error, the first webhook module runs fine. and it's webhook address is. 

https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3

 
 

Hmm, yeah, I reckon it might be faster if we get on a call to do this.  I do free half hour calls and we should be able to get you sorted within that time and you can grab a time here!  https://calendly.com/adamc_airtable/30min