Supebase returns less items

[EmeraldHerald]

Hi @Tbiyss

While I can understand your expectation here, enabling Always Output Data will cause n8n to return a single empty item if otherwise no item is returned, but it won’t respect the number of incoming items. That split items workaround you mentioned would be a workaround that helps with all nodes in n8n in these cases, not just Supabase

You could try this SQL query to do what you’re looking for, though:

How to check if a Row exist in Supabase?

Hi @YogiYang, welcome to the community! I think the cleanest way would be to use the PostgreSQL node. Supabase allows direct connections to the PostgreSQL database, with the credentials being available under Project Settings → Database. Assuming my Supabase table looks like this: [image] And my n8n data looks like so: [image] I could then run a simple SQL query telling me if a row exists or not, for example like so: [image] In a workflow this approach would look like so, I’ve also adde…

You would unfortunately still need an extra node, as the Supabase node itself doesn’t have the option to run custom SQL queries.