Nocodb node update row problem

Questions
1

Hello,

I have a problem with the NocoDB node and especially with the update operation of the node. No matter what number I write in the “row_id” param, this node updates all my rows and not just the specific row I want.

Here are the params of my node :

image
image680×970 27.6 KB

So, I have tried to update my row with a simple HTTP request and it works perfectly.

Then, I suggest that there is a pb in the NocoDB node with the update row option. But I don’t know if I’m doing something wrong with this node or if there is actually a problem with the node.

Does anyone have the same issue with the NocoDB update row operation?

2

Hey @clac!

I tested the NocoDB node and it works for me as expected. It only updates the Row that I specify.

3

Thanks for your answer @harshil1712 !

So the pb should come from my setup. What are the params of the node you used please ?

Thanks !

4

My node looks similar to yours. Here’s the screenshot

Screenshot 2021-08-25 at 2.33.52 PM
Screenshot 2021-08-25 at 2.33.52 PM2326×1412 216 KB

1 Like
5

Okay, thank you very much ! I will dig deeper in my config to see where is the pb. Thanks :slight_smile:

6
  1. NocoDB update node uses bulk update API
  2. Bulk update API is not generating WHERE clause in the SQL statement - this is a NocoDB bug (a pretty critical one if you ask me)

I’ve just created a bug report :slight_smile:

Until this bug is fixed, you should not use this n8n node (at least on PostgreSQL - the setup I’ve verified this bug)