Against API docs, ListRows without View does not deliver hidden fields in n8n

User Talk Automations
1

The (beautiful new - btw) documentation of ListRows ( List Rows ) says that ListRows without a filter does deliver the hidden fields like _id as well.

When using the “Get Many [Rows]” node in a current n8n installation, the defined fields show up, but not the hidden ones.

image
image1920×1696 112 KB

The same issue occurs when I use the “Do not limit to a view” selection at “View Name”.

Previously the hidden fields were delivered, and my processing logic used the _id field. ( Maybe you can bring back the hidden fields anyway, not only when not using a view )

Your Setup:

  • cloud hosted seatable
  • self hosted n8n (version 1.100.1)
2

Didn’t have the time to check this currently, but from recent memory:

Go to the Options section: Add the option “simple” explicitly, and make sure it’s turned off. You should have your hidden columns back.

Turns out, the default behaviour without adding the “Simple” option is “Simple = True”

It’s a bit confusing. In my opinion, a missing option should equal “Option = False”