mamad•12mo ago

Hi guyz ! How can I use update supabase

Hi guyz ! How can I use update supabase record node to update a field containing an array? I would to like to push new data at the end of this array

2 Replies

Gaurav Chadha•12mo ago

Hi @mamad, You can use filters in the "Supabase Update Row" node. https://docs.buildship.com/tutorials/supabase-crud#filters. For field containing array you can also refer to this example -

.or('id.in.(5,6,7), arraycol.cs.{"a","b"}')  // Use `()` for `in` filter, `{}` for array values and `cs` for `contains()`.
.or('id.in.(5,6,7), arraycol.cd.{"a","b"}')  // Use `cd` for `containedBy()

.or('id.in.(5,6,7), arraycol.cs.{"a","b"}')  // Use `()` for `in` filter, `{}` for array values and `cs` for `contains()`.
.or('id.in.(5,6,7), arraycol.cd.{"a","b"}')  // Use `cd` for `containedBy()

Integrate Supabase DB with BuildShip – BuildShip

A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.

mamadOP•12mo ago

Hi @Gaurav Chadha thank you for your answer i'm ok with the flltering but my question was about the field "Data" in update supabase row" nodes , i tried several things but i'm little bit stuck , i tried to use this to update the field : { "field": (x)result[0].field.push("test") } "result" is the result return by the GET node i did before i use the update node