Interface SupabaseNodeParameters

Source
interface SupabaseNodeParameters {
    dataToSend?: "autoMapInputData" | "defineBelow";
    fieldsUi?: {
        fieldValues: {
            fieldId?: string;
            fieldValue?: string;
        }[];
    };
    filters?: | {
        conditions: {
            condition?: | "is"
            | "gte"
            | "gt"
            | "lte"
            | "lt"
            | "eq"
            | "like"
            | "neq"
            | "fullText"
            | "ilike";
            keyName?: string;
            keyValue?: string;
            searchFunction?: "fts"
            | "plfts"
            | "phfts"
            | "wfts";
        }[];
    }
    | {
        conditions: { keyName?: string; keyValue?: string }[];
    };
    filterString?: string;
    filterType?: "string"
    | "none"
    | "manual";
    inputsToIgnore?: string;
    limit?: number;
    matchType?: "anyFilter" | "allFilters";
    operation?:
        | "create"
        | "get"
        | "getAll"
        | "update"
        | "delete";
    resource?: "row";
    returnAll?: boolean;
    schema?: string;
    tableId?: string;
    useCustomSchema?: boolean;
}

Properties§

§readonly dataToSend?: "autoMapInputData" | "defineBelow"

Default: "defineBelow"

§readonly fieldsUi?: { ... }

Default: {} Type options: {"multipleValueButtonText":"Add Field to Send","multipleValues":true}

§readonly filters?:
    | {
        conditions: {
            condition?: | "is"
            | "gte"
            | "gt"
            | "lte"
            | "lt"
            | "eq"
            | "like"
            | "neq"
            | "fullText"
            | "ilike";
            keyName?: string;
            keyValue?: string;
            searchFunction?: "fts"
            | "plfts"
            | "phfts"
            | "wfts";
        }[];
    }
    | {
        conditions: { keyName?: string; keyValue?: string }[];
    }

Filter to decide which rows get updated Default: {} Type options: {"multipleValues":true}

§readonly filterString?: string
§readonly filterType?: "string" | "none" | "manual"

Default: "manual"

§readonly inputsToIgnore?: string

List of input properties to avoid sending, separated by commas. Leave empty to send all properties.

§readonly limit?: number

Max number of results to return Default: 50 Type options: {"minValue":1}

§readonly matchType?: "anyFilter" | "allFilters"

Default: "anyFilter"

§readonly operation?: "create" | "get" | "getAll" | "update" | "delete"

Default: "create"

§readonly resource?: "row"

Default: "row"

§readonly returnAll?: boolean

Whether to return all results or only up to a given limit

§readonly schema?: string

Name of database schema to use for table Default: "public"

§readonly tableId?: string

Choose from the list, or specify an ID using an expression Type options: {"loadOptionsDependsOn":["useCustomSchema","schema"],"loadOptionsMethod":"getTables"}

§readonly useCustomSchema?: boolean

Whether to use a database schema different from the default "public" schema (requires schema exposure in the Supabase API)