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§

Source§

readonly dataToSend?: "autoMapInputData" | "defineBelow"

Default: "defineBelow"

Source§

readonly fieldsUi?: { fieldValues: { fieldId?: string; fieldValue?: string }[] }

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

Source§

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}

Source§

readonly filterString?: string

Source§

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

Default: "manual"

Source§

readonly inputsToIgnore?: string

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

Source§

readonly limit?: number

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

Source§

readonly matchType?: "anyFilter" | "allFilters"

Default: "anyFilter"

Source§

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

Default: "create"

Source§

readonly resource?: "row"

Default: "row"

Source§

readonly returnAll?: boolean

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

Source§

readonly schema?: string

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

Source§

readonly tableId?: string

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

Source§

readonly useCustomSchema?: boolean

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