[N8N] False positive in INSERT
Hello everyone, this is my first help post here, I hope you can help me.
Context:
I have a free account on the platform, which is already pretty good to use.
I currently have a workflow where I use Supabase Node for data insertion and querying.
For the past week, I've been experiencing false positives when inserting data. I'll try to explain.
In Supabase Node, when an insertion is successful, it returns the inserted result in the output, as shown in the image below.
[Image 1]
I also noticed that there's an insertion log:
[image 2]
However, when I search for the data, it's not found by any of the columns I'm trying to filter.
[image 3]
Regarding rules, I only have the insertion rule created months ago.
[image 4]
I really need your help!
5 Replies
Could you please share:
1. A screenshot of the Supabase node return statement.
2. Your table schema.
3. Also, how many rows does that table has?
Just want to see if you might be missing something...
Hello @tomaspozo , thank you for your interaction.
1- As I mentioned, especially with the Supabase node, it returns the inserted value. If I use the Postgres node, it returns the JSON success: true.
2- Regarding the schema, I've attached an image.
3- The table has 24 rows, but in this specific INSERT, 11 columns are inserted into one row.
Important: This problem started at the beginning of this month, but it had been running for 6 months without problems.
thanks for sharing! so there is no record with ID 6509? Is weird... will try to replicate this with my n8n... what module are you using?
I'm using the module that comes from Supabase, the default when it's installed.