nodes/generated

Interface QuickBaseNodeParameters

Source
interface QuickBaseNodeParameters {
    binaryPropertyName?: string;
    columns?: string;
    fieldId?: string;
    limit?: number;
    mergeFieldId?: string;
    operation?:
        | "create"
        | "get"
        | "getAll"
        | "update"
        | "delete"
        | "upsert"
        | "run"
        | "download";
    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§

§readonly binaryPropertyName?: string

Default: "data"

§readonly columns?: string

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

§readonly fieldId?: string

The unique identifier of the field

§readonly limit?: number

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

§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"}
§readonly operation?:
    | "create"
    | "get"
    | "getAll"
    | "update"
    | "delete"
    | "upsert"
    | "run"
    | "download"

Default: "getAll"

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

Default: {}

§readonly recordId?: string

The unique identifier of the record

§readonly reportId?: string

The identifier of the report, unique to the table

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

Default: "record"

§readonly returnAll?: boolean

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

§readonly simple?: boolean

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

§readonly tableId?: string

The table identifier

§readonly updateKey?: string

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

§readonly versionNumber?: number

The file attachment version number Default: 1

§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.