Validation error with data table request: unknown column name ‘action’
I am trying to update the data table row but get error, i added outparser to sovle it but it didn not help**. Error: Problem in node ‘Update row(s) in Data table‘. Validation error with data table request: unknown column name ‘action’**
Here is the workflow:
the error ‘unknown column name action’ usually means the AI Agent is trying to write a field that doesn’t exist in your data table schema. your schema only has tasks, done, note, sessionId — so either the agent is generating an extra field or the $fromAI() token in your filter isn’t parsing the AI output correctly.
two things to check: first, add a Structured Output Parser sub-node after the AI Agent with EXACT field names matching your data table (tasks, done, note only). second, make sure your Data table Tool isn’t trying to set fields that don’t exist — the mappingMode should be set to match your schema, not autoMapInputData which might pick up random fields from the agent output.
if thats still failing, try a simple test: remove the filter completely and just do an insert with hardcoded values to make sure the data table connection works. then add complexity back one step at a time
@Benjamin_Behrens Solution is good one precise!