N8n node - limit of 100

Developer Talk Integrations
1

Your Setup:

  • I’m using the cloud version with n8n 1.109.2 self-hosted

Question:

The n8n community node search method has a limit of 100 records. How can we go beyond this limit with the n8n node ? (I don’t want to use the API / HTTP).

Thanks

2

Did you see this: Rework of n8n-seatable Integration - #20 by cdb

3

Hi @hsteph, as far as I know it’s unfortunately not possible… Having a look at the code behind the search method, it actually runs a simple SQL query which as a 100 records limits if no limit is specified (Query SeaTable with SQL). Maybe this limit could be added as a node parameter, what do you think @cdb?

For now, if you don’t want to use API/HTTP, you could eventually:

  • use a Code node with a javascript or python query function and your own SQL request, but you’ll have to deal with security issues not to expose your credentials in the node code
  • use a Execute command node to run a python script directly from your n8n container, but it implies installing python and the seatable-api library which is doable but eventually too complicated, depending on what you want to do

In short, I don’t see any easy straightforward workaround, but maybe I’m missing something… By the way, the community node had a Make an api call node, which doesn’t seem to exist anymore in the n8n officially integrated :thinking:

Bests,
Benjamin

4

Thanks for the details. I thought this limitation had been dealt with in the official node.

5

Thanks for the info Benjamin,
Please check the Supabase node feature, very similar to what I need, …It should be a standard feature of the Seatable node.

supabase_node
supabase_node636×1122 38.3 KB

6

Hi team, can you push engineering to implement a “Return All” feature ?

I see this as a mandatory feature to build real application.

Let me know your decision, thanks !

Stéphane

7

Currently I am working on Release 6.0 of SeaTable. After that I will work on that issue and increase the limit or add such a “return all” option.

1 Like
8

I have published a version 2.1.0 of the community node. It supports return all for these two actions:

  • get many rows
  • search row

In addition, I improved the search row action, providing separated options for different column types.

Please give it a try and report if everything is working as expected.

9

Thank you,

I should be able to test this next week!

10

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