N8n plugin does not deliver output in case of empty Search Records

[dakoller]

Hi,

I use the Seatable node in n8n to distinguish, whether a record with specific content in a specific field is present. After that determination, an existing Seatble record would be updated or newly created.

Unfortunately the node with the “Search a row for a keyword” - in case no record is found - delivers no output. And I didn’t find a way how n8n meaningfully can deal with a node, which returns node data.

In case nothing is found it may be better if the node returns a state message in json, which can be parsed.

(The whole picture might be easier, if the seatable node in n8n would support an upsert operation - like create a record if a key does not exist or update a record in case the key ecists.)

Best regards,

Daniel

Your Setup:

• SeaTable Cloud, Dedicated or Self-hosted?
• Selfhosted n8n, version 1.102.4
• Cloud seatable

Describe the Problem/Error/Question:

Please describe your issue as precise as possible. If helpful, you can also provide:

• Screenshots
• Diagrams with Excalidraw
• Base structure details using this script.

Error Messages:

If there are any error messages shown in the browser console, please include them for better readability by wrapping them in a code block.

Example of a code block for error messages

[bha]

Hi @dakoller,
Sorry I just had a very quick look, but maybe you could use the Always Output Data option (in the Settings tab of the node) and then check if _id exists in the output for example…

Bests,
Benjamin

[dakoller]

thx @bha, that worked.

The object returned is [{}] (in json) and one can test for the emptyness of the search result with {{ $input.first()._id }}.