How to update row in NocoDB using ver 0.200

[Keith_Rumjahn]

I’m trying to update a record in nocodb but all the examples use ver 0.90 and before. There is no way to input the row ID into the module, I suspect you need to put it into the expression itself.

All I want to do is update a row that has column name “Keyword”. I’ve inputted the field name as Keyword. In the expression I’ve dragged and dropped the values I want to save. The issue is that I get an error:
{ “error”: “REQUIRED_FIELD_MISSING”, “message”: “Field ‘Id’ is required” }

I suspect I need to input the row ID into the expression but I have no idea how. I’ve tried different combinations and it’s all failed.

Thank you!

[n8n]

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:

[Keith_Rumjahn]

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

[barn4k]

hello @Keith_Rumjahn

Add Id field to the columns. Press “Add Field” >> Name: Id, Value (Expression): {{ $json.Id }}