[NocoDB] Getting 422 error when trying to update a record – how to solve this?

[NocoDB] Getting 422 error when trying to update a record – how to solve this?

Describe the problem/error/question

Hello everyone, the NocoDb webhook trigger that triggers n8n is set to perform operations respectively by following the switch node, but I'm trying to update a record in NOCODB using the NocoDB node in n8n, but I'm getting the following error:

What is the error message (if any)?

-Error code,422
-Full message
{ "msg": "Primary key is required" }
This primary key is not anywhere so if you have experience any nocodb like this issue, can you help me about this? 

Please share your workflow

This is all workflow page:

Share the output returned by the last node

The last node output:

Information on your n8n setup

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

You need to map the id first, then you can update the row that you want. I used to have the same problem and this fixed to me.

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