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
