Airtable update node cannot update encountering null values

Questions
1

Now, there is a need to regularly update AirTable with a data source. Suddenly, it was discovered that if a certain field in the data source has no value, the field in AirTable will not be updated.

The result is: After a field value of the data source is deleted, the corresponding resource information in AirTable is still retained.

image
image563×1100 44.3 KB

image
image3840×1970 511 KB

  • n8n version:1.18.2
  • Database (default: SQLite):default
  • Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
  • Operating system:Windows 10
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
4

Hi @shangzhw, I am sorry you are having trouble.

I was able to reproduce this behaviour and have added it to our internal bug tracker for a closer look and fix.