Interface QuickBaseNodeParameters

Source
interface QuickBaseNodeParameters {
    binaryPropertyName?: string;
    columns?: string;
    fieldId?: string;
    limit?: number;
    mergeFieldId?: string;
    operation?:
        | "create"
        | "get"
        | "getAll"
        | "update"
        | "delete"
        | "upsert"
        | "download"
        | "run";
    options?: | { includeFieldPerms?: boolean }
    | { fields?: unknown[]; useFieldIDs?: boolean }
    | {
        select?: unknown[];
        sortByUi?: {
            sortByValues: {
                fieldId?: string;
                order?: "ASC" | "DESC";
            }[];
        };
        where?: string;
    };
    recordId?: string;
    reportId?: string;
    resource?: "record"
    | "file"
    | "report"
    | "field";
    returnAll?: boolean;
    simple?: boolean;
    tableId?: string;
    updateKey?: string;
    versionNumber?: number;
    where?: string;
}

Properties§

Source§

readonly binaryPropertyName?: string

Default: "data"

Source§

readonly columns?: string

Comma-separated list of the properties which should used as columns for the new rows

Source§

readonly fieldId?: string

The unique identifier of the field

Source§

readonly limit?: number

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

Source§

readonly mergeFieldId?: string

You're updating records in a Quick Base table with data from an external file. In order for a merge like this to work, Quick Base needs a way to match records in the source data with corresponding records in the destination table.

You make this possible by choosing the field in the app table that holds unique matching values. This is called a merge field.

. Choose from the list, or specify an ID using an expression. Type options: {"loadOptionsMethod":"getUniqueTableFields"}
Source§

readonly operation?:
    | "create"
    | "get"
    | "getAll"
    | "update"
    | "delete"
    | "upsert"
    | "download"
    | "run"

Default: "getAll"

Source§

readonly options?:
    | { includeFieldPerms?: boolean }
    | { fields?: unknown[]; useFieldIDs?: boolean }
    | {
        select?: unknown[];
        sortByUi?: {
            sortByValues: {
                fieldId?: string;
                order?: "ASC" | "DESC";
            }[];
        };
        where?: string;
    }

Default: {}

Source§

readonly recordId?: string

The unique identifier of the record

Source§

readonly reportId?: string

The identifier of the report, unique to the table

Source§

readonly resource?: "record" | "file" | "report" | "field"

Default: "record"

Source§

readonly returnAll?: boolean

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

Source§

readonly simple?: boolean

Whether to return a simplified version of the response instead of the raw data Default: true

Source§

readonly tableId?: string

The table identifier

Source§

readonly updateKey?: string

Update can use the key field on the table, or any other supported unique field

Source§

readonly versionNumber?: number

The file attachment version number Default: 1

Source§

readonly where?: string

The filter to delete records. To delete all records specify a filter that will include all records, for example {3.GT.0} where 3 is the ID of the Record ID field.