[422] Unknown field name: " Airtable cannot find column which DOES exist

There have been similar posts with this issue but none of the proposed solutions have worked for me.

This workflow was working perfectly, I set it aside for an hour and when I came back, this error occurred.

I know that the column exists because when I copy the cell url the field name the error states it cannot find is in the url. The field in the error is fldBiyHwOzOPQmzgX
The cell url is:
/tblIweCZ1XUzMoUXZ/viwUsajuMzPJHWVBQ/reclRUV1pBuHowXbE/fldBiyHwOzOPQmzgX

Here is what I have tried:
I duplicated the module and tried again. still errored.
I created a new module from scratch. Still errored.
Tried both Update and Upsert. Still errored.
I have removed the data from errored column in Make and it will immediately error with a different column.
I have tested each column and it errors on all columns.
I recreated each column in the Airtable and tested it. Still errored
I duplicated the table and used a new table. still errored
I created a new Access token. still errored
I tried Oauth. Still errored.
I tried in a new workflow. Still errored.

What doesn’t make sense is that I have another workflow accessing the same Base but a different table and there is no issue. It works fine. Even with the updated Access token.

Somehow this table or this set of data in any form does not allow Make to update or upsert a record.
The RecordId is being sent from a Airtable Automation which posts to a webhook so I know the RecordId is valid.

I am not sure what I could be missing and what more solutions to try.
And also again, it was working as expected but an hour later it just stopped and has never worked again.
I am not new to Make.com and automation but this one has stumped me.

Any help would be appreciated!

Similar post

Hello @Harrison_Riehle,
Can you please show me the settings of that Airtable module and also let me know what data comes from the previous model?


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down:

If it exists, then it might be a bug.

For bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to. Additionally, sharing sensitive information about your account or scenario might not be suitable for an open forum discussion.

You can open a new ticket here, or if you are unable to login for some reason, you can create another new free account to access the ticketing system (which is only available to logged-in users). After submitting a new ticket, you will receive an automatic confirmation email with the subject “Ticket Created” in the subject. If you do not receive this, try sending the ticket again.

If you need further assistance, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.