nodes/generated

Interface DataTableNodeParameters

Source


interface DataTableNodeParameters {
    columns?: {
        column: {
            name: string;
            type?: "string" | "number" | "boolean" | "date";
        }[];
    };
    dataTableId?: {
        mode: "id"
        | "list"
        | "name";
        value: string;
    };
    filters?: {
        conditions: {
            condition?: string;
            keyName?: string;
            keyValue?: string;
        }[];
    };
    limit?: number;
    matchType?: "anyCondition"
    | "allConditions";
    newName?: string;
    operation?:
        | "create"
        | "get"
        | "update"
        | "list"
        | "delete"
        | "upsert"
        | "insert"
        | "deleteRows"
        | "rowExists"
        | "rowNotExists"
        | "clear";
    options?: | { dryRun?: boolean }
    | { optimizeBulk?: boolean }
    | { createIfNotExists?: boolean }
    | {
        filterName?: string;
        sortDirection?: "asc" | "desc";
        sortField?: "name" | "createdAt" | "updatedAt";
    };
    orderBy?: boolean;
    orderByColumn?: string;
    orderByDirection?: "ASC"
    | "DESC";
    resource?: "row" | "table";
    returnAll?: boolean;
    tableName?: string;
}

Properties§

§readonly columns?: { ... }

The columns to create in the data table Default: {} Type options: {"multipleValues":true}

§readonly dataTableId?: { ... }

Default: {"mode":"list","value":""}

§readonly filters?: { ... }

Filter to decide which rows get Default: {} Type options: {"multipleValues":true,"minRequiredFields":1}

§readonly limit?: number

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

§readonly matchType?: "anyCondition" | "allConditions"

Default: "anyCondition"

§readonly newName?: string

The new name for the data table

§readonly operation?:
    | "create"
    | "get"
    | "update"
    | "list"
    | "delete"
    | "upsert"
    | "insert"
    | "deleteRows"
    | "rowExists"
    | "rowNotExists"
    | "clear"

Default: "insert"

§readonly options?:
    | { dryRun?: boolean }
    | { optimizeBulk?: boolean }
    | { createIfNotExists?: boolean }
    | {
        filterName?: string;
        sortDirection?: "asc" | "desc";
        sortField?: "name" | "createdAt" | "updatedAt";
    }

Default: {}

§readonly orderBy?: boolean

Whether to sort the results by a column

§readonly orderByColumn?: string

Choose from the list, or specify using an expression Default: "createdAt" Type options: {"loadOptionsDependsOn":["dataTableId.value"],"loadOptionsMethod":"getDataTableColumns"}

§readonly orderByDirection?: "ASC" | "DESC"

Sort direction for the column Default: "DESC"

§readonly resource?: "row" | "table"

Default: "row"

§readonly returnAll?: boolean

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

§readonly tableName?: string

The name of the data table to create