[BUG] NocoDB 'Get Many' LIMIT Parameter Ignored

[AlexF]

The NocoDB Node node ignores the “Limit” parameter when using the ‘Get Many’ Operation.

Result:

Workflow is super simple:

Information on your n8n setup

• n8n version: 1.77.3
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): Whatever the default is.
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Ubuntu

[Seko_Eltest]

Hi… Still getting the same issue. I found that anything under limit of 10 returns 10, and then after that it is normal.
For example, if there are 30 rows that match the criteria - Limit between 1 to 10 returns 10 rows for all values. Limit of 11 returns 11, and normal behaviour after that.

[AlexF]

I am also still having the same issue, though it’s interesting that it works for N > 10.

I know it’s a bit of a hack, but you might be able to use the “Limit” node after if it doesn’t conflict with the rest of your workflow.