Link columns limit 10 clarification / documentation / API Gateway / n8n

Hello, I’m not sure how to approach this - maybe ask for clarification first.

In a rather complex data sync workflow using seatable, I ran into the issue that obviously, there is a limit of 10 links per link column that is being returned by the API standard calls. I have found a quite old issue where @daniel.pan mentioned this, linking to an obsolete API documentation.

The limit makes sense IMHO. However, it took me hours to figure the following out, and I came to the conclusion that there are still some inconsistencies.

  • A “10 links per record returned” limit seems to apply to both List Rows and Get Row, is that correct? (API Gateway)
    • There is no parameter in the API call to extend this limit, not even in a single row retrieval?
    • If this is so, both facts should be stated in the documentation
  • I was utterly confused by the fact that the deprecated Pre-Gateway Calls (List Rows) seemed to have returned all the links at once. I just verfied that.
  • Is it true that in order to get all links from the API gateway, we have to explicitly use List Row Links
    • and specify limit to overcome the 10 link default?
  • Finally: All this is not realizied in the GUI of the n8n Seatable nodes, therefore making them a source of frustration
    • I reverted to pure HTTP calls for the time being
    • If you should fix something in n8n, have a look at the default behaviour while at it
      • When you have no options set, the “simple” and “column name” options default to “true”
      • In the old nodes, the default was “false/true”
      • It’s a bit confusing, but manageble. However, a hint in the interface would be nice.

There is no parameter in the API call to extend this limit, not even in a single row retrieval.

But in version 5.3, we will extend the limit to 50 linked row ids.

The old API has performance issues, including regarding links, so they will be removed soon.

Yes.

The API document has been updated.