How to update an Airtable record to return empty instead of current data

Describe the problem/error/question

n8n is returning an error when I attempt to fill up a field with {{null}}, or {{“”}}, how can I erase the data from an airtable field?

What is the error message (if any)?

‘Category’ expects one of the following values: [enrolled, trial, extra lesson, pending reg, rejoin, agent, relief, test, overdue] but we got ‘’

Please share your workflow

Share the output returned by the last node

ExpressionError: Invalid input for 'Category' [item 0]
    at validateValueAgainstSchema (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1277:15)
    at getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1314:18)
    at Object.getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1590:24)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/actions/record/update.operation.js:77:52)
    at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/actions/router.js:48:79)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/AirtableV2.node.js:20:32)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:658:42)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:631:68
    at processTicksAndRejections (node:internal/process/task_queues:95:5)

Hi @Dennis_Yu, I am very sorry you are having trouble. Sending null should work in theory, even for a single input field. I’ve just tested this on the current version of n8n 1.7.1:

Your error ExpressionError: Invalid input for 'Category' would suggest a problem with the expression you have in use though. Can you confirm the exact version of n8n you have in use and the input data you are referencing in your Airtable node?

I am currently running on 1.4.1, self hosted server. I’ll get some help updating it if necessary.

The interesting thing to note is that for the linking field “Trial”, it was able to erase the array completely with the {{ “” }} input

Side note, the field on your example,
“my_option”, originally had the data “bar”
after the module, it still returns “bar”
is it possible for it to return empty?

Hi would there be anything I can do?

Hi @Dennis_Yu, apologies I didn’t get back to you yet.

To be honest, I am having a hard time understanding the full logic applied by the Airtable node here. Perhaps you want to simply use an HTTP Request to perform the update you have in mind directly against Airtable’s API?

This way, you can avoid all custom logic applied by n8n’s Airtable node. You will still be able to re-use your existing credentials like so:

You’d need to specify the correct base and table IDs in the URL, and replace Multiselect in the Body Parameters section with the field you want to uclear.

Before:

After:

image

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.