Upsert with Supabase

[Keith_Warren]

What is your goal?

I have a Supabase database and I’m using a webhook to populate the database. I want to use the member_number field to check for duplicates. If that field exists, update it. If not, create a new record.

What is the problem?

Works fine for new records. But I don’t see the OnConflict field in make to signal that is the field to check for updates. Why am I not seeing it?

What have you tried so far?

The supabase database field is set for Unique. This was done after I initially set up the Make scenario. I have changed the table in Make, refreshed, then changed it back to the correct table to see if the mapping needed to be refreshed. That didn’t change anything.

Screenshots: scenario setup, module configuration, errors

[stevemarkovick]

Trying to get upsert working in Supabase through Make can be a bit confusing at first, especially with the missing OnConflict field. I’ve run into similar issues where the module doesn’t expose all options, and usually it comes down to how the table schema was initially detected. Reconnecting or rebuilding the module sometimes helps, but checking Supabase upsert API behavior directly might save time.