Post Upgrade to v1.39.1 - Airtable Node Output Fields BROKEN

[dkindlund]

Bug Description

After upgrading to v1.39.1, we see 2 distinct bugs:

1. When creating a NEW workflow using an Airtable node, you can no longer specify any Output Fields from the drop-down selector -- it's utterly broken.
2. When editing any EXISTING workflows that did use an Airtable node where previously specific Output Fields were provided, those specific Output Fields are automatically CLEARED and so then upon saving the existing workflow ALL record fields are returned.

The only workaround is to specify an Expression as an array of strings where each string is a field name, like so:

To Reproduce

1. Create a new workflow in v1.39.1
2. Add an Airtable node
3. Try to specify the Output Fields using the drop down
4. Verify that this mechanism is broken

Expected behavior

I expect upgrading n8n to not break existing workflows using Airtable. We have tables with over 500+ fields and this bug causes data explosion on otherwise efficient workflows.

Operating System

Google Cloud Run

n8n Version

1.39.1

Node.js Version

18.10

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @dkindlund,

This should be fixed in 1.41.0 can you try upgrading, The PR that fixes this issue can be found here: #9324

[dkindlund]

Thanks, @Joffcom -- do you happen to know if the devs added unit tests to explicitly check for this issue in the future? (Just trying to make sure there are no future regressions around this.)

[dkindlund]

Also, it looks like v1.41.0 is a pre-release -- any idea when it will become the latest release, @Joffcom ?

[dkindlund]

Lastly, @Joffcom , for any legacy workflows that I did not save since upgrading to 1.39.1 -- do you know if the older Output Fields that were saved in those legacy workflows will still be correctly restored after upgrading? Or, do I need to go back through each and every workflow using Airtable and manually fix this issue across all workflows?

[dkindlund]

Okay, @Joffcom , after upgrading to 1.41.0, I see the following:

• The underlying issue has been fixed.
• Legacy workflows that used Airtable that were not recently saved have their Output Fields restored.
• Any new or updated workflows that used Airtable and were recently saved post 1.39.1 had their Output Fields obliterated and you'll have to manually go back in and fix each and every Airtable-specific workflow.

[Joffcom]

Hey @dkindlund

Most of the time if we fix an issue we will add a test, Looking at the PR a test has been added to check for this in the future.

This issue only impacts newly created nodes or recently opened nodes that used that UI component. It was not an Airtable specific issue.

While 1.41.0 is marked as pre-release there have not been any bugs in it so far to suggest that it will get a .1 release before it becomes latest on Wednesday when we release 1.42.0 but that may change if anything came in last night.

It may also be worth thinking about a test environment if n8n is a core part of what you do just to give you an extra layer when you update to be confident that any critical workflows don't start to fail. While we don't set out to release bugs we do know that sometimes things can sneak through and it is always better to be safe with a test setup that you can manually run a couple of your own workflows to see if the issue occurs.

For now as this issue is already fixed though I am going to close this one. Let me know if you have any other questions on it.