Problem with NocoDB Update Node: "Invalid data type or value for column 'unknown'"

[Loc_Bao]

I am encountering a Bad request - please check your parameters error when using the NocoDB Update Node in my workflow. The detailed error message is:

css

Sao chép mã

Error Code: 400
Error Message: { "error": "DATABASE_ERROR", "message": "Invalid data type or value for column 'unknown'.", "code": "22P02" }

Workflow Details:

1. I use a Webhook Node to receive incoming data.
2. A NocoDB GetAll Node (NocoDB1) checks if a record exists in the database, using order_id as the condition.
3. Based on the existence of the record:

• If it exists, I pass the Id (Primary Key) to the NocoDB Update Node (Update_Order3).
• If it doesn’t exist, a new record is created.

Issues Observed:

• The NocoDB Update Node fails with the error above.
• The Primary Key (Id) is fetched from NocoDB1 and passed to Update_Order3 in the id field.
• All other fields (status, order_id) are mapped from the Webhook data.

Steps I Have Taken:

1. Verified that NocoDB1 correctly fetches the Id of the existing record.
2. Ensured field names in Update_Order3 match the table schema in NocoDB.
3. Checked the data types of each field (e.g., status as string, order_id as string).
4. Confirmed the API token has the necessary permissions.
5. Debugged the expressions in n8n and ensured they resolve correctly.

Request: I would appreciate any guidance on:

1. Why the error mentions “unknown” as the column.
2. How to resolve this error and ensure the update operation works correctly.

Additional Info:

• NocoDB table schema includes id as the Primary Key.
• n8n version: 1.72.1 (Cloud)
• NocoDB Node version: 2 (Latest version: 3)

[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:

[ria]

Hi @Loc_Bao

Perhaps the id is an integer in NocoDB, but the workflow is passing it as a string? It would help if you could share your workflow and ideally some dummy data with it.

Tip for sharing your workflow in the forum

Pasting your n8n workflow

---

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

Make sure that you’ve removed any sensitive information from your workflow and include dummy data or pinned data as much as you can!

---

[Jason_Henriksen]

For me in the past this error is because i am setting data that does not fit a field type in my case a decimal where i set the column as a number.