Issues with Supabase "Delete a Row" node: unable to find metadata

Describe the problem/error/question

Hi all,

I’m trying to delete a row from a Supabase table using the Supabase node in n8n (version 1.114.4). The row includes a metadata JSONB column with a fileName field.

I’m using this filter:

metadata->>fileName=like.*{{ $json.name }}

I got this approach from Nate Herk’s tutorial, but it doesn’t work in my case. There’s no error, but the row isn’t deleted and no data is returned. Using top-level fields like id=eq.X works fine.

I confirmed via SQL in Supabase that this JSONB filter matches rows:

SELECT * FROM documents WHERE metadata->>'fileName' = '{my file name...';

Can you confirm whether JSONB field filtering is officially supported in the DELETE operation in the Supabase node? Or suggest how to reliably delete based on metadata->>fileName?

Thanks!
Carl

What is the error message (if any)?

No output data.

Please share your workflow

Share the output returned by the last node

no output

Information on your n8n setup

  • n8n version: newest
  • Database (default: SQLite): Supabase
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloud

JSONB filtering is supported in the Supabase node, but in the workflow shared the issue isn’t with the filter. The error indicates that the Supabase credential couldn’t fetch the table list.

Once the connection is fixed (correct project URL + service role key), the JSONB filter used will work as expected.
The screenshot version of my working “Delete Row” configuration: