SupabaseInstall

Summary

Read rows from a specified Supabase database table applying optional filters, sorting, limits, and field selections.

Inputs

• UI Mode — Select 'Simple' for form-based filters or 'Advanced' to use JSON for filters.
• Table (required) — Name of the table to query, selectable from your Supabase schema.
• Filters — In 'Simple' mode, provide one or more filters by specifying column, operator, and value to restrict rows.
• Advanced Filters — In 'Advanced' mode, provide a JSON object with complex filter conditions.
• Return Fields — Comma-separated list of fields to return from each row; use '*' to return all fields.
• Sort — Specify one or more columns to sort the results by, with ascending or descending order.
• Limit — Maximum number of rows to retrieve; defaults to 100.
• Offset — Number of rows to skip before starting to return rows; defaults to 0.

Output shape

a list of database rows matching the query

The returned rows contain only the requested fields and respect filters, sorting, limit, and offset values. Error envelopes may be returned if 'continueOnFail' is enabled.