SupabaseInstall

Summary

Update rows in a specified database table by setting column values matching given filter conditions.

Inputs

• Table (required) — Name of the database table to update rows in.
• UI Mode (required) — Choose between Simple mode using form fields or Advanced mode allowing JSON input for update data and filters.
• Columns — In Simple mode, specify columns and their new values to set in the matched rows.
• JSON Data — In Advanced mode, provide a JSON object with the data to update.
• Filters — In Simple mode, specify filters with column, operator, and value to target which rows to update.
• Advanced Filters — In Advanced mode, provide JSON filters to specify which rows to update.

Output shape

an array of JSON objects representing the updated rows returned from the database

The output contains the rows matching the filters after applying the updates. Filters and update data formats depend on the selected UI Mode (Simple or Advanced). If errors occur per item and 'Continue On Fail' is enabled, error information is included in the output.